ExcelBanter - Hiding / Displaying columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding / Displaying columns (https://www.excelbanter.com/excel-discussion-misc-queries/45261-hiding-displaying-columns.html)

majesticaussies

Hiding / Displaying columns

Opened spreadsheet that has numbered tabs above row 1 that show / hide
columns. Also shows + and - signs showing the related columns. Just
wondering how to create this in a spreadsheet. Thanks...

Rowan

Select the columns (or rows) that you want to apply it to. Then
DataGroup and OutlineGroup.
UnGroup to undo the operation

Regards
Rowan

majesticaussies wrote:
Opened spreadsheet that has numbered tabs above row 1 that show / hide
columns. Also shows + and - signs showing the related columns. Just
wondering how to create this in a spreadsheet. Thanks...

All times are GMT +1. The time now is 02:38 PM.