[hibiscus_horz]

Excel Time saving Shortcuts

Move to next cell in row – Tab
Move to previous cell in row – Shift + Tab
Up one screen – Page Up
Down one screen – Page Down
Move to next worksheet – Ctrl + Page Down
Move to previous worksheet – Ctrl + Page Up
Go to first cell in data region – Ctrl + Home
Go to last cell in data region – Ctrl + End
Bold toggle for selection – Ctrl + B
Italic toggle for selection – Ctrl + I
Underline toggle for selection – Ctrl + U
Strikethrough for selection – Ctrl + 5
Change the font – Ctrl + Shift + F
Change the font size – Ctrl + Shift + P
Apply outline borders – Ctrl + Shift + 7
Remove all borders – Ctrl + Shift + Underline
Wrap text in same cell – Alt + Enter
Format cells – Ctrl + 1
Select font – Ctrl + Shift + F
Select point size – Ctrl + Shift + P
Format as currency – Ctrl + Shift + 4
Format as general – Ctrl + Shift + # (hash sign)
Format as percentage – Ctrl + Shift + 5
Format as number – Ctrl + Shift + 1
Autosum a range of cells – Alt + Equals Sign
Insert the date – Ctrl + ; (semi-colon)
Insert the time – Ctrl + Shift + ; (semi-colon)
Insert columns/rows – Ctrl + Shift + + (plus sign)
Insert a new worksheet – Shift + F11
Read Monitor Cell One – Alt + Shift + 1
Read Monitor Cell Two – Alt + Shift + 2
Read Monitor Cell Three – Alt + Shift + 3
Read Monitor Cell Four – Alt + Shift + 4
List Visible Cells With Data – Ctrl + Shift + D
Lists Data In Current Column – Ctrl + Shift + C
List Data In Current Row – Ctrl + Shift + R
Select Hyperlink – Ctrl + Shift + H
Move To Worksheet Listbox – Ctrl + Shift + S
Move To Monitor Cell – Ctrl + Shift + M
Select Worksheet Objects – Ctrl + Shift + O
List Cells At Page Breaks – Ctrl + Shift + B
Options Listbox – Insert + V


TOP