ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to increase the max number of rows in Excel spreadshee above 6 (https://www.excelbanter.com/excel-discussion-misc-queries/134442-how-increase-max-number-rows-excel-spreadshee-above-6-a.html)

Wendell

how to increase the max number of rows in Excel spreadshee above 6
 
how to increase the max number of rows in an Excel spreadsheet above 65000

Dave F

how to increase the max number of rows in Excel spreadshee above 6
 
Use Excel 2007. Earlier versions have a hard limit of 65000 rows that can't
be changed.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Wendell" wrote:

how to increase the max number of rows in an Excel spreadsheet above 65000


Dave Peterson

how to increase the max number of rows in Excel spreadshee above 6
 
Upgrade to xl2007.

It has 1Meg rows and 16k columns.

Wendell wrote:

how to increase the max number of rows in an Excel spreadsheet above 65000


--

Dave Peterson


All times are GMT +1. The time now is 11:16 PM.

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