numbers to left of column A

[houndhen]

I am using MS Office 2002 with XP OS and have an Excel workbook with
worksheets in it. Two of these worksheets have the numbers 1 and 2 t
the left of the A column. What does this mean and how do I use them o
get rid of them?

Thanks

 

[Paul]

You have some grouped rows. If you Expand the groupings
(Data, Group and Outline, Show Detail) you will see that
rows have been grouped together and you can hide whole
groups of rows with one click. To get rid of that,
select the rows in a given group and select Data, Group
and Outline, Ungroup.

Good luck.

 

[Nick Hodge]

You have subtotals set.

Go to Data>Subtotals... and in the resultant dialog click 'Remove All'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Nick Hodge]

Could also be a manual group or outline...go to Data>Group and Outline>Clear
Outline

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

You are most likely in Data>Group and Outline mode.

To get rid of them go to Data>Group and Outline and select "Ungroup".

How do you use them? Always been a mystery to me.

Gord Dibben XL2002