If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Question

Eglinton · 2006-08-25 11:13:18

Does anyone know if it's possible to have more than 256 columns in Excel?

Options

25-08-2006 12:13pm

#1

Eglinton

Closed Accounts Posts: 992 ✭✭✭

Join Date: September 2003

Posts: 758

Does anyone know if it's possible to have more than 256 columns in Excel?

0

Comments

Options
#2 25-08-2006 1:47pm
Evil Phil

Registered Users Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

Afaik that's the limit.

0
Options
#3 25-08-2006 2:33pm
Seth Brundle

Moderators, Politics Moderators Posts: 39,812 Mod ✭✭✭✭

Join Date: April 2003

Posts: 38786

AFAIK it can't be altered from the standard 256 columns.
I haven't yet seen a spreadsheet though with this number of used columns.
Can you rotate your data (limits you to 256 rows though)?
Can you split your data into multiple sheets?

0
Options
#4 26-08-2006 2:44pm
rsynnott

Registered Users Posts: 4,003 ✭✭✭

Join Date: July 2003

Posts: 3930

If you have 256 columns, that's a sign of terribly poor design, rather than anything else. Such a spreadsheet can't really be used by a human. What are you trying to do?

0