visible cells

Learn Excel – “Hide Blank Rows” – Podcast #1738

               

Preserve ‘Undo’, Show All and Hide Blanks: “Go!”

Learn Excel – “Hide Blank Rows with Event Handler” – Podcast #1737

               

How to work with unseen Event Handlers and Worksheet Change Events…

Learn Excel – “Count Visible Cells Matching Criteria”: Podcast #1731

               

There may not be a Formula, but there is always VBA!

Episode 762 – Chart Top Customers

               

A combination of six cool tricks allow you to take detailed transactional data and produce a chart of the top five customers in about 12 clicks. Episode 762 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(…)

Episode 546 – Adding Headings

               

Today’s problem involves a complex data set with headings throughout the data. We want to add new columns to the dataset, but it is incredibly tedious to copy the new column headings throughout the report. Episode 546 shows you how to use a combination of AutoFilter, and Visible Cells Only to solve the problem. This(…)

Learn Excel from MrExcel