| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a display
I do not even know what this is called, but I shall try anyway: I received an
excel table on which on the left side of the screen one can collaps or hide certain collums by clicking on the - or + buttons. What is this called, and how can I remove it? -- Many thanks, and have a good day Ursula A. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change a display
Its called Group amd Outlining
To Remove - Choose Data Group and OUtline Clear Outline Eddie "Ursula A." wrote: I do not even know what this is called, but I shall try anyway: I received an excel table on which on the left side of the screen one can collaps or hide certain collums by clicking on the - or + buttons. What is this called, and how can I remove it? -- Many thanks, and have a good day Ursula A. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change a display
The view you are seeing is called OUTLINE VIEW. Depending upon how its been
set up you can remove it by clicking DATA, SUBTOTALS and then click the REMOVE ALL command button. Or click DATA and select GROUP AND OUTLINE and then select CLEAR OUTLINE -- Kevin Backmann "Ursula A." wrote: I do not even know what this is called, but I shall try anyway: I received an excel table on which on the left side of the screen one can collaps or hide certain collums by clicking on the - or + buttons. What is this called, and how can I remove it? -- Many thanks, and have a good day Ursula A. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change a display
Sounds like the Outline or Grouping feature.
Select all of your cells by clicking the gray square above row 1 and to the lift of A. Then click on Data, Group and Outline, and select Ungroup. HTH, Paul "Ursula A." wrote in message ... I do not even know what this is called, but I shall try anyway: I received an excel table on which on the left side of the screen one can collaps or hide certain collums by clicking on the - or + buttons. What is this called, and how can I remove it? -- Many thanks, and have a good day Ursula A. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change a display
- yes that is it :-) thanks to all.
-- Many thanks, and have a good day Ursula A. "Kevin B" wrote: The view you are seeing is called OUTLINE VIEW. Depending upon how its been set up you can remove it by clicking DATA, SUBTOTALS and then click the REMOVE ALL command button. Or click DATA and select GROUP AND OUTLINE and then select CLEAR OUTLINE -- Kevin Backmann "Ursula A." wrote: I do not even know what this is called, but I shall try anyway: I received an excel table on which on the left side of the screen one can collaps or hide certain collums by clicking on the - or + buttons. What is this called, and how can I remove it? -- Many thanks, and have a good day Ursula A. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display the result of one cell each time a change anothe. | Excel Worksheet Functions | |||
| Excel - Change cell display limitations | Excel Worksheet Functions | |||
| Change value in cell | Excel Discussion (Misc queries) | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| Cell Change Color - Need Help | New Users to Excel | |||
Linear Mode
