How can I extend the maximum # of columns to 500

M

Me

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

Nick Hodge

Not possible in Excel I'm afraid

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
G

Gord Dibben

You can't.

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

Gord Dibben Excel MVP
 
J

Jack in the UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Calculate the median value before a specified list 0
Bugs in Office 2019 0
How can I print rows that go outside of the page without shrinking the text? 0
How can the font and size of (all) citation numbers be altered? 1
Excel 2007 Column Maximum 2
How to center adjust text above and image in a two column document. 1
Document extends beyond horizontal ruler! 1

Top