Excel Hacks – Part 1

Function Keys
F1 Displays the Office Assistant or (Help > Microsoft Excel Help) 
F2 Edits the active cell, putting the cursor at the end 
F3 Displays the (Insert > Name > Paste) dialog box 
F4 Repeats the last worksheet action (Edit > Repeat) 
F5 Displays the (Edit > GoTo) dialog box 
F6 Moves to the next pane in a workbook (if the window is split) 
F7 Displays the (Tools > Spelling) dialog box 
F8 Toggles whether to extend a selection with the arrow keys 
F9 Calculates All the worksheets in All the open workbooks 
F10 Toggles the activation of the Menu Bar 
F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range 
F12 Displays the (File > Save As) dialog box 

Shift & Function Keys
Shift + F2 Inserts or edits a cell comment (Insert > Comment) 
Shift + F3 Displays the (Insert > Function) dialog box 
Shift + F4 Repeats the last Find, the same as (Edit > Find Next) 
Shift + F5 Displays the (Edit > Find) dialog box 
Shift + F6 Moves to the previous pane in a workbook (if the window is split) 
Shift + F8 Toggles between switching Add Mode on or off* 
Shift + F9 Calculates just the active worksheet
Shift + F10 Displays the (Shortcut) menu for the selected item 
Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) 
Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook 

Control & Function Keys
Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007) 
Ctrl + F2 Print Preview 
Ctrl + F3 Displays the (Insert > Name > Define) dialog box 
Ctrl + F4 Closes the selected workbook window 
Ctrl + F5 Restores the size of the active workbook or window 
Ctrl + F6 Moves to the next open workbook or window 
Ctrl + F7 Activates the Move window command 
Ctrl + F8 Activates the Resize window command 
Ctrl + F9 Minimises the size of the active workbook or window 
Ctrl + F10 Maximises the size of the active workbook or window 
Ctrl + F12 Displays the (File > Open) dialog box 

Alt & Function Keys
Alt + F1 Creates a chart (on a chart sheet) using the highlighted range 
Alt + F2 Displays the (File > Save As) dialog box 
Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit) 
Alt + F8 Displays the (Tools > Macro > Macros) dialog box
Alt + F11 Toggles between the Visual Basic Editor window and and the Excel window

Control & Number
Ctrl + 0 Hides the columns in the current selection 
Ctrl + 1 Displays the formatting dialog box 
Ctrl + 2 Toggles bold on the current selection 
Ctrl + 3 Toggles italics on the current selection 
Ctrl + 4 Toggles underlining on the current selection 
Ctrl + 5 Toggles the strikethrough of text on the current selection 
Ctrl + 6 Toggles between hiding, displaying 
Ctrl + 8 Toggles the display of Outline symbols on the active worksheet 
Ctrl + 9 Hides the rows in the current selection (Format > Row > Hide)

Control, Shift & Number
Ctrl + Shift + 0 Unhides the columns in the current selection 
Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell 
Ctrl + Shift + 8 Selects the current region (surrounded by blank rows and columns) 
Ctrl + Shift + 9 Unhides the rows in the current selection 

Control, Shift & Function
Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box 
Ctrl + Shift + F6 Moves to the previous open workbook or window 
Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007 
Ctrl + Shift + F12 Displays the (File > Print) dialog box 

Control, Shift & Letter
Ctrl + Shift + F Activates the Font Tab of the format cells 
Ctrl + Shift + O Selects all the cells with comments 
Ctrl + Shift + P Activates the Font Size tab of the format cells 

Control & Letter
Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date 
Ctrl + B Toggles bold on the current selection 
Ctrl + C Copies the current selection to the clipboard 
Ctrl + D Copies the first cell in the selection downwards 
Ctrl + F Displays the Find dialog box 
Ctrl + G Displays the GoTo dialog box 
Ctrl + H Displays the Replace dialog box 
Ctrl + I Toggles italics on the current selection 
Ctrl + K Displays the Insert Hyperlink dialog box 
Ctrl + L Displays the Create Table dialog box 
Ctrl + N Creates a new workbook 
Ctrl + O Displays the Open dialog box 
Ctrl + P Displays the Print dialog box 
Ctrl + R Copies the leftmost cell in the selection to the right 
Ctrl + S Saves, Displays the Save As dialog box if a new workbook 
Ctrl + U Toggles underlining on the current selection 
Ctrl + V Pastes the entry from the clipboard 
Ctrl + W Closes the active workbook or window 
Ctrl + X Cuts the current selection to the clipboard
Ctrl + Y Repeats the last workbook action
Ctrl + Z Undo the last workbook action 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s