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]

Leave a Reply

Close Menu