How To Use Shortcuts For Microsoft Excel

Step 1: Select the current column

Type CTRL + spacebar to select the current column

Step 2: Select the current row

Type SHIFT + spacebar to select the current row

Step 3: Move to the beginning

If you want to move to the beginning of the worksheet, use CTRL + Home

Step 4: Move to the end

To move to the last cell of the worksheet, use CTRL + End.

Step 5: Paste a function

To past a function into a formula, type SHIFT + F3

Step 6: Select all

To select everything (when you are not editing or editing a formula) type CTRL + A

Step 7: Calculate all the sheets

To calculate all the sheets in an active worksheet, use F9

Step 8: Calculate active worksheet

Use SHIFT + F9 to calculate the active worksheet.

Step 9: Display go to box

Press F5 to display the 'Go To' box

Step 10: Date

To enter the current date into the active cell - type CTRL + ;

Step 11: Time

To enter the current time into the active cell, type CTRL + :

Step 12: Enter / edit cell comments

To enter or edit a cell comment in the active cell, type SHIFT + F2

Step 13: Copy functions

To copy the contents of a cell to the cell directly to the right, select the cell in which you want the copy, and then press CTRL + R.

To copy the contents of a cell to the cell directly below it, select the cell you want to receive the copy, and type CTRL + D

Step 14: Switch to formula view

If you want to view all the formulas in a worksheet, press CTRL + ~ . Use this shortcut again to switch back to normal view.