Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
aw.far
 
Posts: n/a
Default can I increase excel column numbers to more than 256?

I am trying to analyse tables including more than 256 variables. I cannot
transpose them into rows because the program i am using in association with
excel (xlstat) takes the columns as the variables. Is there a way to increase
the number of the columns?? or is it a fixed specification of the excel
worksheet? thank for any help!

  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default can I increase excel column numbers to more than 256?

Yes, it is fixed - you cannot increase the number of columns. You can,
of course, split your data up into chunks of 250 columns - the first
block of data on row 1, for example, then the next set starting on
another row etc.

Pete

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
sum absolute values of a column of numbers in Excel MRolko Excel Worksheet Functions 1 December 30th 05 03:41 PM
Check COlumn - Excel VBA magix Excel Discussion (Misc queries) 11 November 5th 05 02:32 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel: Which numbers in a column equal a certain number (withou. Pax Excel Worksheet Functions 1 March 6th 05 03:42 AM


All times are GMT +1. The time now is 10:13 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"