ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Grey bar at left side of worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/195749-grey-bar-left-side-worksheet.html)

Andrea

Grey bar at left side of worksheet
 
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.

Lars-Åke Aspelin[_2_]

Grey bar at left side of worksheet
 
On Tue, 22 Jul 2008 01:10:00 -0700, Andrea
wrote:

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/ex...016411033.aspx

Hope this helps / Lars-Åke

Andrea

Grey bar at left side of worksheet
 
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.

"Lars-Ã…ke Aspelin" wrote:

On Tue, 22 Jul 2008 01:10:00 -0700, Andrea
wrote:

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/ex...016411033.aspx

Hope this helps / Lars-Ã…ke



All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com