ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add additional columns beyond column "IV"? (https://www.excelbanter.com/excel-worksheet-functions/209952-how-do-i-add-additional-columns-beyond-column-iv.html)

Adding Columns

How do I add additional columns beyond column "IV"?
 
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?

Dave Peterson

How do I add additional columns beyond column "IV"?
 
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.

Adding Columns wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com