Episode 698 - Column Widths

Say that you need to copy column widths from one range to another range. The Paste Special dialog now offers the opportunity to paste column widths from one range to another range. Episode 698 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 544 - Rearranging all Columns

In yesterday’s podcast, I showed how to rearrange one column. But – what if you need to rearrange all of the columns? Episode 544 shows how to use a little known sorting trick to sort the columns back to the original sequence.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 345 - Shrink To Fit

How to make a value that is slightly too large for a column automatically fit. Episode 345 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!