How To Use Shortcuts For Microsoft Excel
VideoJug presents a short film showing how best to use shortcuts for Microsoft Excel. Speed up your work on Microsoft Excel with these great shortcut tips from VideoJug.
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.