Excel shortcuts to speed up your work.


Click here to download this in Excel
Function
Key
Open [Ctrl] + [O]
Exit [Alt] + [F4]
Move to the beginning of the worksheet [Ctrl] + [Home]
Move to next sheet [Ctrl] + [Page Down]
Move to previous sheet [Ctrl] + [Page Up]
Convert to a percentage [Ctrl] + [Shift] + [%]
Apply outline to active cell [Ctrl] + [Shift] + [&]
Applies the Date format. [Ctrl]+[Shift]+[#]
Formats the current cells as Currency. [Ctrl]+[Shift]+[$]
Applies the General format. [Ctrl]+[Shift]+[~]
Edit the active cell [F2]
Paste a name into a formula [F3]
Repeat the last action [F4]
Display the Go To dialog box [F5]
Moves to the next pane in a split worksheet. [F6]
Check spelling of current cell [F7]
Calculate all sheets in all open workbooks [F9]
Activate the menu bar [F10]
Create a chart [F11]
Complete a cell entry and move right [Tab]
Display the Macro dialog box [Alt] + [F8]
Move one screen right [Alt] + [Page down]
Move one screen left [Alt] + [Page Up]
Insert a new sheet [Alt] + [Shift] + [F1]
Inserts the AutoSum function. [Alt]+[=]
Opens the VBA Editor or switches to it if it’s already open. [Alt]+[F11]
Alternate value/formula view [Ctrl] + [`]
Display the Format Cells dialog box [Ctrl] + [1]
Press once to position cursor to extreme right of the worksheet. [Ctrl] + [Right Arrow]
Press once to position cursor to extreme down of the worksheet. [Ctrl] + [Down Arrow]
Move to the last cell on the worksheet [Ctrl] + [End]
Select all filled cells around active cell [Ctrl] + [Shift] + [*]
Select the current column [Ctrl] + [Space]
Inserts the current date. [Ctrl]+[;]
Opens the Define Name dialog box. [Ctrl]+[F3]
Moves to the next workbook window. [Ctrl]+[F6]
Automatically creates Named Ranges from the headers for the selected table of data [Ctrl]+[Shift]+[F3]
Moves back to the last workbook window. [Ctrl]+[Shift]+[F6]
Move one screen down [Page down]
Move one screen up [Page Up]
Complete a cell entry and move up [Shift] + [Enter]  
Edit a cell comment [Shift] + [F2]
Repeat Find [Shift] + [F4]
Display the Find dialog box [Shift] + [F5]
Select the current row [Shift] + [Space]
Complete a cell entry and move left [Shift] + [Tab]
Displays the shortcut menu that applies to where the cursor is located. [Shift]+[F10]
Inserts an equal sign (=) and opens the Paste Function dialog box to help you pick a formula. [Shift]+[F3]
Moves to the previous pane. [Shift]+[F6]

Add a Comment

Your email address will not be published. Required fields are marked *