PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup How can I extend the maximum # of columns to 500

Reply

How can I extend the maximum # of columns to 500

 
Thread Tools Rate Thread
Old 11-01-2005, 09:39 PM   #1
=?Utf-8?B?TWU=?=
Guest
 
Posts: n/a
Default How can I extend the maximum # of columns to 500


I need more than 250 columns in a spread sheet. How can I change the maximum
size to 500?
  Reply With Quote
Old 11-01-2005, 10:18 PM   #2
Nick Hodge
Guest
 
Posts: n/a
Default Re: How can I extend the maximum # of columns to 500

Not possible in Excel I'm afraid

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Me" <Me@discussions.microsoft.com> wrote in message
news:1B42CBB5-2EB6-4D3C-BD5B-21FC61090144@microsoft.com...
>I need more than 250 columns in a spread sheet. How can I change the
>maximum
> size to 500?



  Reply With Quote
Old 11-01-2005, 10:54 PM   #3
Gord Dibben
Guest
 
Posts: n/a
Default Re: How can I extend the maximum # of columns to 500

You can't.

256 is the limit. Use another worksheet or another application.

Gord Dibben Excel MVP

On Tue, 11 Jan 2005 13:39:07 -0800, "Me" <Me@discussions.microsoft.com> wrote:

>I need more than 250 columns in a spread sheet. How can I change the maximum
>size to 500?


  Reply With Quote
Old 13-01-2005, 11:04 PM   #4
Jack in the UK
Guest
 
Posts: n/a
Default Re: How can I extend the maximum # of columns to 500


Hi buddy
Sadly Excel offer the 256 max columns, if you need more i would suggest
splitting teh data set over two worksheets ie first 250 and second 250
you can now work OK - format them correctley and when you print no one
will ever know.

Jack



--
Jack in the UK
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1343224.html



  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off