Grey bar at left side of worksheet

A

Andrea

Can anyone tell me what the function of the grey bar at the side of a
worksheet is? i.e. it's name, function, how it is inserted, how can I edit.

The grey bar appears to the left of the numbers in grey boxes at the left
side of the worksheet. There are four small boxes at the top of this bar,
containing the numbers 1-4. It looks like another column, but is grey like
the number/alpha row and column. There is a dot, like a bullet point next to
each number cell.

This grey column/bar is appearing on reports I receive, but seems to change
the worksheet so that I cannot sort the data by highlighting columns,
clicking "data", "sort".

I cannot left or right click in this area.

Any clues would be really appreciated, thank you for your help.
 
L

Lars-Åke Aspelin

Can anyone tell me what the function of the grey bar at the side of a
worksheet is? i.e. it's name, function, how it is inserted, how can I edit.

The grey bar appears to the left of the numbers in grey boxes at the left
side of the worksheet. There are four small boxes at the top of this bar,
containing the numbers 1-4. It looks like another column, but is grey like
the number/alpha row and column. There is a dot, like a bullet point next to
each number cell.

This grey column/bar is appearing on reports I receive, but seems to change
the worksheet so that I cannot sort the data by highlighting columns,
clicking "data", "sort".

I cannot left or right click in this area.

Any clues would be really appreciated, thank you for your help.


Have a look here

http://office.microsoft.com/en-us/excel/HP052016411033.aspx

Hope this helps / Lars-Åke
 
A

Andrea

That's it! fantastic, i knew once i found out what it was called
("outline") i'd be able to work with it. Help is difficult to search without
knowing what the feature is called.

thank you for taking the time to reply, it is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top