ExcelBanter - Number of columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number of columns (https://www.excelbanter.com/excel-discussion-misc-queries/115330-number-columns.html)

Duplex

Number of columns

Is it possible to create more columns than 256?

Dave Peterson

Number of columns

Wait for xl2007 to be released?

Duplex wrote:

Is it possible to create more columns than 256?

--

Dave Peterson

Jon von der Heyden

Number of columns

In the current version of Excel that is the maximum. But you can extend onto
a new worksheet. Otherwise consider storing the data in MS Access.
--
Two heads are better than one!

Email: subst1tut3 numb3rs for l3tt3rs...

"Duplex" wrote:

Is it possible to create more columns than 256?

Dave Peterson

Number of columns

I thought Access had about 255 columns/fields, too.

Jon von der Heyden wrote:

In the current version of Excel that is the maximum. But you can extend onto
a new worksheet. Otherwise consider storing the data in MS Access.
--
Two heads are better than one!

Email: subst1tut3 numb3rs for l3tt3rs...

"Duplex" wrote:

Is it possible to create more columns than 256?

--

Dave Peterson

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