Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We are creating an excel spreadsheet from an Access report using the
"Send..." option. We are getting an extra 4 (grouping???) columns to the left of the spreadsheet, looks something like this: 1 2 3 4 Column1 Column2 Column3, etc... - | | | - Any ideas what Excel is doing with the data? We are missing the first three columns of output from the Access report and assuming it is somehow grouping the data (?) in those mysterious 4 columns to the left of the spreadsheet. The vertical bracket encompasses all the rows of data in the report. Any ideas? Kind Regards, Leslie |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can get those outlining symbols in a couple of ways:
Data|subtotals or Data|Group and Outline You can hide the outlining symbols by: tools|Options|View Tab|Uncheck Outline Symbols Or you can remove the subtotals or the grouping. Leslie wrote: We are creating an excel spreadsheet from an Access report using the "Send..." option. We are getting an extra 4 (grouping???) columns to the left of the spreadsheet, looks something like this: 1 2 3 4 Column1 Column2 Column3, etc... - | | | - Any ideas what Excel is doing with the data? We are missing the first three columns of output from the Access report and assuming it is somehow grouping the data (?) in those mysterious 4 columns to the left of the spreadsheet. The vertical bracket encompasses all the rows of data in the report. Any ideas? Kind Regards, Leslie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
what are the 1-8 grey columns left of the spreadsheet? | Excel Discussion (Misc queries) | |||
looking for an one invoice on an extra large spreadsheet | Excel Discussion (Misc queries) | |||
extra rows and columns | New Users to Excel | |||
eliminating extra rows in spreadsheet | Excel Discussion (Misc queries) | |||
Extra Columns | Excel Discussion (Misc queries) |