Keyboard Shortcuts

Excel

Alt + Page Up= Moves One Screen to the Left

Alt + Page Down= Moves One Screen to the Right

Alt + Enter= Print

Alt + Spacebar= View the Control Menu

Alt + F1= Create Chart using Data form Current Range

Alt + Shift + F1= Insert a New Worksheet

Alt + F8= View the Macro Menu

Alt + Shift + F10= View the Smart Tag Menu

Alt + F11= View the VBE (visual basic editor)

Shift + F3= View the Insert Function Menu

Shift + F8= Add Nonadjacent Cell\Range to Selection by Use of Arrow Keys

Alt + K= View Hyperlink Menu

Ctrl + End= Move to Last Cell\Move to the End of Text

Ctrl + Shift + End= Extends Selection to Last Used Cell\Select All Text

Ctrl + Home= Move to First Cell

Ctrl + Shift + Home= Extends Selected Cells to the Beginning of Worksheet

Ctrl + Page Down= Move to Next Sheet

Ctrl + Shift + Page Down= Selects the Current and Next Worksheet

Ctrl + Page Up= Move to Previous Worksheet

Ctrl + Shift + Page Up= Selects the Current and Previous Worksheet

Ctrl + Space Bar= Select Entire Column

Ctrl + Shift + Space Bar= Select Entire Worksheet\Select All Objects

Ctrl + Tab= Switches to Next Workbook

Ctrl + Shift + Tab= Switches to Previous Tab in a Menu

Ctrl + Arrow Key= Move to Edge of Current Data Region

Ctrl + Shift + Arrow Key= Extends Selection to Last Non-blank Cell

Ctrl + F1= Display\Hide Task Pane: Toggle

Ctrl + F4= Close Selected Workbook

Ctrl + F5= Restore Window Size of Selected Workbook

Ctrl + F6= Move to Next Workbook Window

Ctrl + F7= Performs Move on Workbook Window when Not Maximized

Ctrl + F8= Performs Size Command

Ctrl + F9= Minimizes a Workbook Window

Ctrl + Alt + F9= Calculates All Open Worksheets\Workbooks

Ctrl + Alt + Shift + F9= Checks Formulas & Calculates All Open Worksheets\Workbooks

Ctrl + F10= Maximizes a Workbook Window

Ctrl + -= View the Delete Menu

Ctrl + '= Copies formula from Cell Above Active Cell

Ctrl + ;= Insert Current Date

Ctrl + `= Display Cell Value\Formula: Toggle

Ctrl + Shift + := Insert Current Time

Ctrl + Shift + (= Display any Hidden Rows within Selected Cells

Ctrl + Shift + )= Display any Hidden Columns within Selected Cells

Ctrl + Shift + &= Apply Outline Border to Selected Cells

Ctrl + Shift + _= Remove Outline Border to Selected Cells

Ctrl + Shift + ~= Apply the General Number Format

Ctrl + Shift + $= Apply the Currency Format (2 decimal places)

Ctrl + Shift + %= Apply the Percentage Format (no decimal places)

Ctrl + Shift + ↑= Apply the Exponential Number Format (2 decimal places)

Ctrl + Shift + #= Apply the Date Format (day, month, year)

Ctrl + Shift + @= Apply the Time Format (hour, minute - AM, PM)

Ctrl + Shift + != Apply the Number Format (2 decimal places, thousands sep., minus sign)

Ctrl + Shift + *= Select Current Region around the Active Cell
(in a PivotTable, selects entire PivotTable report)

Ctrl + Shift + "= Copy the Value from the Cell above the Active Cell

Ctrl + Shift + (+):= Display the Insert Menu

Ctrl + A= Select Entire Worksheet\Region

Ctrl + Shift + A= Insert the Argument Names & Parentheses

Ctrl + B= Apply\Remove Bold Formatting: Toggle

Ctrl + C= Copy Selected Cell\s

Ctrl + C + C= View the Clipboard

Ctrl + D= Delete

Ctrl + F= View the Find\Replace Menu
(focus on the find tab)

Ctrl + Shift + F= View the Format Cells Menu

Ctrl + G= View the Go To Menu

Ctrl + H= View the Find\Replace Menu
(focus on the replace tab)

Ctrl + I= Apply\Remove Italic Formatting: Toggle

Ctrl + K= View Insert Hyperlink Menu\Edit Hyperlink

Ctrl + N= Create New Workbook

Ctrl + O= View the Open Menu

Ctrl + Shift + O= Select Cells Containing Comments

Ctrl + P= View the Print Menu

Ctrl + Shift + P= View the Format Cells Menu
(focus on the font tab)

Ctrl + R= Fill Right

Ctrl + S= Save

Ctrl + U= Apply\Remove Underlining: Toggle

Ctrl + V= Insert\Paste

Ctrl + Alt + V= View the Paste Special Menu

Ctrl + W= Close Workbook

Ctrl + X= Cut

Ctrl + Y= Repeat

Ctrl + Z= Undo

Ctrl + Shift + Z= Undo\Redo Last Automatic Correction

Ctrl + 0 (zero)= Hide Selected Column\s

Ctrl + 1= View Format Cells Menu

Ctrl + 2= Apply\Remove Bold Formatting: Toggle

Ctrl + 3= Apply\Remove Italic Formatting: Toggle

Ctrl + 4= Apply\Remove Underlining: Toggle

Ctrl + 5= Apply\Remove Strike-through: Toggle

Ctrl + 6= Display\Hide Objects and Object Placeholder: Toggle

Ctrl + 8= Display\Hide Outline Symbols: Toggle

Ctrl + 9= Hide Selected Row\s

Arrow Keys= Move One Cell in Any Direction

End= Move to the Cell in the Lower Right Corner
(scroll lock on)

Enter= Completes Cell\Formula Bar Entry

Shift + Enter= Completes Cell and Moves One Cell Up

Esc= Cancel an Entry\Closes Open Menu

Home= Move to the Beginning of a Row

Page Down= Move One Screen Down in a Worksheet

Page Up= Move One Screen Up in a Worksheet

Tab= Move One Cell to the Right

F1= View Help Menu

F2= Edit the Active Cell

F3= View the Paste Name Menu

Shift + F3= View the Insert Function Menu

F4= Repeat the Last Action

F5= View the Go To Menu

F6= Worksheet, Ribbon, Task Pane & Zoom Control: Toggle

Shift + F6= Worksheet, Ribbon, Task Pane & Zoom Control: Toggle

F7= Invoke Spell Check

F8= Extend Selection Mode: Toggle

F9= Calculate All Sheets in All Books

Shift + F9= Calculate Active Worksheet

F10= Key Tips: Toggle

Shift + F10= View Shortcut Menu for Selected Item

F11= Create Chart using Current Range

Shift + F11= Insert New Worksheet

F12= View the Save As Menu

Shift + Arrow Key= Extends Selection by One Cell

Shift + Space Bar= Select Entire Row

Shift + Tab= Moves to the Previous Cell

  Share  Share on Twitter Share on LinkedIn  Save  Save to Pocket