Shortcuts for Functions and Formulas in ExcelĮxcel is mostly about formulas and functions. This simple shortcut will hide all the selected columns. Press Shift+Space to select the whole row. You will no longer need to use the header and navigate with your mouse. Press Ctrl+Space to select the entire column. Save time by selecting columns and rows faster by using the following keyboard shortcuts instead of clunky mouse movements. This combination of keys will toggle the display of ribbons. This command quickly opens the “open file” dialog and allows you to access another workbook. For example, Ctrl+Right Arrow will send you to the last cell to the right, while Ctrl+Down Arrow will select the last cell at the bottom. Go to the last populated cell in the direction of the arrow key. Quickly access the Help function in Excel. Press this combination of keys to quickly access the find function. It is an amazing shortcut that will allow you to skip all the navigation through Excel’s toolbar. This shortcut will show you which cell is active. This command will switch the worksheet tabs to the left. Press this command combination to switch the worksheet tabs to the right. Navigate through Excel and switch between worksheets tabs quicker using the following keyboard shortcuts. Now that you know the basic shortcuts let’s focus on other Excel keyboard shortcuts that will boost your productivity and speed. Ungroup the pivot table items you selected Right-clickĪccess the context menu for the selected row, column, or cell. If you find yourself using many pivot tables, start using the shortcuts below regularly. Pivot tables are handy if you have long rows of data that you need to summarize, and they also allow you to compare your data. It can summarize the selected rows and columns of the spreadsheet or even reorganize them. The Pivot Table is a potent tool in Excel. These shortcuts are convenient, and you should get used to using them not only in Excel, but also in Microsoft Word, internet browsers, or any other app you frequently use for business or leisure. Nonetheless, here’s a useful table with the most commonly used Excel keyboard shortcuts that you need to start using to quickly improve your mastery over spreadsheets.
#What is f4 on mac excel windows#
You’re probably familiar with some shortcuts as they are commonly used across most Windows 10/11 and Microsoft Office apps. So let’s focus on the most important ones that you’ll need on a daily basis.
#What is f4 on mac excel install#
You may want to install a third-party macro (or build your own) to create shortcuts for the custom number formats you require, if your employer has not already installed such a macro on your work computer.Įach shortcut is assigned a "utility", which represents the shortcut's time-saving potential and expected frequency of use on a scale of 1 to 5.You will use some Excel shortcuts more often than the others. Therefore, you won't find a discussion of these shortcuts here. While there are several shortcuts that can be used to apply number formats, these default formats are rarely suitable for use in professional-looking financial models. In some cases there is more than one shortcut for a given action or command. There are many Excel keyboard shortcuts, but we focus here only on those you might actually use regularly. You should never need them again, and you won't be a modeling bad-ass until you perform this critical step. Before we get started, take out a small screwdriver or key and pop off the F1, Scroll Lock, and Insert keys from your keyboard and store them in a safe place.