View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shanny
 
Posts: n/a
Default unknown - maybe grouping

I have a spreadsheet forwarded to me asking how they did something - I have
no clue. I will try my best to explain it.

on the side of this spread sheet there are the numbers going down. but on
the left of that there is another boarder with two boxes way on top one had
1 the other has 2 - undre that next to the numbers of the spreadsheet are
dots or bullets. then on the left of that is a black line that is grouping a
certain number of items with a - box under it so if you click on the - it
then hides the information in the spreadsheet and then there is an +

I was wondering what you call that and how it is done.

I tried to print screen and attach it but it wouldn't let me - I can email
it to anybody that would like to see what I am talking about.

One other question this person asked me is - Can you sort by last name if
the last name isn't first in the cell. I said no - but on this same
spreadsheet it is sorted by last name and the first name is first in the
cell. I told her they must of had it in order when they entered the info! Is
that a correct answer?

thanks