Excel quick guide
Spend less time moving between your keyboard and mouse. These 12 useful Excel shortcuts will help you navigate, select and edit information more efficiently.
Move around your workbook
Reach important parts of your spreadsheet without scrolling through hundreds of rows.
Return to the beginning
Jump straight back to cell A1 from anywhere in the worksheet.
Find the last used cell
Move to the furthest cell containing data or formatting.
Jump to the edge of your data
Quickly reach the top, bottom or side of a block of information.
Switch worksheets
Use Page Up or Page Down while holding Ctrl to move between worksheet tabs.
Select information faster
Select the information you want to copy, format or analyse without relying on the mouse.
Select your data
Press once inside a table to select its data. Press again to select the entire worksheet.
Extend a selection
Select one additional cell at a time in any direction.
Select to the edge
Select a complete row or column of connected data in one movement.
Edit and format efficiently
Complete everyday editing tasks without searching through Excel’s menus.
Copy and paste
Copy selected information with Ctrl+C and paste it with Ctrl+V.
Undo your last action
Reverse an accidental change. Press it repeatedly to undo several actions.
Edit the active cell
Place the cursor directly inside a cell without double-clicking.
Open Format Cells
Change number formats, alignment, borders and cell protection.
Insert today’s date
Add the current date to a cell without typing it manually.
Choose two shortcuts today
Use the same two shortcuts throughout your working day. Once they become automatic, return to this guide and choose two more.
Start with Ctrl+Home and F2Using a Mac? For many shortcuts, use the Command key (⌘) instead of Ctrl. Some navigation commands may differ depending on your keyboard.
