noob questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
Back
Top