|
Excel Shortcuts Keys for
Windows Excel Shortcut Function |
|
Ctrl + A Select
all contents of a worksheet. |
|
Ctrl + B Bold
all cells in the highlighted section. |
|
Ctrl + C Copy |
|
Ctrl + D Fill
the Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down) |
|
Ctrl + E Flash
Fill |
|
Ctrl + F “Search
the current sheet. |
|
Ctrl + G Go
to a certain area. |
|
Ctrl + H Find
and replace. |
|
Ctrl + I Puts
italics on all cells in the highlighted section. |
|
Ctrl + K Inserts
a hyperlink. |
|
Ctrl + L Create
a table |
|
Ctrl + M |
|
Ctrl + N New
File |
|
Ctrl + O Open
file |
|
Ctrl + P
Print
the current sheet. |
|
Ctrl + R
Fill
Right. |
|
Ctrl + S
Saves
the open worksheet. |
|
Ctrl + U Underlines
all cells in the highlighted section. |
|
Ctrl + V Pastes
everything copied onto the clipboard. |
|
Ctrl + W Closes
the current workbook. |
|
Ctrl + X Cuts
all cells within the highlighted section. |
|
Ctrl + Y Repeats
the last entry. |
|
Ctrl + Z Undo
the last action. |
|
Ctrl+1 Changes
the format of the selected cells. |
|
Ctrl+2 Bolds
all cells in the highlighted section. |
|
Ctrl+3 Puts
italics all cells in the highlighted section. |
|
Ctrl+4 Underlines
all cells in the highlighted section. |
|
Ctrl+5 Puts
a strikethrough all cells in the highlighted section. |
|
Ctrl+6 Shows
or hides objects. |
|
Ctrl+7 Shows
or hides the toolbar. |
|
Ctrl+8 Toggles
the outline symbols. |
|
Ctrl+9 Hides
rows. |
|
Ctrl+0 Hides
columns. |
|
Ctrl+Shift+: Enters
the current time. |
|
Ctrl+; Enters
the current date. |
|
Ctrl+` Changes
between displaying cell values or formulas in the worksheet. |
|
Ctrl+‘ Copies
a formula from the cell above. |
|
Ctrl+Shift+“ Copies
value from the cell above. |
|
Ctrl+– Deletes
the selected column or row. |
|
Ctrl+Shift+= Inserts
a new column or row. |
|
Ctrl+Shift+~ Switches
between showing Excel formulas or their values in cells. |
|
Ctrl+Shift+@ Applies
time formatting. |
|
Ctrl+Shift+! Applies
comma formatting. |
|
Ctrl+Shift+$ Applies
currency formatting. |
|
Ctrl+Shift+# Applies
date formatting. |
|
Ctrl+Shift+% Applies
percentage formatting. |
|
Ctrl+Shift+^ Applies
exponential formatting. |
|
Ctrl+Shift+* Selects
the current region around the active cell. |
|
Ctrl+Shift+& Places
border around selected cells. |
|
Ctrl+Shift+_ Removes
a border. |
|
Ctrl++ Insert. |
|
Ctrl+– Delete. |
|
Ctrl+Shift+( Unhide
rows. |
|
Ctrl+Shift+) Unhide
columns. |
|
Ctrl+/ Selects
the array containing the active cell. |
|
Ctrl+\ Selects
the cells that have a static value or don’t match the formula in the active
cell. |
|
Ctrl+[ Selects
all cells referenced by formulas in the highlighted section. |
|
Ctrl+] Selects
cells that contain formulas that reference the active cell. |
|
Ctrl+Shift+{ Selects
all cells directly or indirectly referenced by formulas in the highlighted
section. |
|
Ctrl+Shift+} Selects
cells that contain formulas that directly or indirectly reference the active
cell. |
|
Ctrl+Shift+| Selects
the cells within a column that don’t match the formula or static value in the
active cell. |
|
Ctrl+Enter Fills
the selected cells with the current entry. |
|
Ctrl+Spacebar Selects
the entire column. |
|
Ctrl+Shift+Spacebar Selects the
entire worksheet. |
|
Ctrl+Home Move
to cell A1. |
|
Ctrl+End Move
to the last cell on a worksheet. |
|
Ctrl+Tab Move
between Two or more open Excel files. |
|
Ctrl+Shift+Tab Activates
the previous workbook. |
|
Ctrl+Shift+A Inserts
argument names into a formula. |
|
Ctrl+Shift+F Opens
the drop-down menu for fonts. |
|
Ctrl+Shift+F Selects
all of the cells that contain comments. |
|
Ctrl+Shift+P Opens
the drop-down menu for the point size. |
|
Shift+Insert Pastes
what is stored on the clipboard. |
|
Shift+pg
up In
a single column, highlights all cells above that which are selected. |
|
Shift+pg
dn In
a single column, highlights all cells above that which are selected. |
|
Shift+Home Highlights
all text to the left of the cursor. |
|
Shift+End Highlights
all text to the right of the cursor. |
|
Shift+↑ Extends
the highlighted area up to one cell. |
|
Shift+↓ Extends
the highlighted area down one cell. |
|
Shift+← Extends
the highlighted area left one character. |
|
Shift+→ Extends
the highlighted area right one character. |
|
Alt+Tab Cycles
through applications. |
|
Alt+Spacebar Opens
the system menu. |
|
Alt+Backpspace Undo. |
|
Alt+Enter While
typing text in a cell, pressing Alt+Enter will move to the next line,
allowing for multiple lines of text in one cell. |
|
Alt+= It
creates a formula to sum all of the above cells. |
|
Alt+‘ Allows
formatting on a dialog box. |
|
F1 Opens
the Help menu. |
|
F2 Edits
the selected cell. |
|
F3 After
a name has been created, F3 will paste names. |
|
F4 Repeats
the last action. For example, if you changed the color of the text in another
cell, pressing F4 will change the text in a cell to the same color. |
|
F5 Goes
to a specific cell. For example, C6. |
|
F6 Move
to the next pane. |
|
F7 Spell
check selected text or document. |
|
F8 Enters
Extend Mode. |
|
F9 Recalculates
every workbook. |
|
F10 Activates
the menu bar. |
|
F11 Creates
a chart from selected data. |
|
F12 Save
as. |
|
Shift+F1 Opens
the “What’s This?” window. |
|
Shift+F2 It
allows the user to edit a cell comment. |
|
Shift+F3 Opens
the Excel formula window. |
|
Shift+F5 Brings
up a search box. |
|
Shift+F6 Move
to the previous page. |
|
Shift+F8 Add
to selection. |
|
Shift+F9 Performs
calculate function on the active sheet. |
|
Ctrl+F3 Open
Excel Name Manager. |
|
Ctrl+F4 Closes
current Window. |
|
Ctrl+F5 Restores
window size. |
|
Ctrl+F6 Next
workbook. |
|
Ctrl+Shift+F6 Previous
workbook. |
|
Ctrl+F7 Moves
the window. |
|
Ctrl+F8 Resizes
the window. |
|
Ctrl+F9 Minimize
the current window. |
|
Ctrl+F10 Maximize
the currently selected window. |
|
Ctrl+F11 Inserts
a macro sheet. |
|
Ctrl+F12 Opens
a file. |
|
Ctrl+Shift+F3 Creates
names by using those of either row or column labels. |
|
Ctrl+Shift+F6 Moves
to the previous worksheet window. |
|
Ctrl+Shift+F12 Prints
the current worksheet. |
|
Alt+F1 Inserts
a chart. |
|
Alt+F2 Save
as. |
|
Alt+F4 Exits
Excel. |
|
Alt+F8 Opens
the macro dialog box. |
|
Alt+F11 Opens
the Visual Basic editor. |
|
Alt+Shift+F1 Creates
a new worksheet. |
|
Alt+Shift+F2 Saves
the current worksheet. |
Excel Workbook Shortcuts
·
Shift + F11 – Inserts a new worksheet
·
Ctrl + PgDn – Next Worksheet
·
Ctrl + PgUp – Previous Worksheet
·
Ctrl + Tab – Go to next Workbook
·
F6 – It lets you move to next Pane
·
Shift F6 – It makes you move to the previous pane
·
Ctrl + Shift + Tab – Previous Workbook
·
Ctrl + F9 – Minimize
·
Ctrl + F10 – Maximize
·
Shift + Click – Select Adjacent Worksheets
·
Ctrl + Click – Select non-adjacent Worksheets
·
Ctrl + Shift + F1 – Full Screen Toggle
·
Tab – Move to next control
·
Shift + Tab – Move to the previous control
·
Ctrl + Tab – Move to next Tab
·
Ctrl + Shift + tab – Move to Previous Tab
File Shortcuts
·
Ctrl + N – New Workbook
·
Ctrl + O – Open Workbook
·
Ctrl + S – Save Workbook
·
F12 – Save As
·
Ctrl + P – Print File
·
Ctrl + F2 – Open Print Preview
·
Ctrl + F4 – Close Workbook
·
Alt + F4 – Close Excel
·
Ctrl + F1 – Expand or close Ribbon
·
Alt – Activate Access Keys
·
Tab – Move to next control on Ribbon
·
F1 – Help
Generalized Shortcuts
·
Ctrl + W: Close a Workbook
·
F4 – Repeat Last Command Actions
·
Alt + F + T – Open Options
·
F1 – Open Help
·
Ctrl + Z – Undo
·
Ctrl + Y – Redo
·
Ctrl + C – Copy
·
Ctrl + X – Cut
·
Ctrl + V – Paste
·
Ctrl + Alt + V – Display Paste Special Dialogue Box
·
Ctrl + F – Find Box
·
Ctrl + H – Find and Replace
·
Shift + F4 – Find next match
·
Ctrl + Shift + F4 – Find Previous Match
·
Alt + F1 – Create an Embedded Chart
·
F11 – Create Chart in new Worksheet
Navigation Excel
Shortcuts
·
→ – Cell Right
·
← – Cell left
·
↑ – Cell Up
·
↓ – Cell down
·
Alt + PgDn – Move one screen down
·
Alt + PgUp – Move one screen left
·
PgUp – Screen Up
·
PgDn – Screen Down
·
Ctrl + → – Right Edge of Data
·
Ctrl + ← – Left Edge of Data
·
Ctrl + ↑ – Top Edge of Data
·
Ctrl + ↓ – Bottom Edge of Data
·
Home – Beginning of Row
0 Comments