Excel is the top spreadsheet application of 2024. It offers powerful tools for organizing and analyzing complex datasets, as well as numerous keyboard shortcuts that help users get the job done quickly.
Though you have been using Excel for years, sometimes you wonder how a few people seem to navigate Excel like pros and get things done within seconds.
The secret often lies in knowing the right keyboard shortcuts.
So, if you are still clicking around the mouse, this article is for you. From beginners to advanced users, mastering these shortcuts can save a lot of time and make work much more manageable.
Welcome to this guide, where we will discuss all Excel keyboard shortcuts divided into various categories for easy understanding. We will discuss keyboard shortcuts for Windows, Mac, and Chrome OS.
How can I view the keyboard shortcuts that are compatible with Excel?
Microsoft Excel uses numerous combinations of keys to perform various tasks.
You may be familiar with the following popular keyboard shortcuts:
- “CTRL + C” – Keyboard shortcut to copy the contents of a spreadsheet
- “CTRL + A” – Keyboard shortcut to select all the contents
These are common once, but you may be wondering how someone can explore the complete list of Excel keyboard shortcuts.
So, here are the steps to view all of the compatible keyboard shortcuts in Excel:
- Open a new Excel sheet
- Hover to the main menu
- Go to the “Help” tab
- Click on the “Help” button in the “Help” group
- The Help pane will open on the right side of the screen
- In the search bar, type “Keyboard Shortcuts”
- Click on the “Keyboard Shortcuts in Excel” link as shown below
- Excel will show a list of shortcuts compatible with your version of Excel
Microsoft provides a comprehensive list of shortcuts to perform various tasks like formatting, editing, and navigating. Using these methods, you can quickly discover the most useful keyboard shortcuts as per your unique needs.
In the following section of the article, we discussed all of the Excel keyboard shortcuts and ways to use them effectively.
What are Compatible Keyboard Shortcuts
Compatible Keyboard Shortcuts in Excel are keyboard button combinations that work across different versions of Excel and operating systems (such as Windows and Mac).
Using these compatible keyboard shortcuts, you can perform specific actions, such as cell formatting and navigating through a workbook, regardless of which version of Excel you are using.
Below are examples of a few famous compatible keyboard combinations:
- “CTRL + Home” for Windows and “CMD + Home” for Mac: Moves to the beginning of the worksheet
- “CTRL + C” for Windows and “CMD + C” for Mac: Copies the selected cells
- “CTRL +B” for Windows and “CMD + B” for Mac: Applies or removes the bold formatting
- “ALT + E + S + V” for Windows and “CMD + Option +V” for Mac: Opens the Paste Special dialog
These shortcuts are essential because they ensure quick and efficient data management using Excel. Knowing such keyboard combinations helps you get the job done quickly, whether you are using a Windows PC or a Mac.
Can you create your custom Keyboard Shortcuts in Excel?
Excel does not allow users to create custom keyboard shortcuts for specific tasks directly within the program.
However, there are a few workarounds to create unique keyboard shortcuts:
- Use Macros: You can create a small program that automates a series of actions and then assign a custom keyboard shortcut to that program (Macro). Just go to “Developer > Record Macro” and follow the instructions to create a macro.
- Excel Add-ons: There are some Excel Add-ons or third-party tools like AutoHotkey (for Windows) or Keyboard Maestro (for Mac) that allow customization of keyboard shortcuts.
- Use the Quick Access Toolbar: You can add frequently used commands to the Quick Access Toolbar and then use the ALT key combinations to access them.
All Excel Keyboard Shortcuts of 2024
We have compiled the entire list of keyboard shortcuts in Excel. The list is divided by the categories.
The spreadsheet view is better than what we discussed at the beginning using the “Help” tab of Excel. You can download the following file for free and print it to put on your desk.
Note that a few of the keyboard shortcuts are common, and most are specific to Excel. You can view the entire Excel worksheet through the following link.
As you can see in the above image, the spreadsheet is divided into three columns to display the keyboard shortcuts for Windows, Mac, and Chrome OS computers. While scrolling down, you will notice the light green color highlights the categories.
It is a printable Excel Sheet that can be pinned to your office desk.
Let us discuss all the above keyboard shortcut categories in detail in the following section of the article.
Common Action Keyboard Shortcuts in Excel
The below list contains keyboard shortcuts for the most common actions in Excel.
For example, you can select an entire row or column, undo the edits, find and replace the cell content, open a new Excel sheet, etc.
Learning these shortcuts will surely boost your overall computing skills in Excel.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Select column | Ctrl + Space | Ctrl + Space | Ctrl + Space |
| Select row | Shift + Space | Shift + Space | Shift + Space |
| Select all | Ctrl + aCtrl + Shift + Space | ⌘ + a⌘ + Shift + Space | Ctrl + a |
| Undo | Ctrl + z | ⌘ + z | Ctrl + z |
| Redo | Ctrl + yCtrl + Shift + zF4 | ⌘ + y⌘ + Shift + zFn + F4 | Ctrl + yCtrl + Shift + z |
| Find | Ctrl + f | ⌘ + f | Ctrl + f |
| Find and replace | Ctrl + h | ⌘ + Shift + h | Ctrl + h |
| Fill range | Ctrl + Enter | ⌘ + Enter | Ctrl + Enter |
| Fill down | Ctrl + d | ⌘ + d | Ctrl + d |
| Fill right | Ctrl + r | ⌘ + r | Ctrl + r |
| Save(every change is saved automatically in Drive) | Ctrl + s | ⌘ + s | Ctrl + s |
| Open | Ctrl + o | ⌘ + o | Ctrl + o |
| Ctrl + p | ⌘ + p | Ctrl + p | |
| Copy | Ctrl + c | ⌘ + c | Ctrl + c |
| Cut | Ctrl + x | ⌘ + x | Ctrl + x |
| Paste | Ctrl + v | ⌘ + v | Ctrl + v |
| Paste values only | Ctrl + Shift + v | ⌘ + Shift + v | Ctrl + Shift + v |
| Show common keyboard shortcuts | Ctrl + / | ⌘ + / | Ctrl + / |
| Insert new sheet | Shift + F11 | Shift + Fn + F11 | |
| Compact controls | Ctrl + Shift + f | Ctrl + Shift + f | Ctrl + Shift + f |
| Rename sheet | Alt + 1 | ||
| Select current region around selected cell | ⌘ + Shift + *Ctrl + Shift + * | ||
| Displays or hides the menus | ⌘ + Option + RCtrl + Shift + F |
The keyboard shortcuts above are helpful for day-to-day operations, copying and pasting values, and selecting the entire table.
Keyboard Shortcuts to Format Cells like a Pro
Excel is very good at generating excellent reports with proper formatting.
Though most of the formatting tools are directly accessible via the toolbar that sits below the main menu, knowing the following keyboard shortcuts will enhance your efficiency.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Bold | Ctrl + b | ⌘ + b⌘ + 2Ctrl + 2 | Ctrl + b |
| Underline | Ctrl + u | ⌘ + u⌘ + 4Ctrl + 4 | Ctrl + u |
| Italic | Ctrl + i | ⌘ + i⌘ + 3Ctrl + 3 | Ctrl + i |
| Strikethrough | Alt + 5 | ⌘ + Shift + x⌘ + 5Ctrl + 5 | Alt + Shift + 5 |
| Center align | Alt + H, A, C | Option + Cmd + C | Alt + H, Alt + C |
| Left align | Alt + H, A, L | Option + Cmd + L | Alt + H, Alt + L |
| Right align | Alt + H, A, R | Option + Cmd + R | Alt + H, Alt + R |
| Apply top border | Alt + Shift + 1 | Option + Shift + 1 | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 | Option + Shift + 2 | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 | Option + Shift + 3 | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 | Option + Shift + 4 | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 | Option + Shift + 6 | Alt + Shift + 6 |
| Apply outer border | Alt + Shift + 7Ctrl + Shift + 7 | Option + Shift + 7⌘ + Shift + 7Ctrl + Shift + 7 | Alt + Shift + 7Ctrl + Shift + 7 |
| Insert link | Ctrl + k | ⌘ + k | Ctrl + k |
| Insert time | Ctrl + Shift + ; | ⌘ + Shift + ; | Ctrl + Shift + ; |
| Insert date | Ctrl + ; | ⌘ + ; | Ctrl + ; |
| Insert date and time | Ctrl + Shift + D | Cmd + Shift + D | Ctrl + Shift + D |
| Format as decimal | Ctrl + Shift + 1 | Cmd + Shift + 1 | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 | Cmd + Shift + 2 | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 | Cmd + Shift + 3 | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 | Cmd + Shift + 4 | Ctrl + Shift + 4 |
| Format as Percentage | Ctrl + Shift + 5 | Cmd + Shift + 5 | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 | Cmd + Shift + 6 | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + \ | ⌘ + \ | Ctrl + \ |
Besides these, you can change the font styles, insert or remove borders, and change the cell content formatting to time, date, currency, percentage, etc.
Note that the above keyboard shortcuts are lengthy but easy to remember. If you are responsible for preparing the monthly and annual reports, these shortcuts are for you.
Keyboard Shortcuts for Navigating Swiftly through the Spreadsheet
Below is a list of shortcuts that can help users improve their data analytics skills by quickly navigating through complex datasets.
Suppose you are giving a presentation to your colleagues, and while explaining the annual sales report, you get into the middle of the table. Now, you need to return to the table’s first row. Instead of scrolling to the top using your mouse, press the “CTRL + Home” on your keyboard to immediately return to the beginning of the table.
Here are a few more keyboard shortcuts to navigate the entire spreadsheet within a few seconds:
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Move to beginning of row | Home | Fn + Left Arrow | Search + Left Arrow |
| Move to beginning of sheet | Ctrl + Home | ⌘ + Fn + Left Arrow | Ctrl + Search + Left Arrow |
| Move to end of row | End | Fn + Right Arrow | Search + Right Arrow |
| Move to end of sheet | Ctrl + End | ⌘ + Fn + Right Arrow | Ctrl + Search + Right Arrow |
| Scroll to active cell | Ctrl + Backspace | ⌘ + Backspace | Ctrl + Backspace |
| Move to next sheet | Alt + Down Arrow | Option + Down Arrow MacBook:Option + Right Arrow | Ctrl + Shift + Search + Down Arrow |
| Move to previous sheet | Alt + Up Arrow | Option + Up ArrowMacBook:Option + Left Arrow | Ctrl + Shift + Search + Up Arrow |
| Display list of sheets | Alt + Shift + k | Option + Shift + k | Alt + Shift + k |
| Open hyperlink | Alt + Enter | Option + Enter | Alt + Enter |
| Open Explore | Ctrl + Alt + Shift + i | ⌘ + Option + Shift + i | Ctrl + Alt + Shift + i |
| Go to side panel | Ctrl + Alt + .Ctrl + Alt + , | ⌘ + Option + .⌘ + Option + , | Alt + Shift + .Alt + Shift + , |
| Move focus out of spreadsheet | Ctrl + Alt + Shift + m | Ctrl + ⌘ + Shift + m | Ctrl + Alt + Shift + m |
| Move to quicksum(when a range of cells is selected) | Alt + Shift + q | Option + Shift + q | Alt + Shift + q |
| Move focus to popup(for links, bookmarks, and images) | holding Ctrl + Alt, press e then p | holding Ctrl + ⌘, press e then p | holding Ctrl + Alt, press e then p |
| Open drop-down menu on filtered cell | Ctrl + Alt + r | Ctrl + ⌘ + r | Ctrl + Alt + r |
| Open revision history | Ctrl + Alt + Shift + h | ⌘ + Option + Shift + h | Ctrl + Alt + Shift + h |
| Close drawing editor | Shift + Esc | ⌘ + EscShift + Esc | Ctrl + EscShift + Esc |
| Show “Go to range” dialog | Ctrl + G | ||
| Find and replace with Find tab selected | Ctrl + F |
The above keyboard shortcuts allow you to move through the Excel worksheets quickly. With these shortcuts, you can also open a hyperlink within a second.
Other useful keyboard shortcuts in the above table are “CTRL + ALT + R”, which lets you open sort and filter options on a filtered cell, and “SHIFT + ESC” to close a popup or dialog box.
You can surely master these shortcuts with practice, and they will surely be helpful in the long run.
Keyboard Shortcuts to Insert and Edit Comments
Excel is one of the most powerful spreadsheet applications. Its intuitive interface makes it easy for even beginners to use.
It supports real-time collaboration, empowered with threaded comments. Here is a list of keyboard shortcuts for inserting and editing comments in Excel.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Insert/edit note | Shift + F2 | Shift + F2 | Shift + Search + 2 |
| Insert/edit comment | Ctrl + Alt + m | ⌘ + Option + m | Ctrl + Alt + m |
| Open comment discussion thread | Ctrl + Alt + Shift + o | ⌘ + Option + Shift + o | Ctrl + Alt + Shift + o |
| Enter current comment | holding Ctrl + Alt, press e then c | holding Ctrl + ⌘, press e then c | holding Ctrl + Alt, press e then c |
| Move to next comment | holding Ctrl + Alt, press n then c | holding Ctrl + ⌘, press n then c | holding Ctrl + Alt, press n then c |
| Move to previous comment | holding Ctrl + Alt, press p then c | holding Ctrl + ⌘, press p then c | holding Ctrl + Alt, press p then c |
| Reply to current selected comment | Ctrl + Alt + M | Cmd + Option + M | Ctrl + Alt + M |
| Move to next selected comment | Ctrl + Alt + N | Cmd + Option + N | Ctrl + Alt + N |
| Move to previous selected comment | Shift + Alt + Up Arrow | Cmd + Option + Up Arrow | Shift + Alt + Up Arrow |
| Resolve current selected comment | Ctrl + Alt + M | Cmd + Option + M | Ctr; + ALt + M |
| Exit current comment | Ecs | Esc | Esc |
The above keyboard shortcuts aim to improve your communication speed. You can quickly reply, resolve, or delete the selected comment. To open the comment discussion thread, use the keyboard shortcut “CTRL + ALT + SHIFT + A”.
These handful of keyboard shortcuts are worth remembering if your team largely depends upon Microsoft Excel for the company’s data organization and analysis.
With practice, all of them are easy to remember and pretty straightforward.
Keyboard Shortcuts to Navigate through the Main Menu
Microsoft Excel boasts an easy-to-use interface. Almost all of the tools and functions can be accessed quickly using the main menu and toolbar section. Many users appreciate the way Excel’s main menu allows them to access the formatting tools quickly to adjust the font and cell styles.
We have compiled a list of keyboard shortcuts to access the main menu in the following table.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| File menu | in Google Chrome: Alt + fother browsers: Alt + Shift + f | Ctrl + Option + f | Alt + f |
| Edit menu | in Google Chrome: Alt + eother browsers: Alt + Shift + e | Ctrl + Option + e | Alt + e |
| View menu | in Google Chrome: Alt + vother browsers: Alt + Shift + v | Ctrl + Option + v | Alt + v |
| Insert menu | in Google Chrome: Alt + iother browsers: Alt + Shift + i | Ctrl + Option + i | Alt + i |
| Format menu | in Google Chrome: Alt + oother browsers: Alt + Shift + o | Ctrl + Option + o | Alt + o |
| Data menu | in Google Chrome: Alt + dother browsers: Alt + Shift + d | Ctrl + Option + d | Alt + d |
| Tools menu | in Google Chrome: Alt + tother browsers: Alt + Shift + t | Ctrl + Option + t | Alt + t |
| Open insert menu | Ctrl + Alt + Shift + =Ctrl + Alt + =(with cells selected) | ⌘ + Option + = (with cells selected) | Ctrl + Alt + = (with cells selected) |
| Open delete menu | Ctrl + Alt + – (with cells selected) | ⌘ + Option + – (with cells selected) | Ctrl + Alt + – (with cells selected) |
| Form menu(present when the spreadsheet is connected to a form) | in Google Chrome: Alt + mother browsers: Alt + Shift + m | Ctrl + Option + m | Alt + m |
| Add-ons menu | in Google Chrome: Alt + nother browsers: Alt + Shift + n | Ctrl + Option + n | Alt + n |
| Help menu | in Google Chrome: Alt + hother browsers: Alt + Shift + h | Ctrl + Option + h | Alt + h |
| Accessibility menu(present when screen reader support is enabled) | in Google Chrome: Alt + aother browsers: Alt + Shift + a | Ctrl + Option + a | Alt + a |
| Sheet menu(copy, delete, and other sheet actions) | Alt + Shift + s | Option + Shift + s | Ctrl + Shift + s |
| Context menu | Ctrl + Shift + \Shift + F10 | ⌘ + Shift + \Shift + F10 | Ctrl + Shift + \Shift + F10 |
With the above keyboard shortcuts, you can quickly access all the tabs from the main menu, including File, Home, Insert, Page Layout, Formulas, Data, Review, View, Automate, Developer, and Tools.
If you are stuck, simply press the “ALT + H” button to access the Help menu.
Keyboard Shortcuts to Manipulate Rows and Columns
These are another set of commands for Excel pros. They allow users to insert rows and columns at desired locations quickly.
You can also delete a row or column instantly using the following shortcuts.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Insert rows above | Ctrl + Alt + Shift + =Ctrl + Alt + =(with rows selected)in Google Chrome: Alt + i, then rother browsers: Alt + Shift + i, then r | ⌘ + Option + = (with rows selected)Ctrl + Option + i, press r then r | Ctrl + Alt + = (with rows selected)Alt + i, then r |
| Insert rows below | in Google Chrome: Alt + i, then wother browsers: Alt + Shift + i, then w | Ctrl + Option + i, press r then b | Alt + i, then w |
| Insert columns to the left | Ctrl + Alt + Shift + =Ctrl + Alt + =(with columns selected)in Google Chrome: Alt + i, then cother browsers: Alt + Shift + i, then c | ⌘ + Option + = (with columns selected)Ctrl + Option + i, press c then c | Ctrl + Alt + = (with columns selected)Alt + i, then c |
| Insert columns to the right | in Google Chrome: Alt + i, then oother browsers: Alt + Shift + i, then o | Ctrl + Option + i, press c then o | Alt + i, then o |
| Delete rows | Ctrl + Alt + – (with rows selected)in Google Chrome: Alt + e, then dother browsers: Alt + Shift + e, then d | ⌘ + Option + – (with rows selected)Ctrl + Option + e, then d | Ctrl + Alt + – (with rows selected)Alt + e, then d |
| Delete columns | Ctrl + Alt + – (with columns selected)in Google Chrome: Alt + e, then eother browsers: Alt + Shift + e, then e | ⌘ + Option + – (with columns selected)Ctrl + Option + e, then e | Ctrl + Alt + – (with columns selected)Alt + e, then e |
| Hide row | Ctrl + Alt + 9 | ⌘ + Option + 9 | Ctrl + Alt + 9 |
| Unhide row | Ctrl + Shift + 9 | ⌘ + Shift + 9 | Ctrl + Shift + 9 |
| Hide column | Ctrl + Alt + 0 | ⌘ + Option + 0 | Ctrl + Alt + 0 |
| Unhide column | Ctrl + Shift + 0 | ⌘ + Shift + 0 | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right Arrow | Option + Shift + Right Arrow | Alt + Shift + Right Arrow |
| Ungroup rows or columns | Alt + Shift + Left Arrow | Option + Shift + Left Arrow | Alt + Shift + Left Arrow |
| Expand grouped rows or columns | Alt + Shift + Down Arrow | Option + Shift + Down Arrow | Alt + Shift + Down Arrow |
| Collapse grouped rows or columns | Alt + Shift + Up Arrow | Option + Shift + Up Arrow | Alt + Shift + Up Arrow |
At the End of the list, you will find the keyboard shortcuts to group and ungroup rows or columns.
The above keyboard shortcuts help you hide and unhide rows or columns in Excel apart from just inserting them, that too in the blink of an eye.
Please note that in the case of browser-based Excel, a few keyboard shortcuts depend upon the type of browser.
Keyboard Shortcuts to Manipulate Formulas
Excel uses numerous formulas or functions to perform various calculations.
There are over 400+ built-in functions in Excel. You can analyze and visualize complex datasets using these functions.
Sometimes, users need clarification about whether a cell contains a formula, number, or plain text. This is particularly true in massive datasets that include income or expenses over a given period of time.
Here are the Excel keyboard shortcuts to manipulate the cells holding the formulas:
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Show all formulas | Ctrl + ~ | Ctrl + ~ | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter | ⌘ + Shift + Enter | Ctrl + Shift + Enter |
| Collapse an expanded array formula | Ctrl + e | ⌘ + e | Ctrl + e |
| Show/hide formula help(when entering a formula) | Shift + F1 | Shift + Fn + F1 | Shift + Search + 1 |
| Full/compact formula help(when entering a formula) | F1 | Fn + F1 | Search + 1 |
| Absolute/relative references(when entering a formula) | F4 | Fn + F4 | Search + 4 |
| Toggle formula result previews(when entering a formula) | F9 | Fn + F9 | Search + 9 |
| Resize formula bar(move up or down) | Ctrl + Up / Ctrl + Down | Ctrl + Option + Up and Ctrl + Option + Down | Ctrl + Shift + Up Arrow andCtrl + Shift + Down Arrow |
| Toggle formula range selection(when entering a formula) | F2Ctrl + e | F2Ctrl + e | F2Ctrl + e |
With the above keyboard shortcuts, you can view the cells containing the formulas, insert absolute references, resize the formula bar, and much more.
They will surely enhance your data analytics skills and reduce calculation errors. Please make sure you remember and practice them often.
Keyboard Shortcuts for Screen Reading
A screen reader is used to announce the location and content of the cell. In simple words, a screen reader converts text within a cell into spoken words.
It is made for people with cognitive impairment and motor disabilities.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Turn on screen reader support | Ctrl + Alt + z | ⌘ + Option + z | Ctrl + Alt + z |
| Enable braille support | Ctrl + Alt + h | ⌘ + Option + h | Ctrl + Alt + h |
| Read column | Ctrl + Alt + Shift + c | ⌘ + Option + Shift + c | Ctrl + Alt + Shift + c |
| Read row | Ctrl + Alt + Shift + r | ⌘ + Option + Shift + r | Ctrl + Alt + Shift + r |
Using the above shortcuts, you can access the screen reader support and ask the program to read a column or row based on the selected cell.
FAQs
Q. How do you create custom keyboard shortcuts in Excel?
There is no direct way of creating a keyboard shortcut in Excel.
Either use a predefined keyboard shortcut or create a macro and initiate it using a combination of keyboard buttons.
We have already discussed multiple methods to create custom keyboard shortcuts in Excel at the beginning of this article.
Here, let us learn to create a macro and assign a keyboard shortcut:
- Launch the Excel application on your desktop
- Go to the “View” tab
- Click on the “Macros” dropdown
- Select “Record Macros”
- In the Record Macro dialog box, enter the Macro name and assign your keyboard shortcut
- Carry out the steps you want your shortcut to perform, and stop recording
That’s it! Now, you can press the assigned keys to execute the Macro anytime.
Q. What is the shortcut to create a new Excel?
To create a new sheet within an Excel, you can use the following keyboard combinations:
- “Ctrl + N” for Windows
- “Cmd + N” for Mac
Using the above keyboard shortcut, you will be able to immediately create a new blank worksheet within no time.
Q. What is the keyboard shortcut for sum in Excel?
There is a keyboard shortcut for every task you perform in Excel. The main goal is to make your workflow faster and more efficient.
You can use the following keyboard combinations to find the sum of the selected cells:
- “Alt + =” for Windows
- “Cmd + Shift + T” for Mac
With the above keyboard shortcuts, you don’t need to enter the formula manually. Often, we are asked to find the sum of the values from a given cell range; the above keyboard shortcut will help us get the job done within a few seconds.
Q. What is the keyboard shortcut to the Find and Replace tool in Excel?
The Find and Replace tool in Excel allows us to quickly search for a specific text, number, or formula and replace it with new content.
This is especially useful while working with large datasets, as it saves a lot of time and ensures consistency across your workbook.
Keyboard Shortcuts for Find and Replace tool in Excel are as follows:
- “Ctrl + F” (for Windows) and “Cmd + F” (for Mac) let you open the Find tool in Excel
- “Ctrl + H” (for Windows) and “Cmd + H” (for Mac) let you open the Replace tool in Excel
To Summarize: Excel Keyboard Shortcuts
Knowing keyboard shortcuts is crucial for any computer application user. Keyboard shortcuts improve their productivity and allow them to get the most out of the given program.
I hope you learned all the bells and whistles of Excel keyboard shortcuts.
In reality, not all of them are going to be helpful to you. But the more you know, the better you become at organizing data.
With practice, you will master most of them and advance your computing or data analysis skills.
Make sure you download our Excel Keyboard Shortcuts Mastersheet for your reference. You can also print it easily.
Finally, remember to explore our blog section for more tips and tricks on how to use Microsoft Excel and Google Sheets like a pro.