Return to site

Create a new keyboard shortcut for excel 2016 for mac

broken image

Select from the insertion point to beginning/ end of cell

broken image

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

broken image

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