[go: up one dir, main page]
Scribd
Upload
765 views1 page

Keyboard Shortcuts

This document provides a reference for keyboard shortcuts in Excel to perform common tasks like formatting cells, inserting and deleting rows/columns, navigating within the spreadsheet, using formulas and functions, macros and VBA, and other productivity features. It includes over 70 shortcuts organized into categories like formatting, navigation, formulas, macros/VBA, and more to help users work more efficiently in Excel through keyboard commands rather than using the mouse.

Uploaded by

Abhishek Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
765 views1 page

Keyboard Shortcuts

This document provides a reference for keyboard shortcuts in Excel to perform common tasks like formatting cells, inserting and deleting rows/columns, navigating within the spreadsheet, using formulas and functions, macros and VBA, and other productivity features. It includes over 70 shortcuts organized into categories like formatting, navigation, formulas, macros/VBA, and more to help users work more efficiently in Excel through keyboard commands rather than using the mouse.

Uploaded by

Abhishek Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Advanced Excel for Productivity

Keyboard Shortcuts Reference

The Basics Select, Insert, Delete Cells


CTRL + B Bold SHIFT + SPACE Select row
CTRL + U Underline CTRL + SPACE Select column
CTRL + I Italics CTRL + A Select all
CTRL + Z Undo CTRL + SHIFT + * Select contiguous region
CTRL + Y Redo CTRL + _ Delete selection
CTRL + C Copy ALT I R Insert row(s)
CTRL + X Cut ALT I C Insert column(s)
CTRL + V Paste ALT I E Insert cell(s)
CTRL + N New workbook CTRL + SHIFT + = Insert cell(s)
CTRL + S Save ALT + ; Select only visible cells
F12 Save as
CTRL + O Open Group and Hide Rows and Columns
CTRL + P Print ATL D G G Group rows/columns
ALT + SHIFT + Right Group rows/columns*
Formulas ALT D G U Ungroup rows/columns
F2 Edit formula ALT + SHIFT + Left Ungroup rows/columns*
ESC Exit formula editing ALT D G H Hide grouped rows/columns
ALT + = Auto-sum selection ALT D G S Show grouped rows/columns
CTRL + D Fill down CTRL + 9 Hide row
CTRL + R Fill right CTRL + SHIFT + 9 Unhide row
ALT T U D Trace depedents CTRL + 0 Hide column
ALT T U T Trace precedents CTRL + SHIFT + 0 Unhide column**
ALT T U A Clear trace arrows
CTRL + [ Go to precedents Within a Dialog Box
CTRL + ] Go to dependents ENTER "OK"
CTRL + SHIFT + Enter Enter array formula ESC "Cancel"
CTRL + Pg Up Previous Tab
Paste Special CTRL + Pg Down Next Tab
CTRL + ALT + V Paste special dialog* TAB Cycle through items
ALT E S Paste special dialog SPACE Adjust selected item
ALT E S V Enter Paste values
ALT E S T Enter Paste formatting Within a Cell
ALT E S F Enter Paste formulas F4 Anchor reference
F3 Insert a named reference
Keyboard Navigation ALT + Enter New line within cell
CTRL + Arrows Go to end of contiguous range SHIFT + Arrows Select within cell
SHIFT + Arrows Select cells CTRL + Arrows Jump to next word within cell
CTRL + Tab Switch through workbooks Home Go to beginning of cell
ALT + Tab Switch through programs End Go to end of cell
CTRL + Pg Down Next worksheet
CTRL + Pg Up Previous worksheet Macros and VBA
CTRL + F Find ALT + F11 Switch between Excel and VBA
CTRL + Home Go to first cell (A1) ALT + F8 Open macros dialog box
CTRL + End Go to last cell In VBA editor:
F5 Run Macro
Formatting F9 Add/remove break point
CTRL + 1 Open format cells dialog F8 Step through macro
CTRL + SHIFT + 1 Number format (2 decimals) CTRL + J List properties/methods
CTRL + SHIFT + 4 Currency format (2 decimals)
CTRL + SHIFT + 5 Percentage format Other Excel Shortcuts
ALT H 0 Increase decimal* CTRL + Mouse Scroll Zoom in/out
ALT H 9 Decrease decimal* SHIFT + F2 Insert comment
CTRL + SHIFT + 7 Add outline border F7 Spell check
CTRL + SHIFT + _ Clear borders from selection CTRL + K Hyperlink
ALT O C A Auto-fit column width CTRL + T Create table from selection
ALT H A L Align left* CTRL + ~ Toggle show formulas
ALT H A C Align center* ALT M M D Define cell/range name*
ALT H A R Align right* ALT + Down Open dropdown list

* Shortcut only available in Excel 2007 and newer


** Doesn't work by default in Excel 2007 and newer www.AdvancedExcelBook.com

You might also like