Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
Shortcut Key    Action Description        
[Ctrl]+0Hides the Selected Columns
[Ctrl]+1Format Cells
[Ctrl]+2[Toggle Function] Apply or Remove Bold Font Formatting
[Ctrl]+3[Toggle Function] Apply or Remove Italic Font Formatting
[Ctrl]+4[Toggle Function] Apply or Remove Underline Font Formatting
[Ctrl]+5[Toggle Function] Apply or Remove Strikethrough Font Formatting
[Ctrl]+6-
[Ctrl]+7-
[Ctrl]+8-
[Ctrl]+9Hides the Selected Rows
[Ctrl]+ASelect all contents in the Range, Pressing [Ctrl]+A again selects entire worksheet
[Ctrl]+BApply Bold font effect
[Ctrl]+CCopy the selected contents to Clipboard
[Ctrl]+DFills the contents and format of the cell just above
[Ctrl]+E-
[Ctrl]+FDisplays the Find tab of the Find and Replace Feature
[Ctrl]+GDisplay GoTo Dialog Box
[Ctrl]+HDisplays the Replace tab of the Find and Replace Feature
[Ctrl]+IApply Italics font effect
[Ctrl]+J-
[Ctrl]+KInsert or Edit the Hyperlink
[Ctrl]+LDisplays Create table Feature (Includes the Range automatically)
[Ctrl]+M-
[Ctrl]+NCreates New Workbook
[Ctrl]+ODisplays the Open Dialog box
[Ctrl]+PDisplays the Print Dialog box
[Ctrl]+Q-
[Ctrl]+RFills the contents and format of the cell from the left
[Ctrl]+SSaves the workbook
[Ctrl]+T-
[Ctrl]+UApply Underline font effect
[Ctrl]+VPaste the contents from Clipboard
[Ctrl]+WClose the current window
[Ctrl]+XCut
[Ctrl]+YRedo Command
[Ctrl]+ZUndo Command