Excel shortcuts have proven to improve efficiency and are known for their time-saving capabilities. But with so many shortcut keys, it becomes difficult to remember them all. So we have curated a list of excel shortcuts cheat sheets frequently used at work to save you time and energy.
This will be the one-stop guide that you can rely on and refer to. These Excel shortcut keys can save you tons of time daily as they increase speed and productivity. Imagine moving your hand and the mouse every time to the toolbar and clicking several times. Instead of just clicking a few function keys to get the job done.
So what is the primary purpose of using the excel shortcut cheat sheet? First, it improves speed and productivity by navigating from one cell to another, grouping data, and, most importantly, filling in formulas. Another benefit of using excel shortcuts is that they allow you to complete the task accurately and precisely.
Furthermore, let us eloquently explain some reasons for using the excel formula cheat sheet.
The frequently used shortcut keys for Microsoft Excel are listed below, along with a brief description. We have arranged them according to the category to make it simple for you to find the shortcut keys you require.
|Ctrl+A||Copy the entire worksheet.|
|Ctrl+B||Bold text on the worksheet.|
|Ctrl+ C||Copy Cell|
|Ctrl+ N||Create a new workbook.|
|Ctrl+O||Open existing workbook|
|Ctrl+I||Format the text in italics.|
|Ctrl+U||Underline the text.|
|Ctrl+ F||Open find dialog box|
|Ctrl+H||Open the replace dialog box.|
|Ctrl+ S||Save the workbook|
|Ctrl+ pg up||To move up the cell|
|Ctrl+PgDown||To move down the cell|
|Ctrl+P||Open the print dialog box.|
|Ctrl+ Y||Repeat the action|
These are some primary keys and formatting keys that will help you navigate through the worksheet and get basic cell formatting done.
In the next section, we will learn how to apply some advanced formatting that might come in handy. For example, editing a cell, adding a border, etc.
|Ctrl+Shift+!||Apply comma to numbers|
|Ctrl+Shift+%||Format number as percentage|
|Ctrl+Shift+$||Format as currency.|
|Ctrl+Shift+=||Insert rows, columns.|
|Ctrl+Shift+*||Insert or remove outline borders.|
|Ctrl+Shift++||Insert a row|
|Ctrl+Shift+-||Delete a row|
|Ctrl+Shift+ #||Format a number as date|
|Ctrl+Shift+ &||Add or remove outline border to selected cell|
|Ctrl+Shift+^||Format a number as an exponential.|
|Tab||To move to next cell|
|Shift+Tab||Move to previous cell|
|Alt+ H+H||To fill color|
|Alt+H+F+C||Change font color|
|Alt+H+A+C||Align text in the cell|
|Alt+H+B||To add a border|
|Alt+F+F||Change font style|
|Alt+F+S||Change font size|
After learning about data shortcuts in Excel, let’s quickly move on to understanding formulas.
|=||Begin a formula|
|Alt+=||Insert auto sum formula|
|Shift+F3||Insert a function- paste a formula|
|Shift+F9||Calculate active worksheet|
|F9||Calculate all worksheets|
|Ctrl+Shift+F9||Recalculate all worksheets|
|Ctrl+`||Toggle formulas on and off|
|Ctrl+Shift+U||Expand or collapse formula bar|
|F2||Edit a cell|
|F4||Repeat last action|
|F5||Display go to dialog box|
|F7||Run a spell check.|
|Alt+N+H||Insert header and footer|
|Alt+W+F+P||View page layout|
|Alt+W+F+I||View page break|
These were some prominent excel shortcuts to learn about and master Microsoft Excel. Without a doubt, shortcuts make our lives simpler. Therefore, using Microsoft Excel, you can use this article to discover some of the most useful ones. You would probably know a few of these shortcuts, like Ctrl+C and Ctrl+V, but there would be many other excel shortcut keys that you wouldn’t be aware of.
To operate like an expert, develop the habit of using your keyboard rather than your mouse. How many of the following Excel shortcut cheat sheets for formatting and navigation are you already familiar with? How many are you now able to use?
Microsoft Excel might seem tedious, but it can be a lot of fun once you thoroughly complete all the formatting shortcuts. Plus, you can make your worksheet look vibrant and attractive by adding colors to the sheet and paying attention to alignment.