Master the Best Excel Shortcut Keys

Mastering Excel: The Most Useful Shortcut Keys for Windows and macOS

Excel is a powerhouse for data management, analysis, and visualization, but its full potential is best unlocked through keyboard shortcuts. These time-saving commands allow you to navigate, format, and manipulate data with speed and precision, eliminating the need to fumble with menus or a mouse. Whether you’re managing multiple workbooks, formatting cells, adjusting rows and columns, working with pivot tables, or performing everyday tasks like inserting dates and formulas, this guide has you covered.

In this expanded blog post, we’ve compiled an extensive collection of the most useful Excel shortcuts for both Windows and macOS users. Each section includes an introduction to provide context, a detailed table of shortcuts, and practical tips to help you apply them effectively. The categories include Workbook Shortcut Keys, Cell Formatting Shortcut Keys, Row and Column Formatting Shortcut Keys, Pivot Table Shortcut Keys, and Other Useful Shortcuts. Let’s dive in and supercharge your Excel productivity!


Workbook Shortcut Keys

Efficient workbook management is the foundation of a smooth Excel experience. Whether you’re creating new files, saving your work, or switching between worksheets and workbooks, these shortcuts will keep you organized and in control.

Tip: Memorize shortcuts like Ctrl + Tab (Windows) or `Command + “ (macOS) to seamlessly switch between open workbooks, especially when juggling multiple projects.

DescriptionWindows ShortcutmacOS Shortcut
Create new workbookCtrl + NCommand + N
Open existing workbookCtrl + OCommand + O
Save workbookCtrl + SCommand + S
Save as (new file name)F12Command + Shift + S
Close current workbookCtrl + W or Ctrl + F4Command + W
PrintCtrl + PCommand + P
Switch between workbooksCtrl + TabCommand + `
Undo last actionCtrl + ZCommand + Z
Redo last undone actionCtrl + YCommand + Shift + Z
Insert new worksheetShift + F11Shift + F11
Switch to next worksheetCtrl + Page DownControl + Page Down
Switch to previous worksheetCtrl + Page UpControl + Page Up
Rename current worksheetAlt + H, O, R(Use menu: Format > Rename Sheet)
Protect workbookAlt + T, P, P(Use menu: Tools > Protection)

Additional Tips:

  • On macOS, if your keyboard lacks Page Up/Page Down keys (common on laptops), use Control + Fn + Down Arrow (next worksheet) or Control + Fn + Up Arrow (previous worksheet).
  • Use Shift + F11 to quickly add a new worksheet without navigating the ribbon or sidebar—perfect for expanding your project on the fly.

Cell Formatting Shortcut Keys

Formatting cells efficiently is key to making your data visually appealing and easy to interpret. These shortcuts cover basic text styling, number formats, and access to advanced formatting options, saving you from digging through menus.

Tip: The “Open format cells dialog” shortcut (Ctrl + 1 or Command + 1) is your gateway to advanced formatting like custom borders, fill colors, and cell protection—learn it well!

DescriptionWindows ShortcutmacOS Shortcut
Bold textCtrl + BCommand + B
Italicize textCtrl + ICommand + I
Underline textCtrl + UCommand + U
Increase font sizeCtrl + Shift + >Command + Shift + >
Decrease font sizeCtrl + Shift + <Command + Shift + <
Apply number formatCtrl + Shift + !Command + Shift + !
Apply date formatCtrl + Shift + #Command + Shift + #
Apply currency formatCtrl + Shift + $Command + Shift + $
Apply percentage formatCtrl + Shift + %Command + Shift + %
Apply scientific formatCtrl + Shift + ^Command + Shift + ^
Open format cells dialogCtrl + 1Command + 1
Apply strikethroughCtrl + 5Command + Shift + X
Apply general formatCtrl + Shift + ~Command + Shift + ~
Copy formatting (Format Painter)Ctrl + Alt + CCommand + Option + C
Paste formattingCtrl + Alt + VCommand + Option + V

Additional Tips:

  • Use Ctrl + Shift + $ (or Command + Shift + $) to instantly format numbers as currency—ideal for financial reports.
  • The Format Painter shortcuts (Ctrl + Alt + C/V on Windows, Command + Option + C/V on macOS) let you replicate formatting across cells with minimal effort.

Row and Column Formatting Shortcut Keys

Adjusting rows and columns—whether inserting, deleting, hiding, or resizing—is a frequent task in Excel. These shortcuts streamline the process, letting you restructure your worksheet in seconds.

Tip: Select multiple rows or columns before using insert/delete shortcuts to apply the action to all selected areas at once.

DescriptionWindows ShortcutmacOS Shortcut
Insert rowsSelect row(s), Ctrl + Shift + =Select row(s), Command + Shift + =
Insert columnsSelect column(s), Ctrl + Shift + =Select column(s), Command + Shift + =
Delete rowsSelect row(s), Ctrl + –Select row(s), Command + –
Delete columnsSelect column(s), Ctrl + –Select column(s), Command + –
Hide selected rowsCtrl + 9Command + 9
Unhide selected rowsCtrl + Shift + 9Command + Shift + 9
Hide selected columnsCtrl + 0Command + 0
Unhide selected columnsCtrl + Shift + 0Command + Shift + 0
Autofit row heightAlt + H, O, A(Use menu: Format > AutoFit Row Height)
Autofit column widthAlt + H, O, I(Use menu: Format > AutoFit Column Width)
Set specific row heightAlt + H, O, H(Use menu: Format > Row Height)
Set specific column widthAlt + H, O, W(Use menu: Format > Column Width)

Additional Tips:

  • For inserting or deleting, ensure you’ve selected entire rows (e.g., Shift + Space) or columns (e.g., Ctrl + Space) to avoid triggering an unwanted dialog box.
  • On Windows, Ctrl + Shift + 0 to unhide columns may conflict with system settings; use the ribbon (Format > Unhide Columns) as a workaround.

Pivot Table Shortcut Keys

Pivot tables are Excel’s go-to tool for data analysis and summarization. These shortcuts help you create, modify, and manage pivot tables faster, so you can focus on insights rather than mechanics.

Tip: Use Ctrl + A (Windows) or Command + A (macOS) to select an entire pivot table for quick formatting or copying.

DescriptionWindows ShortcutmacOS Shortcut
Create pivot tableAlt + N, V(Use menu: Data > PivotTable)
Refresh pivot tableAlt + F5(Use menu: Data > Refresh)
Group selected itemsAlt + Shift + Right ArrowCommand + Shift + K
Ungroup selected itemsAlt + Shift + Left ArrowCommand + Shift + J
Select entire pivot tableCtrl + ACommand + A
Open pivot table field listAlt + JT + F(Use menu: PivotTable Analyze > Show Field List)
Expand field (in pivot table)Alt + Down ArrowOption + Down Arrow
Collapse field (in pivot table)Alt + Up ArrowOption + Up Arrow
Toggle pivot table filterAlt + Shift + S(Use menu: PivotTable Analyze > Filter)

Additional Tips:

  • Ctrl + A or Command + A works only when your cursor is inside the pivot table.
  • On macOS, pivot table shortcuts are less extensive; rely on the contextual menu (right-click) or ribbon for additional options.

Other Useful Shortcuts

This section covers a broad range of shortcuts for everyday tasks—inserting dates and times, adding comments, navigating large datasets, and working with formulas. These are the unsung heroes of Excel efficiency.

Tip: Use navigation shortcuts like Ctrl + Home (Windows) or Command + Fn + Left Arrow (macOS) to jump around your worksheet without scrolling.

DescriptionWindows ShortcutmacOS Shortcut
Insert current dateCtrl + ;Command + ;
Insert current timeCtrl + Shift + ;Command + Shift + ;
Insert date and timeCtrl + ; then Ctrl + Shift + ;Command + ; then Command + Shift + ;
Add or edit commentShift + F2Shift + F2
Start a formula==
Insert function (opens dialog)Shift + F3Shift + F3
Autosum selected rangeAlt + =Command + Shift + T
Toggle absolute/relative referencesF4 (when editing formula)Command + T (when editing formula)
Move to beginning of rowHomeFn + Left Arrow
Move to end of rowEndFn + Right Arrow
Move to beginning of worksheetCtrl + HomeCommand + Fn + Left Arrow
Move to last used cellCtrl + EndCommand + Fn + Right Arrow
Select entire rowShift + SpaceShift + Space
Select entire columnCtrl + SpaceControl + Space
Select all data in regionCtrl + Shift + *Command + Shift + *
Find text or valuesCtrl + FCommand + F
Replace text or valuesCtrl + HCommand + Shift + H
Repeat last actionF4Command + Y
Open Name ManagerCtrl + F3Command + F3

Additional Tips:

  • Ctrl + End or Command + Fn + Right Arrow moves to the last used cell in your data range, which may not be the bottom-right corner of the sheet.
  • On macOS, the Fn key is critical for navigation on compact keyboards; test your layout to confirm compatibility.

Excel shortcuts are more than just time-savers—they’re a pathway to mastering this versatile tool. By integrating these commands into your workflow, you’ll minimize repetitive tasks, boost your efficiency, and have more time to focus on what matters: analyzing and presenting your data. Start with the shortcuts that align with your most frequent tasks, and gradually build your skills to include more advanced ones.

Keep this guide bookmarked or printed as a quick reference. With practice, these shortcuts will become second nature, transforming how you use Excel on Windows or macOS. So, dive in, experiment,


FAQs

What are Excel shortcuts?

Excel shortcuts are keyboard combinations that allow you to perform actions in Excel without using a mouse, making tasks faster and more efficient.

Why are Excel shortcuts important?

Excel shortcuts are important because they help you save time, improve workflow, and reduce errors. Mastering them enhances productivity in both basic and advanced tasks.

What is the most useful shortcut in Excel?

The most useful shortcut in Excel often depends on your needs, but Ctrl + C (copy) and Ctrl + V (paste) are commonly used across many tasks.

How can I create my own Excel shortcuts?

You can customize your Excel shortcuts by navigating to the “Options” menu and then selecting “Customize Ribbon” or “Customize Quick Access Toolbar” to assign specific shortcuts.

How many Excel shortcuts are there?

There are over 100 Excel shortcuts available, covering various functions, from simple data entry to complex analysis tasks. Apply now and take your first step towards a successful career in data science! Click here to learn more.


Mastering Excel formulas and shortcut keys is an invaluable skill that can significantly boost your productivity. Whether you’re working on data analysis, financial modeling, or business reporting, being efficient with Excel will make your work more accurate and faster. Regular practice is key to becoming proficient, and the shortcuts discussed in this guide can help you navigate Excel with ease. If you’re looking to further enhance your Excel skills and open doors to a successful career in data science, consider our courses designed to boost your expertise. Apply now and take your first step towards a successful career in data science! Click here to learn more.