Most Excel shortcut lists give you two hundred combinations, including twenty for features you will never open. This is not that list. These are the Excel keyboard shortcuts that matter when you are actually keeping records — a stock sheet, a sales log, a payroll schedule, a set of accounts.
Every combination here was read from Microsoft’s official Excel reference, which covers Excel for Microsoft 365, Excel 2021, 2019 and 2016. This guide focuses on Excel for Windows. If you have been scrolling through hundreds of rows by hand, or retyping dates and amounts one cell at a time, the next ten minutes will give you back far more than ten minutes.
How to Read Excel Shortcuts Correctly
Before the tables, one thing that trips up almost every beginner — and that most published lists get wrong. Every Excel keyboard shortcuts guide you have read probably used two different symbols without explaining them. Microsoft uses them to mean two different things:
- A plus sign (+) means press the keys at the same time. So
Ctrl + Cmeans hold Ctrl, tap C. - A comma (,) means press the keys in order, one after another. So
Alt + H, Hmeans tap Alt and H together, release, then tap H again.
This matters because many websites print ribbon sequences like “Alt + H + H” with plus signs. Readers press all three keys at once, nothing happens, and they conclude the shortcut does not work. It does — it is simply a sequence. Once you know the convention, every list on the internet becomes readable.
The Excel Shortcut Keys List to Learn First
Microsoft’s own reference has a table it calls “frequently used shortcuts”. This is that list, ordered by how much time each one saves a person keeping records.
| # | Keys | What it does |
|---|---|---|
| 1 | Ctrl + Arrow key | Jump to the edge of the current block of data |
| 2 | Ctrl + End | Jump to the last used cell in the sheet |
| 3 | Ctrl + Spacebar | Select the entire column |
| 4 | Shift + Spacebar | Select the entire row |
| 5 | Ctrl + Shift + Arrow key | Select all the way to the last filled cell |
| 6 | Alt + = | Insert the Sum formula (AutoSum) |
| 7 | Ctrl + Semicolon (;) | Insert today’s date |
| 8 | Ctrl + 1 | Open the Format Cells dialog box |
| 9 | Ctrl + Shift + Dollar ($) | Apply currency format to the selected cells |
| 10 | Ctrl + Alt + V | Open Paste Special |
| 11 | Ctrl + Z | Undo your last action |
| 12 | Ctrl + S | Save the workbook |
If you only learn numbers one to five, you will already stop scrolling. Excel stores your records in a data region — a solid block of filled cells surrounded by empty ones — and Ctrl + Arrow moves you to the edge of that block in one keystroke instead of four hundred.
Excel Keyboard Shortcuts for Navigating Without Scrolling
| Keys | What it does |
|---|---|
Arrow keys | Move one cell up, down, left or right |
Ctrl + Arrow key | Jump to the edge of the current data region |
Ctrl + End | Jump to the last used cell on the worksheet |
Ctrl + Home | Jump to the beginning of the worksheet |
Home | Move to the beginning of the row |
End, then an Arrow key | Move to the next non-blank cell in that row or column |
Page down / Page up | Move one screen down or up |
Alt + Page down / Alt + Page up | Move one screen right or left |
Ctrl + Page down / Ctrl + Page up | Move to the next or previous sheet in the workbook |
Tab / Shift + Tab | Move one cell right or left |
Alt + Down arrow | Open the dropdown list on a cell with data validation |
Ctrl + Page down is worth singling out. If your workbook has a sheet per month, or separate sheets for sales and expenses, this is how you flip between them without touching the mouse. These navigation Excel shortcut keys are the ones that replace scrolling entirely, which is why they sit at the top of this guide.
Excel Keyboard Shortcuts for Selecting Cells and Columns
Selecting is where mouse work wastes the most time. “How to select a column in Excel” is one of the most common spreadsheet questions, and the answer is a single combination.
| Keys | What it does |
|---|---|
Ctrl + Spacebar | Select the entire column |
Shift + Spacebar | Select the entire row |
Ctrl + A or Ctrl + Shift + Spacebar | Select the entire worksheet |
Shift + Arrow key | Extend the selection by one cell |
Ctrl + Shift + Arrow key | Extend the selection to the last non-blank cell in that row or column |
Ctrl + Shift + Home | Extend the selection to the beginning of the worksheet |
Ctrl + Shift + Page down / Page up | Select the current and next or previous sheet |
F8 | Turn extend mode on or off, then use arrow keys |
Shift + F8 | Add a non-adjacent cell or range to your selection |
Ctrl + Shift + Asterisk (*) | Select the current region around the active cell |
There is one behaviour worth knowing about Ctrl + A: if your cursor is inside a block of data, the first press selects that data region, a second press adds its summary rows, and a third selects the whole worksheet. If you press it and get less than you expected, press it again.
Formatting Shortcuts, Including Cedi Amounts
This is where Excel keyboard shortcuts earn their keep in a bookkeeping context. Suppose you have just typed a column of amounts in Ghana cedis and they are sitting there as plain numbers. Select the column with Ctrl + Spacebar, then apply currency format with Ctrl + Shift + $. Two keystrokes, and the whole column reads as money.
| Keys | What it does |
|---|---|
Ctrl + 1 | Open the Format Cells dialog box |
Ctrl + B (or Ctrl + 2) | Bold, or remove bold |
Ctrl + I (or Ctrl + 3) | Italic, or remove italic |
Ctrl + U (or Ctrl + 4) | Underline, or remove underline |
Ctrl + 5 | Apply or remove strikethrough |
Ctrl + Shift + Plus (+) | Open the Insert dialog to insert blank cells |
Ctrl + Minus (-) | Open the Delete dialog to delete selected cells |
Ctrl + Shift + Ampersand (&) | Apply an outline border to the selected cells |
Ctrl + D | Fill Down — copy the top cell of the selection into the cells below |
Ctrl + K | Insert a hyperlink |
F2 | Edit the active cell |
F7 | Check spelling in the worksheet or selected range |
Ctrl + Q | Show the Quick Analysis options for selected data |
Ctrl + L or Ctrl + T | Create a table from the selected data |
Ctrl + D deserves a note of its own. Anyone who has ever typed a formula into one cell and then dragged the fill handle down four hundred rows will appreciate copying it down with two keystrokes instead.
Number Format Shortcuts
These seven are the fastest way to make a rough sheet look professional, and they are the shortcuts most lists leave out.
| Keys | Format applied |
|---|---|
Ctrl + Shift + Tilde (~) | General number format |
Ctrl + Shift + Dollar ($) | Currency, two decimal places |
Ctrl + Shift + Percent (%) | Percentage, no decimal places |
Ctrl + Shift + Number sign (#) | Date, with day, month and year |
Ctrl + Shift + At sign (@) | Time, with hour, minute and AM or PM |
Ctrl + Shift + Exclamation (!) | Number with two decimals, thousands separator and minus sign for negatives |
Ctrl + Shift + Caret (^) | Scientific number format |
Dates and Times for Daily Records
If you keep a daily sales log — and in Ghana that is one of the most common uses of a spreadsheet — these two save real effort.
| Keys | What it does |
|---|---|
Ctrl + Semicolon (;) | Insert today’s date |
Ctrl + Shift + Colon (:) | Insert the current time |
Ctrl + Shift + Number sign (#) | Format the cell as a date |
A useful detail: Ctrl + ; inserts the date as a fixed value, not a formula. That is exactly what you want in a record — a log entry should keep the date it was created, not change to today’s date every time you open the sheet.
The Paste Special Shortcut (and Why It Matters)
This is the most under-appreciated shortcut in Excel, and the answer to a problem almost everyone hits. You copy a column of figures, paste it somewhere else, and the numbers change or turn into errors — because you pasted the formulas instead of the values. It is the Excel keyboard shortcuts question that comes up most often in a bookkeeping context.
Ctrl + Alt + V opens Paste Special. Then press a single letter to choose what to paste — and unlike most Excel keyboard shortcuts, this one asks you a question before it acts.
| Press | What gets pasted |
|---|---|
A | All cell contents and formatting |
F | Only the formulas |
V | Only the values — no formulas |
T | Only the formatting |
C | Only comments and notes |
N | Only the data validation settings |
H | All contents and formatting |
X | All contents, without borders |
W | Only the column widths |
R | Only formulas and number formats |
U | Only values and number formats |
For record keeping, V is the one to remember. When you need to move figures into a report, or lock in a calculated total so it stops recalculating, paste values only. It is the difference between a record that stays put and one that quietly changes under you.
Formulas and Calculations
| Keys | What it does |
|---|---|
Alt + = | Insert the Sum formula (AutoSum) |
F2 | Edit the active cell; toggle point mode inside a formula |
Enter | Complete the entry and move down one cell |
Shift + Enter | Complete the entry and move up one cell |
Alt + Enter | Start a new line inside the same cell |
Ctrl + Enter | Fill the whole selected range with your entry |
Esc | Cancel an entry |
F4 (with a cell reference selected) | Cycle through absolute and relative references |
Shift + F3 | Open the Insert Function dialog |
Ctrl + A (right of a function name) | Open the Function Arguments dialog |
Ctrl + E | Flash Fill — recognise a pattern and fill the column |
F9 | Recalculate all open workbooks |
Ctrl + Shift + U | Expand or collapse the formula bar |
Alt + F1 | Create an embedded chart of the current range |
F11 | Create a chart on its own sheet |
Two of these are genuinely transformative. Alt + = inserts AutoSum for the column above in one keystroke, which is the single most repeated calculation in small business bookkeeping. And F4, with a cell reference selected inside a formula, cycles a reference like A1 through $A$1, A$1 and $A1 — the difference between a formula you can copy down a column and one that breaks at row two. These formula Excel shortcut keys are what separate a sheet you maintain by hand from one that maintains itself.
Excel Function Keys at a Glance
| Key | What it does |
|---|---|
F1 | Open the Excel Help task pane |
F2 | Edit the active cell |
F3 | Paste a defined name, if you have any |
F4 | Repeat the last action; cycle cell reference types in a formula |
F5 | Open the Go To dialog box |
F6 | Switch between the worksheet, ribbon, task pane and zoom controls |
F7 | Check spelling |
F8 | Turn extend mode on or off |
F9 | Calculate all worksheets in all open workbooks |
F10 | Turn key tips on or off |
F11 | Create a chart of the current range on its own sheet |
F12 | Open the Save As dialog box |
Ctrl + F1 | Show or hide the ribbon |
Shift + F2 | Add or edit a cell note |
Shift + F3 | Insert a function |
Shift + F10 | Open the context menu |
Shift + F11 | Insert a new worksheet |
Ribbon Shortcuts: Moving Between Tabs
If you prefer the ribbon, these open each tab directly. Remember these are single Alt combinations — press them together, not in sequence. They are the part of the Excel keyboard shortcuts system that new users find least intuitive, because the key tips appear only after you hold Alt.
| Keys | Opens |
|---|---|
Alt + F | The File menu |
Alt + H | The Home tab |
Alt + N | The Insert tab |
Alt + P | The Page Layout tab |
Alt + M | The Formulas tab |
Alt + A | The Data tab |
Alt + R | The Review tab |
Alt + W | The View tab |
Alt + Q | The Search field |
Alt or F10 | Show the key tips, then navigate with arrow keys |
Two Things to Know Before You Rely on These
The US Keyboard Layout Caveat
Microsoft states plainly that its documented shortcuts “refer to the US keyboard layout”, and that keys for other layouts might not correspond exactly. That matters in Ghana, where UK layouts are common. In practice the modifier keys — Ctrl, Alt, Shift — are unaffected, and the letter keys are in the same places on a UK layout. The differences you are most likely to meet are punctuation: the semicolon, colon and dollar sign used in several Excel keyboard shortcuts above can sit on different keys. If one does not work, that is the first thing to check.
What This List Deliberately Leaves Out
Microsoft’s reference also documents shortcuts for Power Pivot, Copilot in Excel, external data refresh and macro development. They are not here, on purpose. If you are keeping stock records or a payroll sheet, you will not use them, and including them would only bury the shortcuts you will. A list you can finish is worth more than a list you abandon.
A Note on Google Sheets
Many people in Ghana use Google Sheets instead of Excel, because it is free and works in a browser. The concepts transfer almost completely — arrow keys, Ctrl for word jumps, Ctrl + Shift for selections, Ctrl + S to save. But the keys are not identical, and some of the combinations above will do something different. This guide is written for Excel; treat Sheets as a close cousin, not a twin.
If you are still deciding how to keep your business records, our guide to free productivity apps for small business covers the wider toolkit, and if you also work across Windows and Mac, the general computer shortcuts hub covers the cross-platform equivalents. For a deeper look at the operating system itself, see our Windows keyboard shortcuts guide — and the copy shortcut explains the copy half of copy-and-paste in more detail.
Frequently Asked Questions
How do I select an entire column in Excel?
Click any cell in the column and press Ctrl + Spacebar. To select an entire row, use Shift + Spacebar. To select only the filled part of a column rather than all 1,048,576 rows, use Ctrl + Shift + Arrow key instead, which stops at the last non-blank cell.
What is the shortcut to insert today’s date in Excel?
Ctrl + Semicolon (;) inserts today’s date. Ctrl + Shift + Colon (:) inserts the current time. Both insert fixed values rather than formulas, which is what you want in a record — the date stays as the date you entered it.
How do I paste values only in Excel?
Copy the cells first, then press Ctrl + Alt + V to open Paste Special, and press V. This pastes the results without the formulas, so the figures stop recalculating. It is the fix for numbers that change or turn into errors after you paste them.
How do I jump to the bottom of my data without scrolling?
Press Ctrl + Down arrow. It moves to the edge of the current block of data in one keystroke. Ctrl + End takes you to the last used cell on the whole worksheet, and Ctrl + Home brings you back to the beginning.
Why is Alt + = not inserting a sum for me?
Alt + = inserts AutoSum, but it needs something to sum. Click in the cell directly below a column of numbers and press it, and Excel will suggest the range above. If the cells above are empty or contain text rather than numbers, there is nothing for it to add, so check that the column actually holds figures.
Do these Excel shortcuts work on a Mac?
Many do, with Command replacing Ctrl for the standard editing actions. But not all of them translate — several combinations differ, and some use the Option key where Windows uses Alt. Microsoft publishes a separate Mac tab in its Excel shortcut reference. This guide is written for Windows, and you should not assume every combination above will work unchanged on a Mac.
Conclusion: Learn Five, Then Add One a Week
Excel keyboard shortcuts are the highest-return skill in this entire guide series, because spreadsheets are where the repetitive work lives. The five that matter most are Ctrl + Arrow to stop scrolling, Ctrl + Spacebar to select a column, Alt + = to total it, Ctrl + Shift + $ to format it as cedi amounts, and Ctrl + ; to date the entry.
Learn those five this week, using only the keyboard for them even when the mouse would be faster. Then add one a week from the tables above. That is how Excel keyboard shortcuts stop being trivia you read once and become muscle memory you rely on. Within a couple of months you will be moving around a spreadsheet faster than most people you work with — and you will never scroll to row four hundred again.
Which Excel keyboard shortcut did you not know about before today? Tell us in the comments, and share this with anyone still typing figures into cells one at a time.
Leave a Reply
You must be logged in to post a comment.