Avoid a Loop - 1140 - Learn Excel from MrExcel Podcast

A cool way to streamline a VBA loop using SpecialCells. Episode 1140 shows 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!

Clearing Input Cells - 1052 - Learn Excel from MrExcel Podcast

Jerry has a model with input cells and formula cells. He wants to copy the model for next month and clear out all the input cells. Episode 1052 will show you how to clear out the numeric input cells.

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 847 - Filling Blanks

Seiichi from Japan asks how to fill in blank cells in column A with the value above the blank. Episode 847 shows 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 725 - Row Differences

While I've talked about Go To Special many times, I usually use Blanks, Visible Cells Only, or Formulas. Someone asked how to use the Row Differences option. This is a good way to compare if anything changed from one column to another, but it is limited. Episode 725 explores this option.

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 511 - Filling Blanks

While yesterday’s podcast talked about using the Fill Handle, there are times when there are methods faster than using the fill handle repeatedly. Episode 511 shows how to fill in a whole column of blank cells in one process.

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!