ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   auto hide unhide in grey rows above how did I manage this (https://www.excelbanter.com/excel-worksheet-functions/134488-auto-hide-unhide-grey-rows-above-how-did-i-manage.html)

rayrook

auto hide unhide in grey rows above how did I manage this
 
I have 2 grey lines above the grid which if you click on the minus auto hides
columns.
If you click on the plus it auto unhides them.

I did this accidentally how did I do it and how do I undo it

Vergel Adriano

auto hide unhide in grey rows above how did I manage this
 
1. Click on + to unhide the columns.
2. Select all the columns in the "group"
3. Data-Group and Outline-Ungroup
4. Select "Columns" in the dialog that pops up


"rayrook" wrote:

I have 2 grey lines above the grid which if you click on the minus auto hides
columns.
If you click on the plus it auto unhides them.

I did this accidentally how did I do it and how do I undo it



All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com