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+. Please share any shortcuts you generally use while using excel.1.4 Insert Rows, Columns and Duplicate Content Alt + T + M + R - Start / Stop Recording Macro.Alt + W + F + F - Freeze Panes Around Current Cell.ALT + M + A + A - Remove tracing arrows.ALT + M + D - Trace immediate dependents.ALT + M + P - Trace immediate precedents.Alt + D + G + S - Show Grouped Rows / Columns.Alt + D + G + H - Hide Grouped Rows / Columns.Alt + D + G + U - Ungroup Rows / Columns.CTRL+SHIFT+$ – Apply currency format to the selected cells.Alt + O + R + A - Autoformat Row Height.Alt + O + C + A - Autoformat Column Width.

Ctrl + Shift + 5 - Autoformat Percentage Style.

Ctrl + Shift + 4 - Autoformat Currency Style.

Ctrl + Shift + 3 - Autoformat Date Style.

Ctrl + Shift + 2 - Autoformat Time Style.

Ctrl + Shift + 1 - Autoformat Number Style.

Ctrl + R - Copy Formula Right to Fill Selection.

Ctrl + D - Copy Formula Down to Fill Selection.

SHIFT + CTRL + Arrow keys - Highlight contiguous range.

SHIFT + Arrow keys - Select a cell range.

CTRL + Arrow keys - Go to end of contiguous range.

Ctrl + Page-up / Page-down - Move to Next / Previous Worksheet Tab.Ctrl + Arrowkey - Jump to Edge of Content.We will now look at the important and commonly used shortcuts in excel that can speedup your financial modelling work. In the previous lesson, we learned about how to setup excel for productivity.

Excel shortcut keys 2013 pdf