Excel Shortcuts

Formatting Keys

Alt + ‘ Display the style dialog box
Ctrl + Shift + ~ General Num. Format
Ctrl + Shift + $ Currency format
Ctrl + Shift + % Percentage format
Ctrl + Shift + ! Comma format
Ctrl + Shift + & Outline border
Ctrl + Shift + _ Remove borders
Ctrl + B Bold
Ctrl + I Italic
Ctrl + U Underline
Ctrl + 9 Hide rows
Ctrl + Shift + 9 Unhide rows
Ctrl + 0 Hide columns
Ctrl + Shift + 0 Unhide columns
Ctrl + 1 Format Dialog Box
Ctrl + 5 Strike Through
Shift + Space Select the entire row
Ctrl + Space Select the entire column
Ctrl + A Select the entire worksheet
Ctrl + X/C/V Cut/copy/paste
Ctrl + D/R Fills cells down/right
CTRL+SHIFT+* Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
SHIFT+ arrow key Extend the selection by one cell
CTRL+SHIFT+ arrow key Extend the selection to the last nonblank cell in the same column or row as the active cell
SHIFT+HOME Extend the selection to the beginning of the row
CTRL+SHIFT+HOME Extend the selection to the beginning of the worksheet
CTRL+SHIFT+END Extend the selection to the last cell used on the worksheet (lower-right corner)

Windows and Workbook Keys

Ctrl + F4 Closes workbook window
Alt + F4 Closes Excel
Ctrl + F10 Maximizes the workbook
Ctrl + F9 Minimizes the workbook
Ctrl + F5 Restore window size
F6 Next pane
Shift + F6 Previous pane
Ctrl + F6 Next window
Ctrl + Tab Next window
Shift + F11 Inserts a new sheet
F11 Create a Quick Chart Sheet
Ctrl + S Saves the workbook
F12 Saves As
Ctrl + O Opens a workbook
Ctrl + N Creates a new workbook
Alt + F8 Macros Dialog Box
Alt + F11 Visual Basic Editor
ALT + TAB Switch between applications
CTRL + TAB Switch between open Excel files
CTRL + Page Up/Page Down Go to previous/next worksheet
CTRL + Home/End Go to the first/last cell of the worksheet
CTRL + arrow key Go to the next empty cell

Auditing and Calculation Keys

Ctrl + ‘ ( ~ ) Toggle formula display
Ctrl + [ Selects cells directly referred to by formulas (Precedent Cells)
Ctrl + Shift + { Selects directly and indirectly referred to cells
Ctrl + ] Selects only cells with formulas that refer directly to the active cell (Dependent Cells)
Ctrl + Shift + } Selects all cells within formulas that directly or indirectly refer to the active cells
F9 Calculate all worksheets
Shift + F9 Calculate worksheet
F2 Toggle cell edit mode
SHIFT+BACKSPACE If multiple cells are selected, select only the active cell
SHIFT+PAGE DOWN Extend the selection down one screen
SHIFT+PAGE UP Extend the selection up one screen
CTRL+SHIFT+SPACEBAR With an object selected, select all objects on a sheet
CTRL+6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects
CTRL+7 Show or hide the Standard toolbar

To Learn Advanced Excel Whatapp/Call 8422000829. Disount Code WEBSAB501

Home Excel Tutorials Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10

Keep Learning...

Tumcha Amcha IT Buddy