limited number of columns

  • Thread starter Thread starter Katja
  • Start date Start date
K

Katja

Hi!
Is there any way to increase the number of columns in one
spreadsheet. The last column seems to be "IV".

Grateful for any tips.
 
Nope. Either use more sheets or more files, or preferably if possible look
at a different layout for the data that keeps it on a single sheet. Maybe
transposing the data?
 
Hi Katja

no, you are limited to 256 columns ... it is not possible to increase them
(same with the rows - here you're limited to 65536) - options are basically
to split your data across two worksheets, re-organise your data or try
another program like quattro-pro.

Cheers
JulieD
 

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

insufficient columns in a spreadsheet 3
Excel 2007 Column Limitations 1
Ran out of columns in excel worksheet. How do I increase them? 3
Need to expand Excel 2007 spreadsheet beyond column IV 2
Expanding Excel Sheet 2
How to add columns to the end of a spreadsheet--(last col is IV)? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
All sheets opening at column IV - help! 1

Back
Top