How do i enable all 1,00,000+ rows in excel 2007

F

free_ur_mind

Excel 2007 as more than 1,00,000 rows, but in our organisation setup i see
only 65536 rows. How do i enable the remaining.
 
H

Harald Staff

.... and then close the file, and then reopen it.

You can change the default file format in Office button > Excel options,
category Save. This may or may not be reset by your organisation on next
logon.

Best wishes Harald
 

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

How do i assign separators? 0
How do I get more rows than 66,000 rows? 4
how do I get more than 65000 rows to display in Excel 2007 5
How to have more than 65,000 rows in excel 2007 3
what should i do if i don't want to see empty rows ? 3
Delete empty rows 1
Where are the extra columns and rows? 6
Excel 2007 rows & columns 3

Top