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