How to have Excel with unlimited rows?

Asked By austin peter 0 points N/A Posted on - 02/07/2013

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.

• Status: Open
• Question Views: 5220
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Laz Zebbena

Go To Solution

Best Answer

Best Answer

Answered By Laz Zebbena 0 points N/A #193427

How to have Excel with unlimited rows?

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.

Regards,

Laz Zebbena

About Laz Zebbena

Questions
2

Answers
101

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 02/08/2013
• Question Category: MS Excel

Answered By RicharddWyatt 0 points N/A #193428

How to have Excel with unlimited rows?

Dear Austin Peter!

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

About RicharddWyatt

Questions
1

Answers
30

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 02/09/2013
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #312475

How to have Excel with unlimited rows?

Unfortunately, there is not a single version of Microsoft Office Excel that offers unlimited number of rows. All versions of the application are limited to a certain number of rows. Like for example in Microsoft Office 2007, Microsoft Office Excel 2007 is restricted to 1,048,576 rows x 16,384 columns.

This means in Microsoft Office Excel 2007, you can have a maximum of 1,048,576 rows and 16,384 columns in single worksheet. If you want to create a workbook, every worksheet in that workbook is limited to these numbers and cannot go beyond. This restriction doesn’t only apply to Microsoft Office Excel 2007 but to all newer versions as well including Excel for Office 365.

The column width in a worksheet can be set to a maximum of 255 characters and the row height to 409 points. A single cell in a worksheet can hold a maximum of 32,767 characters. The number of worksheets that a workbook can have depends on the available memory of the computer.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 09/20/2018
• Question Category: MS Excel