|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 10th, 2007, 09:02 PM
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
September 10th, 2007, 09:09 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
