MrExcel Excel Videos

Andrew and David have similar Excel issues - they need a Summary worksheet to return values from all other worksheets and want a simple way to enter one formula that can be copied to point to the other worksheets. Today, in episode 1822, how to use INDIRECT to solve the problem when the Total row is on the same row in every worksheet.

The Excel 2010 & 2013 macro recorder will not record how to stack and scale a picture fill in a chart. This episode shows two different sets of code to control the stack and scale settings.

You copied some Excel VBA code from the Internet, but when you try to run it, you get a compile error with Sub or Function Not Defined. This video shows you what might be causing that error and how to find the line to fix.

Juan is charting three series. The first two series have a similar order of magnitude, the third series is very small. Episode 1819 shows how to build this chart in either Excel 2010 or Excel 2013.

Use View, New Window to allow comparing two worksheets of the same workbook side by side.

Jim from Timken shares a trick to prevent typing extra zeroes, even if you are entering 0.000012. This trick works for entering numbers in thousands, millions, thousandths, millionths or any order of magnitude.

Can you keep the data validation drop-down arrows visible? This video offers three alternatives.

It is Hit or Miss today at the MrExcel podcast, literally. The question is how to label a value as a hit if it falls within plus or minus 1 of a target. Bill shows four different formulas to solve the problem. To buy the Formula Tip Card mentioned in the episode, visit Formula Tips from MrExcel (Laminated Card)

At my Fort Myers Florida Power Excel seminar, someone showed me a new way to Paste Values. Does this video show all possible ways?