MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Excel Replace the Comma Style in Book.xltx. Photo Credit: Javier Reyes at Unsplash.com

Excel 2020: Replace the Comma Style in Book.xltx »


February 17, 2020

The Excel team offers Currency, Percent, and Comma icons in the center of the Home tab of the Ribbon. The tooltip says the Comma Style formats with a thousands separator. I despise this icon. Why do I despise this icon?

Changes to Book Template  are Cumulative. Photo Credit: Annie Spratt at Unsplash.com

Excel 2020: Changes to Book Template are Cumulative »


February 13, 2020

Anything you do to Book.xltx (default workbook) is cumulative. Build the workbook with your favorite settings today. If you discover some new settings that you would like to add to Book.xltx in the future, follow these steps:

Excel Use Default Settings for All Future Workbooks. Photo Credit: Payton Ferris at Unsplash.com

Excel 2020: Use Default Settings for All Future Workbooks »


February 12, 2020

In a few minutes, you can teach Excel your favorite settings. Then, every time you create a new workbook with Ctrl+N or insert a new worksheet, the worksheet will inherit all of your favorite settings.

Excel Use INDIRECT for a Different Summary Report. Photo Credit: Brendan Church at Unsplash.com

Excel 2020: Use INDIRECT for a Different Summary Report »


February 10, 2020

Say that you want to build the following report, with months going down column A. In each row, you want to pull the grand total data from each sheet. Each sheet has the same number of rows, so the total is always in row 12.

Create a SUM That Spears Through All Worksheets. Photo Credit: Shuenz Hsu at Unsplash.com

Excel 2020: Create a SUM That Spears Through All Worksheets »


February 6, 2020

You have a workbook with 12 worksheets, 1 for each month. All of the worksheets have the same number of rows and columns. You want a summary worksheet in order to total January through December.

Change All Sheets with Group Mode. Photo Credit: Yiran Ding at Unsplash.com

Excel 2020: Change All Sheets with Group Mode »


February 5, 2020

Any time your manager asks you for something, he or she comes back 15 minutes later and asks for an odd twist that wasn't specified the first time. Now that you can create worksheet copies really quickly.

Power up status bar: Photo by Victor Freitas on Unsplash

Excel 2020: Power Up the Status Bar Statistics »


February 3, 2020

When you select two or more numeric cells, the total appears in the status bar in the lower right of the Excel window.

Add a Total Row and a Total Column with One AutoSum. Photo credit: Tim Mossholder at Unsplash.com.

Excel 2020: Add a Total Row and a Total Column with One AutoSum »


January 30, 2020

Say that you want to add a total row and a total column to a data set.

Excel Put the Worksheet Name in a Cell. Photo Credit: Jannes Glas at Unsplash.com

Excel 2020: Put the Worksheet Name in a Cell »


January 29, 2020

If you want each report to have the name of the worksheet as a title, use this formula.

Which Excel Columns are Filtered? »


January 28, 2020

Karen from Chicago has a worksheet with 200 columns. The filter drop-downs are enabled. She wants a quick way to see which columns have a filter applied and what filter is applied to those columns.

Fast Worksheet Copy. Photo Credit: Joe Green at Unsplash.com

Excel 2020: Fast Worksheet Copy »


January 27, 2020

You can right-click any sheet tab and choose Move or Copy to make a copy of a worksheet. But that is the very slow way to copy a worksheet. The fast way: Hold down the Ctrl key and drag the worksheet tab to the right.

Excel Fill Jan, Feb, ..., Dec, Total. Photo Credit: Curtis MacNewton at Unsplash.com

Excel 2020: Fill Jan, Feb, ..., Dec, Total »


January 22, 2020

While you can edit any custom list that you create, you cannot edit the first four lists in the Custom Lists dialog.