Excel Tips: Automated row hiding in Excel reports

Hiding zero and blank rows in Excel reports is a common task. In this episode, discover how to automate the process by combining a few Excel features and functions.

0:00 Welcome
00:27 Dynamic arrays reports need extra blank rows for spilling.
01:23 Adding formatted table to report and hiding rows
02:15 Blue row numbers signify a filter is in place
03:48 Keyboard shortcut to clear a filter
04:37 The IsZero column formula and COUNTIF explained
06:33 Explanation of the display column; the override column
07:24 The formula that drives the filter in column A
09:27 Creating a Slicer (filter interface)
11:15 Changing a value to trigger the “Filter required” message
11:56 Using the SUBTOTAL’s superpower to capture if a row should be hidden
13:57 Count the filter errors using COUNTIF

Visit the INTHEBLACK website for more Excel content: https://intheblack.cpaaustralia.com.au/technical-skills

Want to learn more from Neale Blackwood? Visit A4 Accounting a4accounting.com.au

Видео Excel Tips: Automated row hiding in Excel reports канала CPA Australia