Export from Access

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

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)
 
Thank you sir!


Dave Peterson said:
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)
Click to expand...
 
Back
Top