Worksheet Navigation Tip: Use Ctrl + PageUp/PageDown to quickly switch between sheets without touching your mouse!

Worksheet Navigation Tip: Use Ctrl + PageUp/PageDown to quickly switch between sheets without touching your mouse!

Lessons

Ctrl + PageUp == Move to previous worksheet

Ctrl + PageDown == Move to next worksheet

Ctrl + Shift + PageUp == Select current & previous sheet

Ctrl + Shift + PageDown == Select current & next sheet

Alt + O + H + R == Rename worksheet

Alt + E + L == Delete worksheet

???? Ctrl + S == Save workbook

???? Ctrl + E == Flash Fill

Ctrl + D == Fill down

Ctrl + R == Fill right

Ctrl + ; == Insert current date

Alt + = == AutoSum

Ctrl + 1 == Format Cells dialog

Ctrl + T == Create table

Ctrl + Space == Select column

Shift + Space == Select row

Ctrl + Arrow Keys == Navigate data

Ctrl + Shift + L == Toggle filters

Alt + N + V == Insert Pivot Table

Alt + A + M == Remove duplicates

Ctrl + Z == Undo

Ctrl + Y == Redo

Ctrl + C == Copy

Ctrl + X == Cut

Ctrl + V == Paste

Ctrl + F == Find

F2 == Edit cell

F4 == Repeat last action

???? Shift + F11 == Insert new worksheet

???? Ctrl + Shift + ; == Insert current time

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Shopping Basket
Scroll to Top
Verified by MonsterInsights