ExcelBanter - hiding columns or rows not using the hide function

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - hiding columns or rows not using the hide function (https://www.excelbanter.com/excel-worksheet-functions/89715-hiding-columns-rows-not-using-hide-function.html)

Rayasiom

hiding columns or rows not using the hide function

I have come across spreadsheets that have a 1 or 2 in a box in the top left
corner of the sheet, and a plus or minus in a box above columns and rows that
allow you to hide or display a selection of rows/columns. How do you do this?

Rayasiom

hiding columns or rows not using the hide function

Don't worry. Found it by selecting required columns or rows and going to Data
- Group and Outline

"Rayasiom" wrote:

I have come across spreadsheets that have a 1 or 2 in a box in the top left
corner of the sheet, and a plus or minus in a box above columns and rows that
allow you to hide or display a selection of rows/columns. How do you do this?

All times are GMT +1. The time now is 01:14 AM.