Excel Tips

Keep the Copy »

July 20, 2017

New feature in Excel: Say that you copy some data. You then Insert Rows. The data on the clipboard is deleted. It is frustrating. But there is now a fix in Excel.

Sideways with Formula »

July 19, 2017

Paste Special Transpose does a snapshot of the data

Compare Sheets Side by Side »

July 18, 2017

Paste Special Transpose does a snapshot of the data

Missing QAT Icons »

July 18, 2017

Kuldeep wants to select every third cell for 1500 cells

Subscript & Superscript »

July 18, 2017

Superscript and subscripts in Excel! Finally, in 2017, Microsoft gave us faster ways to create superscripts and Subscripts in Excel.

Sum All Sheets »

July 17, 2017

You need to total numbers on Jan Feb Mar ... Dec

15? 17? Digits of Precision »

July 17, 2017

Learn about a serious bug in Excel's Calculation Engine. Excel is supposed to use 15 digits of precision. Microsoft is storing 17 digits in the XML, and now a few functions are using all 17 digits, causing calculation anomolies.

Change All Sheets »

July 14, 2017

Learned how to make copies of sheets quickly in podcast 1981.

Worksheet Name in Cell »

July 13, 2017

Use a formula in Excel to put the worksheet name in a cell. Also in this episode: =CELL("filename",A1) returns the path and file name