Excel 2020: Total the Visible Rows »
January 16, 2020
After you’ve applied a filter, say that you want to see the total of the visible cells.
Excel 2020: Filter by Selection for Numbers Over/Under »
January 15, 2020
What if you want to see all values greater than $20,000?
Excel 2020: Filter by Selection in Excel »
January 13, 2020
The filter dropdowns have been in Excel for decades, but there are two faster ways to filter. Normally, you select a cell in your data, choose Data, Filter, open the dropdown menu on a column heading, uncheck Select All, and scroll through a long list of values, trying to find the desired item.
Excel 2020: Break Apart Data »
January 9, 2020
People often ask about how to parse data that is all in a single column. Say you wanted to sort the data by zip code.
Excel 2020: Double-Click the Fill Handle to Copy a Formula »
January 8, 2020
You have thousands of rows of data. You’ve added a new formula in the top row of your data set, something like =PROPER(A2&" "&B2). You need to copy the formula down to all of the rows of your data set.
Excel 2020: Ask Excel a Question About Your Data »
January 6, 2020
A new Natural Language Query feature is rolling out to Office 365 in late 2019 and early 2020. The feature uses artificial intelligence to answer questions about your data.
December 19, 2019
I published more than 200 ideas since February. While the following ideas did not get much press here, they are self-explanatory in a 140-character tweet.
Excel 2019: Ctrl+Click to Unselect Cells »
December 18, 2019
You've always had the ability to select multiple selections in Excel by Ctrl+Dragging to select cells. However, in the past, there was no way to unselect one cell. You can now Ctrl + Click to unselect that cell.
Excel 2019: Favorite Keyboard Shortcuts »
December 16, 2019
As I started polling readers about their favorite Excel tips, a large number of them were keyboard shortcuts. Following keyboard shortcuts are presented in order of popularity.
Excel 2019: Settings in the Excel Options Menu »
December 12, 2019
Consider a few of these settings after you choose File, Options.
Excel 2019: Create Your Own QAT Routines Using VBA Macros »
December 11, 2019
There are several short macros you can add to your Personal Macro Workbook and then add to the QAT. In this tip, you will see how to create the Personal Macro Workbook, type some macros, and then assign them to icons on the QAT.
Excel 2019: Customize the Quick Access Toolbar »
December 9, 2019
Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).