Excel Shortcuts

Do you have a list of popular MS Excel shortcuts?

Become a Master Craftsman

Sometimes you need to copy a formula or data to a series of non-sequential cells. You can do this quickly without having to paste it into each cell individually. First copy the data from the source cell. Then hold down the Ctrl key as you click on each destination cell. Once all the cells are highlighted, you can paste the data by pressing Ctrl-Enter.

Similarly, you can type data into a series of cells. Again, while holding down the Ctrl key, click on all the cells you want to enter the text into. Next, type the text you are entering and then press Ctrl-Enter to add the text to all the selected cells.

F2: Edit a cell’s contents.
Ctrl-c: Copy
Ctrl-v: Paste
Ctrl-x: Cut
Ctrl-a: Highlight document
Ctrl-1: Open the Format Cells dialog.
Ctrl-Page Up: Move to the next sheet in the workbook.
Ctrl-Page Down: Move to the previous sheet in the workbook.
Ctrl-Shift-”: Copy the value from the cell above into the current cell.
Ctrl-’: Copy the formula from the cell above into the current cell.
Ctrl-R: Fill contents of active cell into selected cells to the right.
Ctrl-D: Fill contents of active cell into selected cells down.
Ctrl-`: Toggle between showing cell values and formulas in cells.
Ctrl-$: Set selection to currency format with two decimal places