Originally published at: http://www.howtogeek.com/166652/how-to-hide-and-unhide-rows-and-columns-in-excel-2013/
There may be times you want to remove a row or column from a spreadsheet, but you don’t want to permanently delete it from the worksheet file. Excel has a feature that allows you to temporarily hide a row or column from view.
I prefer using Data/Group over the hide feature. Hidden rows and columns become hard to see when you are reviewing your worksheet. Using the Data/Group, you can easily see what is hidden from the +/- buttons. You can easily collapse/expand the hidden rows or columns. Further, you can define levels of grouping which effectively gives you a drill-down approach.
Taking this a step further I have been working with using an activeX checkBox control. If it's check it hides a range of rows below it. Unchecked and the rows are visible. The range that is hidden also has checkboxes. The problem I have run into is if it's saved with the rows hidden when you reopen the sheet and unhide the hidden rows the controls that were hidden disappear and I can't get them to come back. Does anyone have a solution for this?