MrExcel

Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle. Episode 1152 shows you how.

Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle. Episode 1152 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two video every workday to learn ...

How can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of methods.

How can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of methods. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two video every workday to ...

In Episode 1150, I wanted to add data bars to a series of words.

Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide dueling ways to solve this problem.

Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide dueling ways to solve this problem in Episode 1149. This blog is the video podcast companion to the book, Learn Excel ...

In this Excel tutorial learn how to split a word and then count the characters.

Ram asks how to split a word into individual letters, and then count how many times each letter appears. Episode 1148 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two video every ...

Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. Episode 1147 discusses this problem.

Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. Episode 1147 discusses this problem. This blog is the video podcast companion to the book, Learn Excel 97-2007 ...

Mark asks how to fill blanks in with the data from above. Now...if you've watched this podcast, you've seen the trick for this, but Mark's data has something preventing Go To Special Blanks from working! So - another way to go. Episode 1146 shows you how.

Diane from Michigan wants to split a column of names into two columns. Episode 1145 shows two approaches and the problems with each.

Diane from Michigan wants to split a column of names into two columns. Episode 1145 shows two approaches and the problems with each. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two video every ...

Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in today's Episode 1144.

Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in today's Episode 1144. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download ...

Michael from Kansas City asks how to build a floating quartile chart. Episode 1143 shows you how.

Michael from Kansas City asks how to build a floating quartile chart. Episode 1143 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two video every workday to learn one of the 377 tips ...

A cool way to streamline a VBA loop using SpecialCells. Episode 1140 shows you how.