100+ Excel Keyboard Shortcuts

How to master key board shortcuts tips

1. Take down a handful (may be 5 or 10) shortcuts that you think youll use the most and pin
them to your desk. Make a conscious effort every time to use them

2. As you become a more avid user of Excel keep adding more keyboard shortcuts to your kitty.
Also knowing how to type faster really helps to get your hands on the keyboard, so learn typing

3. Remembering keyboard shortcuts is all about using them over and over again till the time they
come intuitively to you

4. Quick Tip:
The shortcuts that begin with Ctrl require you to press the Ctrl key and the shortcut key
together
The shortcuts that begin with Alt do not require you to press Alt Key and shortcut keys
together* and that is the reason why Alt based shortcuts tend to be longer than Ctrl
based shortcuts

*This rule is not applicable for all Alt Based shortcuts, for example ALT = (pressed together, applies the =SUM formula)
 Navigation Shortcuts
Arrow Keys Move one cell up, down, left, or right in a worksheet

Move one screen down / one screen up in a

Page Down / Page Up
worksheet
Move one screen to the right / to the left in a
Alt + Page Down / Alt + Page Up
worksheet
Move one cell to the right / to the left in a
Tab / Shift + Tab
worksheet
Move to the edge of next data region (cells that
Ctrl + Arrow Keys
contains data)

Home Move to the beginning of a row in a worksheet

Ctrl + Home Move to the beginning of a worksheet

Move to the last cell with content on a worksheet.

Ctrl + End
(Cell A1)
Display the Find and Replace dialog box (with Find
Ctrl + f
selected)
Display the Find and Replace dialog box (with
Ctrl + h
Replace selected)

Ctrl + g (or F5) Display the 'Go To' dialog box

Display the AutoComplete list e.g. in cell with

Alt + Arrow Down
dropdowns or autofilter

Ctrl + Arrow Left / Ctrl + Arrow

Inside a cell: Move one word to the left / to the right.
Right

Inside a cell: Move to the beginning / to the end of a

Home/End
cell entry.

These shortcuts work in the Cell Edit mode (Press F2 on any cell)

For more tips and tricks on Excel log on to www.goodly.co.in 2

 Selection Shortcuts
Shift + Space Select the entire row

Ctrl + Space Select the entire column

Ctrl + Shift + * (asterisk) Select the current region around the active cell

Select the entire worksheet or the data-containing

Ctrl + A
area. Pressing CTRL + A second time to select the
(or Ctrl + Shift + Spacebar) entire worksheet

Ctrl + Shift + Page Up Select the current and previous sheet in a workbook

Ctrl + Shift + o Select all cells with comments

Shift + Arrow Keys Extend the selection by one cell

Extend the selection to the last cell with data in row

Ctrl + Shift + Arrow Key
or column
Shift + Page Down / Extend the selection down one screen /up one
Shift + Page Up screen

Shift + Home Extend the selection to the beginning of the row

Extend the selection to the beginning of the

Ctrl + Shift + Home
worksheet
Extend the selection to the last used cell on the
Ctrl + Shift + End
worksheet (lower-right corner)

For more tips and tricks on Excel log on to www.goodly.co.in 3

 Editing Shortcuts
Ctrl + z Undo last action (multiple times)

Ctrl + y Redo last action (multiple times)

Ctrl + c Copy contents of selected cells

Ctrl + x Cut contents of selected cells

Ctrl + v Paste content from clipboard into selected cell

If data exists in clipboard: Display the Paste Special

Ctrl + Alt + v
dialog box
If data exists in clipboard: Display the Insert dialog
Ctrl + Shift + [+]
box to insert blank cells

F2 Edit the active cell with cursor at end of the line

Alt + Enter Start a new line in the same cell

Shift + Enter Complete a cell entry and move up in the selection

Complete a cell entry and move to the right / to the

Tab / Shift + Tab
left in the selection

Esc Cancel a cell entry

Ctrl + Delete Delete text to the end of the line

Ctrl + ; (semicolon) Insert current date

These shortcuts work in the Cell Edit mode (Press F2 on any cell)

For more tips and tricks on Excel log on to www.goodly.co.in 4

 Editing Shortcuts Continued..
Ctrl + d Fill complete cell down (Copy above cell)

Fill complete cell to the right (Copy cell from the

Ctrl + r
left)
Fill cell values down and edit (Copy above cell
Ctrl + "
values)
Fill cell formulas down and edit (Copy above cell
Ctrl + ' (apostrophe)
formulas)
Delete Cell/Row/Column. It pops up a menu to
Ctrl + -
select further options
Ctrl + -
Delete row / delete column
(with row / column Selected)

Alt > i > r Insert Row

ALT > i > c Insert column

Shift + F2 Insert / Edit a cell comment

Create and insert chart with data in current range as

Alt + F1
embedded Chart Object
Create and insert chart with data in current range in
F11
a separate Chart sheet

Ctrl + k Insert a hyperlink

For more tips and tricks on Excel log on to www.goodly.co.in 5

 Hide & Unhide Shortcuts
Ctrl + 9 Hide the selected rows

Ctrl + Shift + 9 Unhide any hidden rows within the selection

Ctrl + 0 (zero) Hide the selected columns

Ctrl + Shift + 0 (zero) Unhide any hidden columns within the selection

Alternate between displaying cell values and

Ctrl + `
displaying cell formulas

Alt + Shift + Arrow Right Group rows or columns

Alt + Shift + Arrow Left Ungroup rows or columns

Alt > o > c > w Adjust Columns width to a specific value

Alt > h > o > h Adjust row height to a specific value

For more tips and tricks on Excel log on to www.goodly.co.in 6

 Formatting Shortcuts
Ctrl + Shift + $ Apply the Currency format with two decimal places

Ctrl + Shift + ~ Apply the General number format

Ctrl + Shift + % Apply the Percentage format with no decimal places

Apply the Date format with the day, month, and

Ctrl + Shift + #
year
Apply the Time format with the hour and minute,
Ctrl + Shift + @
and indicate A.M. or P.M.
Apply the Number format with two decimal places,
Ctrl + Shift + ! thousands separator, and minus sign (-) for negative
values
Repeat last formatting action: Apply previously
F4
applied Cell Formatting to a different Cell

Ctrl + Shift + $ Apply the Currency format with two decimal places.

For more tips and tricks on Excel log on to www.goodly.co.in 7

 Formula & Naming Shortcuts
Alt + = Insert the AutoSum formula

Shift + F3 Display the Insert Function dialog box

Ctrl + a Display Formula Window after typing formula name

Insert Arguments in formula after typing formula

Ctrl + Shift + a
name

Ctrl + Shift + Enter Enter a formula as an array formula

After typing cell reference (e.g. =E3) makes

F4
reference absolute (=$E$4)
Calculate all worksheets in all open workbooks. (in
F9
case of manual calculation)
Calculate the active worksheet. (in case of manual
Shift + F9
calculation)
Calculate all worksheets in all open workbooks,
Ctrl + Alt + F9 regardless of whether they have changed since the
last calculation
Recheck dependent formulas, and then calculates
Ctrl + Alt + Shift + F9 all cells in all open workbooks, including cells not
marked as needing to be calculated.

Ctrl + Shift + U Toggle expand or collapse formula bar.

Ctrl + F3 Define a Cell or Range Name

Ctrl + Shift + F3 Create names from row and column labels

F3 Paste a defined name into a formula

For more tips and tricks on Excel log on to www.goodly.co.in 8

 Miscellaneous Shortcuts
Ctrl + o Open File

Save the active file with its current file name,

Ctrl + s
location, and file format

F12 Display the Save As dialog box

Ctrl + p Print File (Opens print menu)

F1 Display the Excel Help task pane

F7 Display the Spelling dialog box

Alt + F8 Display the Macro dialog box

Alt + F11 Open the Visual Basic Editor to create Macros

Alt + Arrow Down Open the selected drop-down list box

For more tips and tricks on Excel log on to www.goodly.co.in 9

 Pivot Table Shortcuts
Alt > N > V > T / Alt > N > V Insert a Pivot Table / Insert Pivot Table in Excel 2013

Ctrl + Shift+* (asterisk) Select the entire PivotTable report

Space Select or clear a check box in the list

Alt + F5 Refresh the active Pivot Table

Ctrl + Alt + F5 Refresh all Pivot Tables in the Workbook

For more tips and tricks on Excel log on to www.goodly.co.in 10