Skip to content
Québec’s technology magazineYouTube ↗
Québec TestTechnology, from here
Understand. Compare. Choose.
Search
Computing and tutorials

Microsoft Excel: 30 shortcuts for faster data entry and analysis

Québec TestPublished · 1 min read
Illustrative image

— Microsoft Excel: 30 shortcuts for faster data entry and analysis

Excel rewards keyboard use because the right shortcuts can navigate large ranges, fill formulas and format data with fewer interruptions.

Shortcut Action
Ctrl + Arrow Move to the edge of a data region
Ctrl + Shift + Arrow Select to the edge of a region
Ctrl + Home / End Go to A1 / last used cell
Ctrl + Page Up/Down Switch worksheets
Ctrl + Space / Shift + Space Select column / row
F2 Edit the active cell
Alt + Enter Insert a line break in a cell
Ctrl + D / R Fill down / right
Ctrl + ; Insert today’s date
Alt + = AutoSum
F4 in a formula Cycle relative/absolute references
Ctrl + T Convert a range to a table
Ctrl + Shift + L Toggle filters
Ctrl + 1 Open Format Cells
Shift + F11 Add a worksheet

Practise with a small table: convert it using Ctrl + T, toggle filters, total a column with Alt + =, and format the result with Ctrl + 1.

Source: Microsoft Support, “Keyboard shortcuts in Excel.”