How do I change the overall size of a spreadsheet?

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

Guest

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?
 
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
 
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
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
formula 3
Spreadsheet size 13
need to input alternate blank rows in spreadsheet 5
Function in Excel to count and list number of entries of text valuesin a row. 2
cpu at 50% 1
Using functions for a cell with a number-range 3
Excel Excel spreadsheets opening at top instead of bottom. 4

Back
Top