Home
Flashcards
Preview
Excel Keyboard Shortcuts
Home
Get App
Take Quiz
Create
Strikethrough
Ctrl + 5
Close a Workbook
Ctrl + w
Bold Formatting
Ctrl + 2
Ctrl + B
Help
F1
Display or Hide Ribbon
Ctrl + F1
Embed chart of Data in Current Range
Alt + F1
Insert new Worksheet
Alt + Shift + F1
Open Save As Box
F12
Hide Row
Ctrl + 9
Hide Column
Ctrl + 0
Open Dialog Box
Ctrl + O
Selects all cells with Comments
Ctrl + Shift + O
Select entire worksheet or Data if exists.
Select current Region and its summary rows.
Selects entire worksheet.
Ctrl + A
Ctrl + A 2nd time
Ctrl + A 3rd time
In a function Displays arguments.
Inserts arguments
Ctrl + A
Ctrl + Shift + A
Group Cells
Shift + Alt + Right Arrow
UnGroup Cells
Shite + Alt + Left Arrow
Copy
2nd time Copy to Clipboard
Ctrl + C
Display Find with Find Tab Selected
Ctrl + F
Shift F5
Repeats Last Find
Shift + F4
Open Format Cells with Font Tab Selected
Ctrl + Shift + F
Insert Row or Column
Ctrl + Shift + =
Uses Fill Down (top cell's content and format into rest of range below selected)
Ctrl + D
Uses Fill Right (left cell's content and format into rest of range to the right selected)
Ctrl + R
Author
pfarnswo
ID
336804
Card Set
Excel Keyboard Shortcuts
Description
Keyboard shortcuts for MS Excel Menu items
Updated
2017-12-17T12:33:57Z
Home
Flashcards
Preview