| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I increase the number of columns in a report?
trying to export a Quickbooks report to excel... message appears saying that
"Excel allows columns in a worksheet. This report has columns (4 row tiltle columns + 489 data columns). Use "Customize" to change the number of columns in this report". I don't see how to do this. Any help appreciated. jes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I increase the number of columns in a report?
You would change the number of columns in your report through Quickbooks, before
you bring it into Excel. Or upgrade to Excel 2007 which allows 16384 columns. Earlier versions are limited to 256 columns. Gord Dibben MS Excel MVP On Mon, 10 Sep 2007 13:02:02 -0700, jes wrote: trying to export a Quickbooks report to excel... message appears saying that "Excel allows columns in a worksheet. This report has columns (4 row tiltle columns + 489 data columns). Use "Customize" to change the number of columns in this report". I don't see how to do this. Any help appreciated. jes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to increase the number of columns in spredsheet | New Users to Excel | |||
| How do I increase the number of columns in excel above 256 | Excel Discussion (Misc queries) | |||
| increase the number of columns from 256 to 365 | Excel Discussion (Misc queries) | |||
| How to increase number of columns appear in a worksheet? | Excel Discussion (Misc queries) | |||
| Increase the limit to number of columns? | Excel Discussion (Misc queries) | |||
Linear Mode
