MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Discover New Functions by Using fx. Photo Credit: David Blume at Unsplash.com

Excel 2019: Discover New Functions by Using fx »


July 18, 2019

There are 400+ functions in Excel. Instead of taking 450 pages to describe every function, I am going to teach you how to find the function that you need.

Audit a Worksheet With Spreadsheet Inquire. Photo Credit: Michael Rodock at Unsplash.com

Excel 2019: Audit a Worksheet With Spreadsheet Inquire »


July 17, 2019

Inquire was developed by a company called Prodiance that offered the slick Spreadsheet Compare tool for $145 per person per year. The Excel team liked it so much that Microsoft bought out Prodiance and gave the tool for free to anyone who is on Pro Plus, Professional Plus, or Enterprise Level E3.

Excel See Which Cells Depend on the Current Cell. Photo Credit: Edgar Castrejon at Unsplash.com

Excel 2019: See Which Cells Depend on the Current Cell »


July 15, 2019

I previously explained how to Trace Precedents to See What Cells Flow into a Formula. Sometimes you have the opposite problem: You want to see which cells rely on the value in the current cell.

Excel Trace Precedents to See What Cells Flow into a Formula. Photo Credit: Johannes Ludwig at Unsplash.com

Excel 2019: Trace Precedents to See What Cells Flow into a Formula »


July 11, 2019

If you need to see which cells flow into a formula, you can use the Trace Precedents command in the Formula Auditing group on the Formulas tab.

Excel Highlight All Formula Cells. Photo Credit: José Alejandro Cuffia at Unsplash.com

Excel 2019: Highlight All Formula Cells »


July 10, 2019

If you are going to be auditing the worksheet, it would help to mark all of the formula cells.

Excel See All Formulas at Once. Photo Credit: Roberto Nickson at Unsplash.com

Excel 2019: See All Formulas at Once »


July 8, 2019

You inherit a spreadsheet from a former co-worker and you need to figure out how the calculations work. You could visit each cell, one at a time, and look at the formula in the formula bar. Or you could quickly toggle between pressing F2 and Esc to see the formula right in the cell.

Excel Skip Blanks While Pasting. Photo Credit: Hope House Press - Leather Diary Studio at Unsplash.com

Excel 2019: Skip Blanks While Pasting »


July 4, 2019

A mysterious part of the Paste Special dialog is the Skip Blanks feature. What does it do? Say that you have a list of existing values. In another column, you have updates for some of those values but not all of them.

Excel Quickly Convert Formulas to Values. Photo Credit: Jp Valery at Unsplash.com

Excel 2019: Quickly Convert Formulas to Values »


July 3, 2019

I always say there are five ways to do anything in Excel. Converting live formulas to values is a task that has far more than five ways. But I will bet that I can teach you two ways that are faster than what you are using now.

Excel Use a Named Range Instead of Absolute References. Photo Credit: Katherine Fleitas at Unsplash.com

Excel 2019: Use a Named Range Instead of Absolute References »


July 1, 2019

If you want to avoid using $ in references to make them absolute, you can use named ranges instead.

Excel Use F4 for Absolute Reference or Repeating Commands. Photo Credit: Ambitious Creative Co. - Rick Barrett at Unsplash.com

Excel 2019: Use F4 for Absolute Reference or Repeating Commands »


June 27, 2019

The mighty F4 key should be in your Excel arsenal for two completely different reasons.

Excel Slicers for Pivot Tables From Two Data Sets. Photo Credit: Katie Smith at Unsplash.com

Excel 2019: Slicers for Pivot Tables From Two Data Sets »


June 26, 2019

Say that you have two different data sets. You want a pivot table from each data set and you want those two pivot tables to react to one slicer.

Excel Text in the Values of a Pivot Table. Photo Credit: rawpixel at Unsplash.com

Excel 2019: Text in the Values of a Pivot Table »


June 24, 2019

Another amazing use for a measure in a Data Model pivot table is to use the CONCATENATEX function to move text into the values area of a pivot table.