PC Review


Reply
Thread Tools Rate Thread

256 column limit

 
 
=?Utf-8?B?ZWxsZWJlbGxl?=
Guest
Posts: n/a
 
      5th Jan 2006
hi,

I have read all the posts on the 256 column limit. irritating.

i only want about 500 columns and about 200 rows - could i transpose the
data, but view it reverse transposed - if you know what i mean. i don't want
to read the data down, but across.

i am assuming the limit is to control the overall number of cells? this
would not affect that.

ellebelle
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      5th Jan 2006
Next version of Excel has 16384 columns and 1048576 rows but until it's
released you can't do anything about it except using another layout



--

Regards,

Peo Sjoblom


"ellebelle" <(E-Mail Removed)> wrote in message
news:00BE7A1C-D8E6-483A-8E4D-(E-Mail Removed)...
> hi,
>
> I have read all the posts on the 256 column limit. irritating.
>
> i only want about 500 columns and about 200 rows - could i transpose the
> data, but view it reverse transposed - if you know what i mean. i don't

want
> to read the data down, but across.
>
> i am assuming the limit is to control the overall number of cells? this
> would not affect that.
>
> ellebelle



 
Reply With Quote
 
=?Utf-8?B?ZWxsZWJlbGxl?=
Guest
Posts: n/a
 
      5th Jan 2006
great news! when is thatbeing released?

"Peo Sjoblom" wrote:

> Next version of Excel has 16384 columns and 1048576 rows but until it's
> released you can't do anything about it except using another layout
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "ellebelle" <(E-Mail Removed)> wrote in message
> news:00BE7A1C-D8E6-483A-8E4D-(E-Mail Removed)...
> > hi,
> >
> > I have read all the posts on the 256 column limit. irritating.
> >
> > i only want about 500 columns and about 200 rows - could i transpose the
> > data, but view it reverse transposed - if you know what i mean. i don't

> want
> > to read the data down, but across.
> >
> > i am assuming the limit is to control the overall number of cells? this
> > would not affect that.
> >
> > ellebelle

>
>
>

 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      5th Jan 2006
Presumably late summer early fall this year

here's a link to a blog written by one of the MS Excel developers

http://blogs.msdn.com/excel/default.aspx


--

Regards,

Peo Sjoblom


"ellebelle" <(E-Mail Removed)> wrote in message
news:9D100DDC-4274-4470-9D29-(E-Mail Removed)...
> great news! when is thatbeing released?
>
> "Peo Sjoblom" wrote:
>
> > Next version of Excel has 16384 columns and 1048576 rows but until it's
> > released you can't do anything about it except using another layout
> >
> >
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "ellebelle" <(E-Mail Removed)> wrote in message
> > news:00BE7A1C-D8E6-483A-8E4D-(E-Mail Removed)...
> > > hi,
> > >
> > > I have read all the posts on the 256 column limit. irritating.
> > >
> > > i only want about 500 columns and about 200 rows - could i transpose

the
> > > data, but view it reverse transposed - if you know what i mean. i

don't
> > want
> > > to read the data down, but across.
> > >
> > > i am assuming the limit is to control the overall number of cells?

this
> > > would not affect that.
> > >
> > > ellebelle

> >
> >
> >



 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      5th Jan 2006
Meanwhile there is Quattro Pro
(I jest!)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ellebelle" <(E-Mail Removed)> wrote in message
news:9D100DDC-4274-4470-9D29-(E-Mail Removed)...
> great news! when is thatbeing released?
>
> "Peo Sjoblom" wrote:
>
>> Next version of Excel has 16384 columns and 1048576 rows but until it's
>> released you can't do anything about it except using another layout
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>> "ellebelle" <(E-Mail Removed)> wrote in message
>> news:00BE7A1C-D8E6-483A-8E4D-(E-Mail Removed)...
>> > hi,
>> >
>> > I have read all the posts on the 256 column limit. irritating.
>> >
>> > i only want about 500 columns and about 200 rows - could i transpose
>> > the
>> > data, but view it reverse transposed - if you know what i mean. i don't

>> want
>> > to read the data down, but across.
>> >
>> > i am assuming the limit is to control the overall number of cells? this
>> > would not affect that.
>> >
>> > ellebelle

>>
>>
>>



 
Reply With Quote
 
Harald Staff
Guest
Posts: n/a
 
      5th Jan 2006
I believe the numbers are absolute also because the cells and memory are
adressed by digits in fixed positions so to speak. A floating system (less
rows, more columns, fixed max #) would be nice but that's not the way it's
built.

HTH. Best wishes Harald

"ellebelle" <(E-Mail Removed)> skrev i melding
news:00BE7A1C-D8E6-483A-8E4D-(E-Mail Removed)...
> hi,
>
> I have read all the posts on the 256 column limit. irritating.

(...)
> i am assuming the limit is to control the overall number of cells? this
> would not affect that.
>
> ellebelle



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
256-Column Limit: No More? (PeteCresswell) Microsoft Excel Discussion 4 15th May 2008 02:19 AM
Column Limit =?Utf-8?B?R2VvZmY=?= Microsoft Excel Programming 5 3rd Jun 2006 03:28 PM
How do I limit sorting a column to the column? =?Utf-8?B?UGF0?= Microsoft Excel Worksheet Functions 0 9th Feb 2006 04:01 PM
Will the column limit be over 256? =?Utf-8?B?SGFu?= Microsoft Excel Misc 2 13th Jun 2005 08:15 PM
Column Limit Bryan Microsoft Excel Programming 3 18th Jun 2004 11:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:17 PM.