How do I increase the number of lines in XL

D

David Biddulph

Please ask your question in the body of the message. What you have written
in the subject header isn't clear.

Do you mean the number of rows? If so, you are limited to 65536 rows in
Excel 2003, but can go up to 1,048,576 rows in Excel 2007.
 
G

Gord Dibben

You don't.

Versions 97 through 2003 have 65536 rows.

Version 2007 has just over 1,000,000 rows.


Gord Dibben MS Excel MVP
 

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

can i copy any data which is based on formula 1
Can I format columns to move across a spreadsheet? 1
what is execel 4
Stock Market Calculation 1
How do you add a number from a different worksheet into a formula. 2
how to use time format to present negative value? ex. -00:42 min 3
Line Numbers Will Not Show 0
Removing Line Numbers 4

Top