Repeat if you want to toggle from absolute reference to partial or complete removal ($E$4 -> E$4 -> $E4 -> returning to E4.Įdit arguments of formula at cursor position

Select or unselect one word to the left/ rightĭelete one character to the right/ left of cursorĬomplete cell entry and move one cell down/ upĬomplete cell entry and move one cell right/ leftĬomplete cell entry and don't move selectionĭuplicate value from Cell above into current cell at cursor positionĪfter typing cell reference (eg =E4) makes reference absolute (=$E$4). Select from the insertion point to beginning/ end of cell Select one character to the left/ right (or one line up/down) Navigate by one character left/ right or one line up/ down Selects from current end of cursor to beginning These assume you are inside a cell, typically after pressing F2 With cells that are not complete rows/columns - Open delete cell/ row/ column menuįill single cell content down to all cells selected with Shift+ Arrow Downįill single cell content up to all cells selected with Shift+ Arrow Down With cells that are not complete rows/columns - Open insert cell/ row/ column menu Paste Insert - paste column(s) from clipboard and shift existing content to the right Paste Insert - paste row(s) from clipboard and shift existing content downwardĬtrl+ Shift+ + with column(s) in clipboard and column selected Select multiple rows to insert multiple rowsĬtrl+ Shift+ + with row(s) in clipboard and a row selected Select single row, then insert row below. Select single (or multiple) columns, then delete Select multiple rows then insert the same number rows below Shift+ Space, then Shift+ Arrow Up/ Arrow Down, then Ctrl+ Shift+ + Select single row then insert one row above Shift+ Space, then Shift+ Arrow Up/ Arrow Down, then Ctrl+. 1.4 Insert Rows, Columns and Duplicate Content

Border drop down menu excel 2016