Filter Shortcut

excel-filter-shortcut

Discover the most wanted Excel filter shortcut list! Apply or remove filtering and sort your data through useful examples. How to Filter Data using Keyboard Shortcuts If you work with lists or a table, you can apply filter shortcuts or move the mouse over the table header row and filter like a drop-down list. This … Read more

XLOOKUP Add-in for Excel 2013, 2016 and 2019

xlookup add-in

The XLOOKUP add-in enables you to use the only Microsoft 365 compatible function under Excel 2010, Excel 2013, Excel 2016, and Excel 2019. Everyone wants to use XLOOKUP. However, if you have not a Microsoft 365 subscriber, we have a piece of good news for you: Our add-in uses user-defined functions to keep your Excel … Read more

Shortcut To Toggle Between Absolute and Relative References

shortcut to toggle between absolute and relative references

This guide will teach you how to use the F4 keyboard shortcut to toggle between absolute and relative references. In the previous lessons, you have learned how to use the absolute, relative, and mixed references in Excel. What if you want to switch between references and do not want to type the dollar sign ($) … Read more

Insert Table Shortcuts

excel insert table shortcuts

Learn how to use the insert table shortcuts in Excel to speed up this frequently used task through examples. When you are working with an Excel Table, you should know how to perform the task faster. Today’s quick guide will be about the most used table-related shortcuts. How to insert a Table in Excel using … Read more

Repeat last action

The repeat last action shortcut in Excel will repeat the previous command when it is available. Read more about the trick through examples! The repeat last action shortcut is: F4 on Excel for Windows ⌘ + Y on Excel for Mac Windows Mac If you prefer to use the mouse, click Repeat on the Quick … Read more

Shortcut to close Excel

close excel shortcut

This guide will explain how to use a shortcut to close Excel or a Workbook. If you are working with Excel, we recommend you use shortcuts. How to close Excel using a shortcut On Windows, use the Alt + F4 shortcut to close Excel. On a Mac, use the Command + Q. On Microsoft Excel … Read more

Superscript in Excel

superscript in excel

Excel Superscript is similar to the subscript function. Learn how to format a character slightly above the baseline through useful examples. What is Superscript in Excel? We use superscript in Excel to transform a number or text value into smaller fonts above the selected numbers and text. In most cases, we use this feature to … Read more

Zoom Shortcut

excel zoom shortcut

Learn how to use the Excel Zoom Shortcut to zoom in and out while using your Workbook. Then, we’ll show you the fastest ways! Excel Shortcuts to Zoom In or Out (Keyboard, Mouse, and Keystrokes) The first question: Where do you find the zoom command in Excel? Take a closer look at the bottom-right corner … Read more

Fill Color Shortcut

excel fill color shortcut

Learn how to apply Excel fill color shortcut to change the background or shading colors of a cell using various methods. In this guide, all demonstrated fill color shortcuts are for Excel for Windows versions 2010, 2013, 2016, 2019, and Office365. If you are looking for keyboard shortcuts to fill a cell quickly, you are … Read more

Subscript in Excel

subscript in Excel

Subscript in Excel is a quick formatting option to decrease the size of a text or a number. Thus, after the operation, the text is smaller. There are various methods to apply subscript in Excel: you can use shortcuts and custom cell formatting, then using the subscript checkbox. Good news: The shortcut is not short … Read more

Fill Down Shortcut

how to use the fill down shortcut

Use the Excel Fill Down Shortcut or the AutoFill function to copy data to multiple cells through useful examples. This guide will show you how to enable the Fill Down feature using a keyboard shortcut or mouse in Excel from Excel 2010 to Microsoft365 and Mac Excel. How to use the Fill Down Shortcut Steps … Read more

Edit Cell Shortcut

edit cell shortcut excel feat

This tutorial will take you step-by-step through everything you need to know to use the Edit Cell Shortcut in Excel. If you are using Excel keyboard shortcuts to save your time, this article is yours. Editing cell is a basic operation in Excel. Today, we will discover and show you the best methods to edit … Read more

Excel Cut Shortcut

excel cut shortcut

Use the Ctrl + X cut shortcut in Excel to move the selected content, formatting styles, and formulas, or use the same shortcut on Mac. Once your data is in the clipboard, use the paste values shortcut or the paste special command. Windows Shortcut Mac Shortcut How the cut function work The most important thing … Read more

Shortcut to open the insert function dialog box

shortcut to open the insert function dialog box

To open the Insert Function dialog box, press Shift + F3. To start the Formula Builder dialog box on a Mac using Fn + Shift + F3 shortcut. Windows Shortcut Mac shortcut Excel has hundreds of built-in functions. If you want to find the proper function, the Insert Function command will help. How to open … Read more

Sum Shortcut in Excel

excel sum shortcut

Learn how to use the Excel SUM Shortcut by pressing Alt + = keys to create a formula and quickly summarize values in a range of cells. The Excel Sum Shortcut (using the SUM function) helps you create a formula using the selected range. It does not matter you are working on rows or columns … Read more

Shortcuts not working in Excel

excel shortcuts not working

This guide will help you if your keyboard shortcuts are not working in Excel. Learn how to fix it quickly and easily! We love Excel Keyboard Shortcuts and other time-saving features! However, you want to apply your favorite shortcut, but nothing happens. How to deal with it? One of the most frustrating things: your keyboard … Read more