ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add more columns above the 256 limit in excel? (https://www.excelbanter.com/excel-worksheet-functions/8209-how-do-i-add-more-columns-above-256-limit-excel.html)

Kathy

How do I add more columns above the 256 limit in excel?
 
I need approx 400 columns on one spreadsheet. Is there anyway to override
the 256 column limit in excel?

Peo Sjoblom

No, it's not.


Regards,

Peo Sjoblom

"Kathy" wrote:

I need approx 400 columns on one spreadsheet. Is there anyway to override
the 256 column limit in excel?


Ken Wright

Nope - Either use more sheets or consider transposing your data if that is
possible.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Kathy" wrote in message
...
I need approx 400 columns on one spreadsheet. Is there anyway to override
the 256 column limit in excel?




Dave R.

No there is not.


"Kathy" wrote in message
...
I need approx 400 columns on one spreadsheet. Is there anyway to override
the 256 column limit in excel?





All times are GMT +1. The time now is 10:47 PM.

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