howtogeek at July 8th, 2013 02:03 — #1
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.
timemerick at July 8th, 2013 11:55 — #2
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.
james_danielson at July 9th, 2013 19:17 — #3
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?