How do I change the overall size of a spreadsheet?

M

MnSCU Dale

I am trying to import some data into a spreadsheet. I have almost 130,000
lines of data. Is it possible to change the number of rows allowed in Excel?
 
F

Fredrik Wahlgren

MnSCU Dale said:
I am trying to import some data into a spreadsheet. I have almost 130,000
lines of data. Is it possible to change the number of rows allowed in
Click to expand...
Excel?

No. You have to split your import so that it goes to two sheets.

/Fredrik
 
G

Gord Dibben

No.

Spread the data over two or more sheets.

Easiest way to do that is to import just part of the data on each import.

Can you import first to a text file then break that into smaller chunks?


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 12:32:02 -0700, "MnSCU Dale" <MnSCU
 
Top