Export from Access
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
|