How do I add additional columns beyond column "IV"?

A

Adding Columns

I'm exporting data from QuickBooks which goes beyond Column "IV" in Excel
verison 2007. Is there a way to set-up Excel to increase the columns?
 
D

Dave Peterson

You'll only see columns A:IV if you open the workbook in compatibility mode.

Save the workbook as a normal workbook (*.xlsx or *.xlsm) and then close the
workbook and reopen it. Then you'll see all 16k columns.
 

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

EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID 4
Add additional information to excel form after original data entry 0
Two columns followed by single page-width column on same page 0
Changing defauls in 2019 0
this is killing me. INDEX/MATCH "closest to X" in a smart way? 6
Need to expand Excel 2007 spreadsheet beyond column IV 2
Problem with SET & REF function 0
Copy addition formula of non-consecutive horizontal cells 2

Top