tk Computer Service

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

page seperator

^