#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Number of columns

Is it possible to create more columns than 256?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Number of columns

Wait for xl2007 to be released?

Duplex wrote:

Is it possible to create more columns than 256?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I number columns based on adjacent cells? johnjesmer Excel Worksheet Functions 1 October 18th 06 02:36 AM
Macro - Using a variable number of columns in a Range stumped Excel Discussion (Misc queries) 2 October 3rd 06 08:13 PM
Number of Rows & Columns in a Named Range Michael Excel Dude Excel Discussion (Misc queries) 0 September 3rd 06 11:05 PM
Join three columns containing phone number and format as (000) 000 Sharon Barr Excel Discussion (Misc queries) 5 March 10th 06 10:37 PM
Change number of columns mid page? Bluemax Excel Worksheet Functions 4 November 24th 04 02:11 AM


All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"