How can I extend the maximum # of columns to 500

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Me - 11 Jan 2005 21:39 GMT

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

Reply to this Message

Nick Hodge - 11 Jan 2005 22:18 GMT

Not possible in Excel I'm afraid

Signature

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

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

Reply to this Message

Gord Dibben - 11 Jan 2005 22:54 GMT

You can't.

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

Gord Dibben Excel MVP

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

Reply to this Message

Jack in the UK - 13 Jan 2005 23:04 GMT

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

Reply to this Message