exceeding columns limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I will need much more than 256 columns on my spreadsheet. How do I go about
that? I guess I would need separate worksheets, but please explain how to
link it, etc.
a second question is: I am replacing a formula with its result. I have a
column of more than 20,000 rows. How do I do it going down the column without
doing each one individually?
 
joy,

Excel 2007 has some 16,000 columns, I think. But it's pretty unusual to need more than 256.

As for replacing formulas with the current results, just do this. Select the cells. Copy.
Keep the selection exactly where it is. Edit - Paste Special - Values.
 
You don't say how you are going to get the data into Excel that has more than
256 columns of data.

If you are reading it from a .csv file or a .txt file that is in a more or
less standard comma/semi-colon/tab or pipe symbol ( | ) field separated
format, I created an Excel workbook that will read such a file and import it
into pre-Excel 2007 workbooks creating the necessary added worksheets to
accomodate all of the columns of data. It is still limited to 64K rows, but
your number of approximately 20,000 is well within that limit.

You can download and try the workbook from here:
http://www.jlathamsite.com/uploads/ImportExcessColumnsOfData.xls
Runs under any version of Excel. Also works to read type of files mentioned
that have less than 256 columns of data just as well - I'm not sure if it is
a smarter or dumber version of the text import feature, but in some cases (as
with large number of columns) it is definitely smarter.
 
Back
Top