MrExcel Excel Videos

After youve used an AutoFilter to see just a few records, how can you quickly show all records? Episode 597 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!

Rod notes that Excel has a cool feature that will cause Excel to automatically copy formulas when you add new rows of data. In Episode 596, we take a look at how this feature works, and how to turn it off. 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!

Today, Dr Fill Handle provides a faster way to use the Fill Handle. Episode 595 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!

Youve created a simple macro and want to assign the macro to a button on a worksheet. In todays question, someone is trying to assign a macro to a button, but it is not working. She can assign the macro to a text box and it works, but not with a button. Episode 594 shows how to assign a macro to a text box, an AutoShape, or a button on the Forms toolbar. 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!

Today, the questioner asks how to unprotect the green cells. There isnt any good way to do this in the Excel user interface, so in Episode 593, I use a tiny bit of VBA code to achieve the effect. The code used in the podcast is: Sub UnProtectGreen For each Cell in Selection If Cell.Interior.ColorIndex = 4 then Cell.Locked = False Else Cell.Locked = True End If Next Cell End Sub 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!

Todays question is a follow-up to yesterdays question. How can you make sure that a pivot table shows you one row per day, even if there were no sales on a given day? Episode 592 shows two annoying solutions. If you have a better solution, please send in your ideas to bill @ MrExcel.com. 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!

When you create a chart from data that might have missing dates, you might want Excel to plot the missing dates along the horizontal axis. In Episode 591, we take a look at why Excel sometimes chooses to use a time scale and sometimes does not. 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!

Say that you need to show a rolling 6 month chart. Usually, I show how to drag the blue outline around the source data. However, in todays podcast, Kirk offers an alternative tip include all of the columns in your chart and hide/unhide the columns that you want to appear in your chart. Episode 590 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!

A second solution to Don's problem from podcast 991: add a textbox inside the cell. With a bit of formatting, the words inside the textbox will appear to float next to the number, but will not cause any subsequent formulas to incorporate the text. Episode 992 shows you how. This video is the 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!