noob questions

[Murat Vogt]

sorry, to bother u with a noob question, but for selfstudy purposes i have
come across a thing that i would like to figure out on how it works. how does
it work ? (i don t even know what it is called, so i best describe what i
mean....

if you have a few rows and you want to make them dissappear with a "plus
sign in front! so you can open and close this range of coloumns ...
how do you do that ... i mean how do you make this kind of view? (or at
least what is this feature called, so i can find out in the office help
feature... that would already be a superb help!
thankx y´all

 

[Dave Peterson]

You can do this Outlining in a couple of different ways.

This way only works with rows.
You usually have your data sorted by a certain column first.
Then you select your range (include a single header row)
and do Data|Subtotals

This way works with both rows and columns (but I find it much more of a manual
effort).

Select a few rows (or columns), then data|group and outline|Group

(I explained this using the old menu option with xl2003 and below.)

 

[Murat Vogt]

Hey,
thanks outline was the missing word! Thanks a million! And have a nice
weekend!