Shortcut Keys > Description
F2 > Edit the selected cell.
F5 > Go to a specific cell. For example, C6.
F7 > Spell check selected text and/or document.
F11 > Create chart.
Ctrl + Shift + ; > Enter the current time.
Ctrl + ; > Enter the current date.
Alt + Shift + F1 > Insert New Worksheet.
Shift + F3 > Open the Excel formula window.
Shift + F5 > Bring up search box.
Ctrl + A > Select all contents of the worksheet.
Ctrl + B > Bold highlighted selection.
Ctrl + I > Italic highlighted selection.
Ctrl + K > Insert link.
Ctrl + U > Underline highlighted selection.
Ctrl + 5 > Strikethrough highlighted selection.
Ctrl + P > Bring up the print dialog box to begin printing.
Ctrl + Z > Undo last action.
Ctrl + F9 > Minimize current window.
Ctrl + F10 > Maximize currently selected window.
Ctrl + F6 > Switch between open workbooks / windows.
Ctrl + Page up > Move between Excel work sheets in the same Excel document.
Ctrl + Page down > Move between Excel work sheets in the same Excel document.
Ctrl + Tab > Move between Two or more open Excel files.
Alt + = > Create a formula to sum all of the above cells
Ctrl + ' > Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! > Format number in comma format.
Ctrl + Shift + $ > Format number in currency format.
Ctrl + Shift + # > Format number in date format.
Ctrl + Shift + % > Format number in percentage format.
Ctrl + Shift + ^ > Format number in scientific format.
Ctrl + Shift + @ > Format number in time format.
Ctrl + Arrow key > Move to next section of text.
Ctrl + Space > Select entire column.
Shift + Space > Select entire row.
No comments:
Post a Comment