MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Excel Undo an AutoSave. Photo Credit: Miguel A. Amutio at Unsplash.com

Excel 2019: Undo an AutoSave »


March 11, 2019

What if you have to undo an AutoSave? Your manager said to merge two regions and then 20 minutes later calls the merger off. AutoSave has been saving after every change in your workbook.

AutoSave is Necessary, But Turn it Off When Not Co-Authoring. Photo Credit: Frank Okay at Unsplash.com

Excel 2019: AutoSave is Necessary, But Turn it Off When Not Co-Authoring »


March 8, 2019

The reason that co-authoring is possible is because of AutoSave. Every time that you make a spreadsheet change, that change will be saved to OneDrive so that others can (almost) instantly see what you just typed. AutoSave is necessary if you want ten accountants editing a budget worksheet at the same time.

Excel Simultaneously Edit the Same Workbook in Office 365. Photo Credit: Perry Grone at Unsplash.com

Excel 2019: Simultaneously Edit the Same Workbook in Office 365 »


March 7, 2019

After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017.

Excel Recover Unsaved Workbooks. Photo Credit: Gary Chan at Unsplash.com

Excel 2019: Recover Unsaved Workbooks »


March 6, 2019

The Auto Recover feature is a lifesaver. It is turned on automatically in Excel 2010 and newer.

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

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


March 5, 2019

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 2019: Changes to Book Template are Cumulative »


March 4, 2019

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 2019: Use Default Settings for All Future Workbooks »


March 1, 2019

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 2019: Use INDIRECT for a Different Summary Report »


February 28, 2019

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 2019: Create a SUM That Spears Through All Worksheets »


February 27, 2019

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 2019: Change All Sheets with Group Mode »


February 26, 2019

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 2019: Power Up the Status Bar Statistics »


February 25, 2019

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 2019: Add a Total Row and a Total Column with One AutoSum »


February 22, 2019

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