My Excel sheet ends at 65,536 rows. I thought it should be 1M?

[LennoxConner]

Hi all, I have a sheet where I record jobs for a major haulier, so as you can imagine it gets pretty long. For whatever reason, when I scroll down my sheet has just 65,536 rows. I have tried unhiding just in case but it seems nothing is hidden. How do I get back the rest of the rows I am entitled to? Am using office 2010 if that’s pertinent

 

[Marc L]

Hi,​

as it depends on the Excel version under the workbook was created or according to the workbook file format​

so just save the workbook as a normal workbook …​

​

 

[Logit]

Lots of good suggestions here : https://stackoverflow.com/questions/197762/is-it-possible-to-see-more-than-65536-rows-in-excel-2007

 

[LennoxConner]

issue solved!!

 

[Logit]

Glad you found an answer !