ExcelBanter - How do I change the overall size of a spreadsheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I change the overall size of a spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/21704-how-do-i-change-overall-size-spreadsheet.html)

MnSCU Dale

How do I change the overall size of a spreadsheet?

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?

Fredrik Wahlgren

"MnSCU Dale" <MnSCU wrote in message
...
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?

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

/Fredrik

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
wrote:

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?

All times are GMT +1. The time now is 12:39 PM.