How to have Excel with unlimited rows?

Asked By 0 points N/A Posted on -
qa-featured

Is it really possible to have Excel with unlimited rows? I want to compile several pages into one worksheets making it a very large worksheet without having to switch from one to another. However, after I have exported all the data, some items are missing. Please give me some tips on how to have unlimited rows in Excel 2010.

SHARE
Best Answer by Laz Zebbena
Best Answer
Best Answer
Answered By 0 points N/A #193427

How to have Excel with unlimited rows?

qa-featured

In excel 2010 Worksheet size is 1,048,576 rows by 16,384 columns. So that means you can not Copy more than 1,048,576 rows in one worksheet. No version has unlimited row numbers.

But you can bring unlimited data in your excel sheet with Microsoft PowerPivot add- in.

You can download it from Microsoft website.

unlimited data in your excel sheet with Microsoft PowerPivot

Regards,

Laz Zebbena

Answered By 0 points N/A #193428

How to have Excel with unlimited rows?

qa-featured

Dear Austin Peter!

No any version of MS Excel has unlimited number of rows.

Login/Register to Answer

Related Questions