When I export a report from Access, the Excel files has two (extra) columns
(in line with the Column identifiers A, B, C, etc.), marked with a "1" and
"2", on the far left of the worksheet. Clicking on the "1" collapses the
data so I can't see it anymore, and clicking on the "2", restores it so that
it is visible.

1. How do I remove this feature from my Excel file?
2. What is the purpose of this feature?
3. How would I lookup this feature in Excel "Help"?1

Thanks,
Bernie

You can create these outlining symbols in a couple of ways.

(xl2003 menu system)
Data|Subtotal
and
Data|group and outline|Group

I think I'd look to see how they were created and then remove it (either the
subtotals or the grouping).

But you can also just hide those outlining symbols by:
Tools|Options|View Tab|Uncheck Outline symbols
(still xl2003 menu system)

bw wrote:

When I export a report from Access, the Excel files has two (extra) columns
(in line with the Column identifiers A, B, C, etc.), marked with a "1" and
"2", on the far left of the worksheet. Clicking on the "1" collapses the
data so I can't see it anymore, and clicking on the "2", restores it so that
it is visible.

1. How do I remove this feature from my Excel file?
2. What is the purpose of this feature?
3. How would I lookup this feature in Excel "Help"?1

Thanks,
Bernie



--

Dave Peterson

Thank you sir!


"Dave Peterson" wrote in message
...
You can create these outlining symbols in a couple of ways.

(xl2003 menu system)
Data|Subtotal
and
Data|group and outline|Group

I think I'd look to see how they were created and then remove it (either
the
subtotals or the grouping).

But you can also just hide those outlining symbols by:
Tools|Options|View Tab|Uncheck Outline symbols
(still xl2003 menu system)

bw wrote:

When I export a report from Access, the Excel files has two (extra)
columns
(in line with the Column identifiers A, B, C, etc.), marked with a "1"
and
"2", on the far left of the worksheet. Clicking on the "1" collapses the
data so I can't see it anymore, and clicking on the "2", restores it so
that
it is visible.

1. How do I remove this feature from my Excel file?
2. What is the purpose of this feature?
3. How would I lookup this feature in Excel "Help"?1

Thanks,
Bernie



--

Dave Peterson