Introduction
The difference between an Excel expert and a beginner shows up first in **hand speed**, not in function knowledge. Even doing the same task, the person fumbling through menus with a mouse and the person whose hands never leave the keyboard differ in throughput by several times.
Shortcuts are more than just "fast" — the key point is that they **never break your flow**. The moment you move your hand to grab the mouse, the context of your thinking is cut off. When every operation finishes on the keyboard, you can stay focused on the data.
This article includes category-by-category shortcut tables (Windows and Mac together), practical combo workflows, and the habits and practice routines that reduce mistakes. Don't try to memorize everything — start with the ones you use most and let your hands learn them.
> Notation rules: Windows uses Ctrl/Alt/Win, and Mac uses Cmd/Option(Opt)/Control(Ctrl). On Mac, Ctrl and Cmd are sometimes used differently, so refer to the tables.
1. Navigation and Selection
Moving quickly between data is the starting point for every task.
| Action | Windows | Mac |
| --- | --- | --- |
| Jump to edge of data | Ctrl + arrow key | Cmd + arrow key |
| Select to the edge | Ctrl + Shift + arrow key | Cmd + Shift + arrow key |
| Select the entire current region | Ctrl + A | Cmd + A |
| Go to start of sheet (A1) | Ctrl + Home | Cmd + Fn + Left |
| Go to last cell of data | Ctrl + End | Cmd + Fn + Right |
| Move by screen | Page Up / Down | Fn + Up / Down |
| Select row from a cell | Shift + Space | Shift + Space |
| Select column from a cell | Ctrl + Space | Ctrl + Space |
The core is `Ctrl + arrow key`. It jumps to the edge of the data in one move until it hits an empty cell. Add Shift and it selects that range too. If you want to grab the entire table, `Ctrl + Shift + End` selects from the starting cell all the way to the end of the data in one go.
2. Entry and Editing
| Action | Windows | Mac |
| --- | --- | --- |
| Cell edit mode | F2 | Control + U |
| Stay in the same cell after entry | Ctrl + Enter | Control + Enter |
| Copy value from cell above | Ctrl + D | Cmd + D |
| Copy value from cell to the left | Ctrl + R | Cmd + R |
| Insert current date | Ctrl + ; | Control + ; |
| Insert current time | Ctrl + Shift + ; | Cmd + ; |
| Line break (within a cell) | Alt + Enter | Option + Enter |
| Cancel entry | Esc | Esc |
`Ctrl + Enter` is not well known but powerful. Select multiple cells, type a value, and press `Ctrl + Enter`, and the same value goes into all selected cells at once. It is faster than drag-copying when entering the same content repeatedly.
3. Formatting
| Action | Windows | Mac |
| --- | --- | --- |
| Format Cells dialog | Ctrl + 1 | Cmd + 1 |
| Bold | Ctrl + B | Cmd + B |
| Italic | Ctrl + I | Cmd + I |
| Underline | Ctrl + U | Cmd + U |
| Currency format | Ctrl + Shift + 4 | Control + Shift + 4 |
| Percentage format | Ctrl + Shift + 5 | Control + Shift + 5 |
| Thousands comma format | Ctrl + Shift + 1 | Control + Shift + 1 |
| Apply border | Ctrl + Shift + 7 | Cmd + Option + 0 |
`Ctrl + 1` is the gateway to all formatting. It handles number format, alignment, font, and borders in a single dialog. There is no need to fumble through the ribbon — this is the shortcut you should get into your hands first.
4. Rows and Columns
| Action | Windows | Mac |
| --- | --- | --- |
| Insert rows/columns dialog | Ctrl + Shift + + | Cmd + Shift + + |
| Delete rows/columns dialog | Ctrl + - | Cmd + - |
| Hide rows | Ctrl + 9 | Cmd + 9 |
| Hide columns | Ctrl + 0 | Cmd + 0 |
| Auto-fit row height/column width | Alt H O I/A | (use menu) |
Select an entire row or column (`Shift + Space` or `Ctrl + Space`), then press the insert/delete shortcut, and it is handled immediately without a dialog. Once the "select then operate" flow becomes second nature, changing table structure becomes very fast.
5. Working with Formulas
| Action | Windows | Mac |
| --- | --- | --- |
| AutoSum | Alt + = | Cmd + Shift + T |
| Toggle absolute/relative reference | F4 | Cmd + T |
| Toggle formula view | Ctrl + ` | Control + ` |
| Function arguments dialog | Ctrl + A (after entering function) | Control + A |
| Define name | Ctrl + F3 | (use menu) |
In formulas, `F4` is very important in two ways. Pressed while entering a cell reference, it cycles through relative and absolute references. The stages of reference locking look like the following, shown inside a fenced block:
A1 -> $A$1 -> A$1 -> $A1 -> A1 (back to start)
It changes in the order of locking both row and column, locking only the row, then locking only the column. This is essential when you need to keep a specific cell fixed even as you copy the formula.
One more thing — **`F4` also works as "repeat the last action"** (when you are not editing). When applying the same format in several places or repeating a row insertion, do it once and then tap `F4` repeatedly.
6. AutoFill
| Action | Windows | Mac |
| --- | --- | --- |
| Flash Fill | Ctrl + E | Cmd + E |
| Double-click the fill handle | (mouse) | (mouse) |
| Series fill | Ctrl + D / R | Cmd + D / R |
**Flash Fill (`Ctrl + E`)** infers a pattern and fills automatically. For example, if the adjacent column has full names and you type just the last name directly in one row and press `Ctrl + E`, it extracts the last names for the remaining rows on its own. It is powerful for rule-based transformations like splitting the ID from an email or standardizing phone number formats. Note that if the pattern is ambiguous it may fill incorrectly, so always review the result.
7. Tables and Filters
| Action | Windows | Mac |
| --- | --- | --- |
| Convert to table | Ctrl + T | Cmd + T |
| Toggle AutoFilter | Ctrl + Shift + L | Cmd + Shift + L |
| Open filter dropdown | Alt + down arrow | Option + down arrow |
An **Excel table** created with `Ctrl + T` has many advantages, such as structured references, automatic formatting, and automatic formula expansion when rows are added. Press `Ctrl + Shift + L` in a cell within the table and filter buttons appear in the header, and with `Alt + down arrow` you can select filter conditions with the keyboard alone.
8. Sheet Management
| Action | Windows | Mac |
| --- | --- | --- |
| Next/previous sheet | Ctrl + PgDn / PgUp | Option + Right / Left |
| Insert new sheet | Shift + F11 | Shift + F11 |
| Switch workbook | Ctrl + Tab | Cmd + ` |
In a workbook with many sheets, you can move quickly between tabs with `Ctrl + PgDn`/`PgUp`. Don't waste time clicking tiny tabs with the mouse.
9. Paste Options
Beyond a simple paste (`Ctrl + V`), knowing Paste Special reduces mistakes.
| Action | Windows | Mac |
| --- | --- | --- |
| Paste Special dialog | Ctrl + Alt + V | Cmd + Control + V |
| Paste values only | Ctrl + Alt + V → V | (select in dialog) |
| Paste formatting only | Ctrl + Alt + V → T | (select in dialog) |
| Paste transposed (swap rows/columns) | Ctrl + Alt + V → E | (select in dialog) |
"Paste values only," which **locks formula results as values**, is the most frequently used option. It is essential when sharing a file with others or making a dynamic array formula static.
10. Quick Analysis and More
| Action | Windows | Mac |
| --- | --- | --- |
| Quick Analysis menu | Ctrl + Q | (use menu) |
| Auto-create chart | Alt + F1 | Fn + Option + F1 |
| Insert hyperlink | Ctrl + K | Cmd + K |
| Find | Ctrl + F | Cmd + F |
| Replace | Ctrl + H | Control + H |
Press `Ctrl + Q` on a selected range and a recommended analysis menu for formatting, charts, totals, and more pops up, letting you apply visualization and aggregation in one go.
11. Alt Key Tip — The Entire Ribbon by Keyboard
On Windows, pressing `Alt` once displays **key hints** (letters/numbers) on each ribbon item. Press the shown characters in order to access every ribbon command without the mouse.
For example, "Home tab → Center alignment" is pressed in the order `Alt`, then `H`, then `A`, then `C`. If you memorize this sequence for frequently used commands, your hands will remember even features that have no shortcut. Once you bring up the key hints, you can follow along while watching the screen, which makes learning easy.
12. Combo Workflow — Quickly Cleaning Up Data
Shortcuts show their true value when used **chained together**, rather than one at a time. Let's look step by step at the flow of cleaning up messy data pasted in from an external source.
1. Select the entire data range: `Ctrl + A`
2. Convert to a table to structure it: `Ctrl + T`
3. Turn on header filters: `Ctrl + Shift + L`
4. Find and remove blank rows: search for empty values with `Ctrl + F`, then delete the rows
5. Type a split rule into one row of a helper column, then Flash Fill: `Ctrl + E`
6. Lock the result as values: copy, then `Ctrl + Alt + V → V`
7. Apply currency/percentage formats: `Ctrl + Shift + 4`, etc.
8. Add a summary row with AutoSum: `Alt + =`
Once you get these eight steps into your hands, you can turn raw data into a presentation-ready table with almost no use of the mouse.
13. Habits That Reduce Mistakes
- **A beat before pasting**: A simple paste overwrites formatting and formulas too. If you only need values, consciously choose "Paste values only" every time.
- **Check F4 absolute references**: Before copying a formula, confirm that the references you need to lock have a dollar sign attached.
- **The limits of Ctrl + Z**: Some operations (refreshing a pivot, running a macro) cannot be undone. Make a copy of the file before risky operations.
- **Verify the selected range**: Check that the range grabbed with `Ctrl + Shift + arrow key` matches your intent via the range shown in the Name Box.
- **Be aware of AutoSave**: For cloud files, if AutoSave is on, mistakes are saved immediately too. Make a copy before large changes.
14. Practice Routine — A 2-Week Adoption Plan
| Week | Goal | Focus shortcuts |
| --- | --- | --- |
| Early week 1 | Automate navigation and selection | Ctrl + arrow key, Ctrl + Shift + arrow key |
| Late week 1 | Entry and formatting | Ctrl + 1, Ctrl + Enter, Ctrl + D/R |
| Early week 2 | Formulas and fill | F4, Alt + =, Ctrl + E |
| Late week 2 | Tables and pasting | Ctrl + T, Ctrl + Shift + L, paste values only |
Pick one shortcut a day and practice deliberately with the mindset of "today I'll use only this instead of the mouse." It feels slow until it sticks, but after just two weeks, going back to the mouse will feel frustrating instead.
Closing
The goal of shortcuts is not memorization but **maintaining flow**. Pick just five tasks you do often and get their shortcuts into your hands first. `Ctrl + arrow key`, `Ctrl + 1`, `F4`, `Ctrl + E`, and paste values only. These five alone will make a huge difference in your perceived working speed.
The moment you leave the mouse, the time you spend focused on the data increases. In the next article, we'll cover Power Query, which automates the repetitive work itself.
References
- [Keyboard shortcuts in Excel (Microsoft Support)](https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f)
- [Using Flash Fill in Excel (Microsoft Support)](https://support.microsoft.com/en-us/office/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7)
- [Overview of Excel tables (Microsoft Support)](https://support.microsoft.com/en-us/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c)
- [Filter data in a range or table (Microsoft Support)](https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e)
- [Move or copy cells and cell contents (Microsoft Support)](https://support.microsoft.com/en-us/office/move-or-copy-cells-and-cell-contents-803d65eb-6a3e-4534-8c6f-ff12d1c4139e)
- [Switch between relative, absolute, and mixed references (Microsoft Support)](https://support.microsoft.com/en-us/office/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9)
- [Keyboard shortcuts in Excel for Mac (Microsoft Support)](https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-for-mac-acf5419e-1f87-444d-962f-4e951a658ccd)
- [Use the keyboard to work with the ribbon in Excel (Microsoft Support)](https://support.microsoft.com/en-us/office/use-the-keyboard-to-work-with-the-ribbon-in-excel-1c20c654-cb89-4c4c-bdc1-fd7af3f1b2d1)
현재 단락 (1/124)
The difference between an Excel expert and a beginner shows up first in **hand speed**, not in funct...