Learn Excel from Bill Jelen with this daily 2 minute video podcast.
You can hide 20 worksheets in a single command, but it is very tedious to unhide all worksheets. Episode 788 shows how to use a custom view to unhide all worksheets.
posted by Bill at 9:00 AM
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 today’s 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.
posted by Bill at 9:00 AM
Today, Scott W sends in a better way to hide and unhide columns. After watching podcast 449, Scott sent in a suggestion that is much better than the typical Format Column Hide and Format Column Unhide methods. Episode 482 shows you how.
posted by Bill at 9:00 AM
As a follow-up to yesterday’s netcast, Episode 450 shows you how to unhide column A and a cool trick left over from Lotus 1-2-3 where you can see what is in the hidden columns without unhiding them.
Labels: Unhide
posted by Bill at 9:00 AM
Stuart from the UK asks: say that you have columns B through H hidden and want to unhide only one of those columns? Episode 449 will take a look at the process of hiding and unhiding columns. Although I had never tried it before Stuart posed the question, it seems that there is a way to unhide just that one column.
Labels: Unhide
posted by Bill at 9:00 AM
