how do I increase the number of columns in a report?

G

Guest

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ran out of columns in excel worksheet. How do I increase them? 3
how do i make more columns visible in a spreadsheet? 1
counting blank cells within two columns 2
increase the number of columns from 256 to 365 6
how do I limit the number of rows when exporting data into excel? 3
Count of Different Columns 5
Split report for email 5
count number of instances of same data 1

Top