cannot unhide left rows in excel 2011 mac

The slicers are filtering (hiding/unhiding) regular worksheet columns.Ĭlick here to view the animation in your browser.Īnother example is an inventory or time allocation sheet that has a lot of columns for projects, locations, regions, etc. The animated screencast below shows the macro in action. This report might be a forecast/budget input sheet, or any worksheet where you would NOT use a pivot table. One simple example is a report with a month/quarter/year column structure, where you want to hide/unhide all month columns for a specific quarter. This means our data does NOT need to be in a pivot table to use the functionality of a slicer or filter for columns. The Filter Columns macro allows us to use a slicer or pivot table filter to hide and unhide columns on a worksheet. So, I wrote this macro that combines the best of both worlds. We cannot use pivot tables for input sheets, and reports with customized or complex column structures.

However, pivot tables aren't a good solution for all applications and reports. Hiding and unhiding columns can help reduce horizontal scrolling, which can be time-consuming on large worksheets. This allows us to display only relevant columns for the current time period, project, category, etc. Pivot table slicers and filters are a great way to hide and unhide columns in a pivot table. Bottom line: Have you ever wanted to use a slicer or filter to hide/unhide columns on a regular worksheet range or table? Normally our data has to be in a pivot table to make use of the column filtering capabilities, but this simple macro allows us to hide and unhide worksheet columns with a slicer or pivot table filter.

Cannot unhide left rows in excel 2011 mac