ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding/Concealing columns (https://www.excelbanter.com/excel-discussion-misc-queries/137599-hiding-concealing-columns.html)

japc90

Hiding/Concealing columns
 
I am trying to modify a spreadsheet that I was sent. This spreadsheet
has a feature that allows you to hide and unhide columns and rows. You
use this option by clicking boxes labeled "1'' and "2" that are
located above the column numbers and in front of the row numbers. You
can also hide and conceal cells by clicking plus and/or minus signs
located in the same places. I want to expand this feature but do not
know how to use/create it. Any help would be appreciated.

Thanks!


Dave Peterson

Hiding/Concealing columns
 
Select a few columns
Then data|Group and outline|group




japc90 wrote:

I am trying to modify a spreadsheet that I was sent. This spreadsheet
has a feature that allows you to hide and unhide columns and rows. You
use this option by clicking boxes labeled "1'' and "2" that are
located above the column numbers and in front of the row numbers. You
can also hide and conceal cells by clicking plus and/or minus signs
located in the same places. I want to expand this feature but do not
know how to use/create it. Any help would be appreciated.

Thanks!


--

Dave Peterson

japc90

Hiding/Concealing columns
 
Perfect. Thanks for the help.


On Apr 2, 8:33 pm, Dave Peterson wrote:
Select a few columns
Then data|Group and outline|group

japc90 wrote:

I am trying to modify a spreadsheet that I was sent. This spreadsheet
has a feature that allows you to hide and unhide columns and rows. You
use this option by clicking boxes labeled "1'' and "2" that are
located above the column numbers and in front of the row numbers. You
can also hide and conceal cells by clicking plus and/or minus signs
located in the same places. I want to expand this feature but do not
know how to use/create it. Any help would be appreciated.


Thanks!


--

Dave Peterson





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

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