![]() |
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! |
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 |
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