ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do display a "+" or "-" sign when hiding columns? (https://www.excelbanter.com/setting-up-configuration-excel/98963-how-do-display-sign-when-hiding-columns.html)

DTI Tustin

How do display a "+" or "-" sign when hiding columns?
 
How do display a "+" or "-" sign when hiding columns that allows someone to
click on the + or - as a shortcut to hide or unhide cells?

I want to hide my column and have them click the - sign to unhide.

Franz Verga

How do display a "+" or "-" sign when hiding columns?
 
DTI Tustin wrote:
How do display a "+" or "-" sign when hiding columns that allows
someone to click on the + or - as a shortcut to hide or unhide cells?

I want to hide my column and have them click the - sign to unhide.



Select the columns you want to hide, then menu Data, Group and structures,
Group


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




All times are GMT +1. The time now is 11:52 PM.

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