ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I increase the number of lines in XL (https://www.excelbanter.com/excel-discussion-misc-queries/146554-how-do-i-increase-number-lines-xl.html)

Lavoisier 111

How do I increase the number of lines in XL
 


Don Guillett

How do I increase the number of lines in XL
 


--
Don Guillett
SalesAid Software

"Lavoisier 111" <Lavoisier
wrote in message
...



David Biddulph[_2_]

How do I increase the number of lines in XL
 
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.
--
David Biddulph

"Lavoisier 111" <Lavoisier wrote in message
...




Gord Dibben

How do I increase the number of lines in XL
 
You don't.

Versions 97 through 2003 have 65536 rows.

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


Gord Dibben MS Excel MVP

On Thu, 14 Jun 2007 14:37:01 -0700, Lavoisier 111 <Lavoisier
wrote:




All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com