How to have more than 65,000 rows in excel 2007

M

Malaki

Hi there,

I'm using excel 2007. In worksheet i have only 65,000 rows. I have heard
that excel 2007 can provide over a million rows. Can some one help me on how
to get all the rows (over a million rows) in excel 2007?

Looking foward to hear from you.

Thanks

Malaki
 
B

Bob Umlas

Office button/Excel Options/"Save" section - make sure the top dropdown
doesn't say ".xls", but says ".xlsx" or ".xlsm" etc.
All new workbooks will not have 1048576 rows.
If you're opening a file which was created in 2003 or earlier, then you
still will get 65536 rows. To increase this yuo need to convert it to 2007:
Office button/Convert.

HTH
 

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

Top