EXCEL SHORTCUTS – CHEAT SHEET

EXCEL SHORTCUTS CHEAT SHEET

KEYFUCTIONKEYFUNCTION
F1Display the Office Assistant or (Help >Microsoft Excel Help)Shift +F10Display the (Shortcut)menu for the selected item
F2Edits the active cell, putting the cursor at the endShift +F11Inserts a new worksheet (before the active sheet)into the active workbook
F3Display the (insert>Name>Paste dialog box Shift +F12Saves , Displays the (File> Save As )dialog box if a new workbook
F4Repeats the last worksheet action (Edit> Repeat)Ctrl+F1Close and reopens the current task pane (ribbon in 2007 )
F5Display the (Edit >Go To )dialog boxCtrl+F2Print Preview
F6Moves to the next pane in a workbook (if the window is split )Ctrl+F3Display the (insert >Name >Define )dialog box
F7Display the (Tools > Spelling) dialog boxCtrl +F4Close the selected workbook window
F8Toggles whether to extend a selection with the arrow keysCtrl+F5Restores the size of the active workbook or window
F9Calculates all the Worksheets in All the open workbooksCtrl+F6Moves to the next open workbook or window
F10Toggle the activation of the Menu BarCtrl+F7Activates the Move window command
F11Display the (insert > Chart sheet )using the highlighted rangeCtrl+F8Activates the Resize window command
F12Displays the (File >Save As ) dialog boxCtrl +F9Minimizes the size of the active workbook or window
Shift +F2 Inserts or edits a cell comment (Insert>Comment )Ctrl+F10Maximizes the size of active workbook or window
Shift +|F3Display the )Insert> Function)dialog boxCtrl +F12Display the (File >Open )dialog box
Shift +F4Repeats the last Find, the same as (Edit >Find Next )Alt +F1 Creates a chart (on a chart sheet )
Shift +F5Display the (Edit> Find)dialog boxAlt +F2Display the (File >Save as ) dialog box
Shift +F6Moves to the previous pane in a workbook (if the window is split )Alt +F4Close all the workbooks (saving first )and exits Excel (File > Exit )
Shift +F8Toggles between switching Add Mode on or offAlt +F8Displays the (Tools > Macro > Macros) dialog box
Shift +F9Calculates just the active worksheet  

1 thought on “EXCEL SHORTCUTS – CHEAT SHEET”

Leave a Comment

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

PC Tips By Ritesh