Hiding Columns and Rows in Excel - advanced aspects

%3CLINGO-SUB%20id%3D%22lingo-sub-1324207%22%20slang%3D%22en-US%22%3EHiding%20Columns%20and%20Rows%20in%20Excel%20-%20advanced%20aspects%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1324207%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20Hiding%20Columns%20and%20Rows%20in%20Excel%20I've%26nbsp%3Bseen%20some%20people%20leave%20a%20breadcrumb%20trail%20which%20allows%20a%20quick%20hide%2Funhide%20solution%20to%20retrieving%20unhiding%20such%20colours.%20Essentially%20a%20greyed%20out%20area%20along%20the%20top%20of%20the%20columns%20and%20LHS%20of%20the%20rows%20highlighting%20which%20columns%20%2F%20rows%20can%20be%20hidden%20%2F%20unhidden%20by%20clicking%20on%20either%20a%201%20or%202%20box%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1324207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1324462%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20Columns%20and%20Rows%20in%20Excel%20-%20advanced%20aspects%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1324462%22%20slang%3D%22en-US%22%3EIt%20is%20what%20you%20get%20when%20you%20click%20the%20Group%20button%20on%20the%20Data%20tab%20of%20the%20ribbon%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

When Hiding Columns and Rows in Excel I've seen some people leave a breadcrumb trail which allows a quick hide/unhide solution to retrieving unhiding such colours. Essentially a greyed out area along the top of the columns and LHS of the rows highlighting which columns / rows can be hidden / unhidden by clicking on either a 1 or 2 box

1 Reply
Highlighted
It is what you get when you click the Group button on the Data tab of the ribbon