Excel becomes much faster when your hands stay on the keyboard. The shortcuts below focus on tasks people repeat constantly: moving around large worksheets, selecting data, entering values, formatting cells and checking formulas. Learn a few first, use them daily, then add more as they become automatic.
Navigation and selection shortcuts
1. Jump to the edge of a data range: Ctrl + Arrow key
Press Ctrl + Right Arrow, Ctrl + Left Arrow, Ctrl + Up Arrow or Ctrl + Down Arrow to move to the next edge of a contiguous block of data. In a sales table, for example, Ctrl + Down Arrow takes you from the first row to the last filled row in the current column. It is far quicker than scrolling through hundreds of records.
2. Select to the edge of a data range: Ctrl + Shift + Arrow key
Add Shift to the previous shortcut to select cells while moving. If cell A2 is the start of a list, Ctrl + Shift + Down Arrow selects down to the last non-blank cell. This is useful before copying, applying a format or creating a quick calculation.
3. Select the current data region: Ctrl + A
When the active cell is inside a connected table, the first press of Ctrl + A selects that current region. Press it again to select the whole worksheet. Use this carefully: selecting the table is ideal for formatting or filtering, while selecting the whole sheet can unintentionally change blank cells too.
4. Go directly to a cell or named range: Ctrl + G
Ctrl + G opens the Go To box. Type a reference such as H450 and press Enter to jump straight there. It is especially handy in imported files, audit workbooks and sheets with a long list of exceptions. You can also enter a named range if the workbook uses one.
5. Switch worksheets: Ctrl + Page Up and Ctrl + Page Down
Move between adjacent worksheet tabs without reaching for the mouse. Ctrl + Page Down goes to the next sheet and Ctrl + Page Up goes to the previous one. This is a small shortcut that makes a real difference when comparing monthly tabs or checking a summary against source data.
Fast data entry and editing
6. Edit the active cell: F2
Press F2 to edit the active cell in place. You can then use the arrow keys to move through the existing text or formula. This avoids double-clicking and helps prevent accidentally selecting another cell. On some laptops, you may need to hold Fn as well.
7. Enter the same value in many cells: Ctrl + Enter
Select several cells, type a value or formula, then press Ctrl + Enter. Excel puts the entry into every selected cell at once. For example, select blank status cells in a filtered list, type Pending, and use this shortcut to fill them together. Check that your selection contains only the intended cells before committing.
8. Fill down: Ctrl + D
Select a range where the top cell contains the value or formula you want to copy, then press Ctrl + D. Excel fills the content down through the selection, adjusting relative formula references as it goes. If B2 contains =A2*1.2, selecting B2:B100 and pressing Ctrl + D creates the corresponding formula for each row.
9. Fill right: Ctrl + R
Ctrl + R works like Fill Down, but copies from the leftmost selected cell across the selected range. It is useful when a row has repeated calculations across months, departments or scenarios.
10. Insert today’s date: Ctrl + ;
Press Ctrl + ; to enter the current date as a fixed value. Unlike =TODAY(), it will not update tomorrow. Use it for dated notes, completion logs, invoice preparation or recording when a task was performed.
11. Insert the current time: Ctrl + Shift + ;
Use Ctrl + Shift + ; to insert the current time as a fixed value. To create a fixed date and time in one cell, enter the date shortcut, type a space, then use the time shortcut. Make sure the cell has a date-and-time number format if Excel does not display both parts.
12. Repeat the last action: F4
F4 repeats many recent actions, including applying a fill colour, inserting a row or deleting a column. For repetitive formatting, it can be a major time-saver: format one heading, select the next heading and press F4. In formula editing, however, F4 has a different role: it cycles a cell reference through relative and absolute forms such as A1, $A$1, A$1 and $A1.
Formatting and formula shortcuts
13. Open Format Cells: Ctrl + 1
Ctrl + 1 opens the Format Cells dialogue for the selected cells. It provides control over number formats, alignment, borders, fills and protection. It is one of the most dependable ways to set formats precisely, particularly for percentages, dates, accounting values and custom number formats.
14. Format as a table: Ctrl + T
Select any cell in a clean data range and press Ctrl + T to turn it into an Excel Table. Confirm whether the first row contains headers. Tables add filter buttons, structured references and automatic expansion when you add new rows. They make lists easier to work with and reduce the chance that a formula or pivot source misses new data.
15. Add a quick total: Alt + =
Select an empty cell immediately below a column of numbers and press Alt + =. Excel usually inserts a SUM formula for the adjacent range. If you select several empty cells below several columns, it can insert several totals at once. Always glance at the highlighted range before pressing Enter, especially where blank rows split the data.
16. Show formulas instead of results: Ctrl + `
Press Ctrl + ` to toggle between calculated results and the formulas in your worksheet. The backtick key is usually near the top-left of the keyboard, often below Esc. Formula view is valuable when reviewing a model: you can spot an unexpected hard-coded number, a missing formula or an inconsistent reference without clicking cell by cell.
17. Use Flash Fill: Ctrl + E
Flash Fill recognises a pattern from an example and completes the rest of the column. Suppose column A contains Priya Shah. In column B, type Priya for the first row; after providing an example or two where needed, press Ctrl + E to extract first names. It can also combine text, standardise codes and rearrange dates. Review the output, because pattern recognition is helpful but not infallible.
Find, filter and review data faster
18. Turn filters on or off: Ctrl + Shift + L
Select a cell in your data range and press Ctrl + Shift + L to add or remove filter arrows. Once filters are active, you can quickly narrow a list to a department, a date range or rows with a particular status. For reliable filtering, keep one header row and avoid completely blank rows inside the dataset.
19. Find a value or phrase: Ctrl + F
Ctrl + F opens Find. Enter a customer name, product code or formula fragment, then use Find Next to move through matches. Select Options when you need to restrict the search to formulas, values or comments, match the case, or search the whole workbook rather than just the active sheet.
20. Find and replace: Ctrl + H
Ctrl + H opens Find and Replace. It is excellent for controlled clean-up, such as replacing an old department code with a new one or removing a repeated prefix from imported text. Start with Find Next or Replace to inspect each change. Avoid using Replace All until you are certain the search text cannot occur in formulas, notes or values you need to preserve.
Build the habit without slowing down
You do not need to memorise all 20 shortcuts this week. Start with Ctrl + Arrow, Ctrl + Shift + Arrow, F2, Ctrl + D and Ctrl + 1; they cover a large share of routine spreadsheet work. Add one shortcut whenever you notice yourself repeating a mouse action.
On a Mac, many Excel shortcuts use Command in place of Ctrl, but function keys and some combinations can vary by Excel version and keyboard settings. Test them in a copy of a workbook before using them on important data. Small improvements in navigation, selection and formula entry compound quickly—and leave more time for checking what the numbers actually mean.
When a spreadsheet begins as a table trapped in a document, convert it into workable cells first with ZeeSharp’s PDF to Excel tool, then use these shortcuts to clean, review and analyse the result.
