numbers to left of column A

H

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
 
P

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.
 
N

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
[email protected]
 
G

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
 
Top