How many cells are in single excel sheet?

Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Software and Applications > Office Applications > Microsoft Excel > How many cells are in single excel sheet?
Answer:
The original version of Excel had a maximum limit of 16,777,216 (16.8 million) cells within a single worksheet and that continued to be the worksheet limit until it was later expanded in version 2007 to the current limit of 17,179,869,184 (17.2 billion) cells.

Originally within each worksheet, Excel provided columns A to IV, which is 256 (2^8) columns; and 65,536 rows (2^16); therefore 256 x 65,536 = 16,777,216 (2^24).

As mentioned, in version 2007 the worksheet maximum size limits were greatly expanded, providing columns A to XFD, which is 16,384 (2^14) columns; and 1,048,576 rows (2^20); therefore 16,384 x 1,048,576 = 17,179,869,184 (or 2^34).
First answer by ID0409189650. Last edit by Markmain. Contributor trust: 1 [recommend contributorrecommended]. Question popularity: 15 [recommend question].

Can you answer these Microsoft Excel questions?

Relevant answers:

Related Ads:

Related ads:

Sign in using:

Answers.com members:




Create account
Join using:

Join Answers.com:





Already a member?
Sign in
Why join?
Joining is free and easy. You can still be anonymous; just choose any username and password.

  • Get notified about updated answers
  • Follow your favorite categories
  • Get credit for your contributions
  • Customize your profile
  • Answer questions more easily
Not convinced? Read more.
Lost your password?

You may already have an Answers.com account.
Click here to connect your accounts.  
If you don't want to connect accounts, you can start a new one from scratch.
Minor details...


  

Connect your accounts...




Lost password?
Why do we need your email address?
We will use your email address to send you updates (if you request them) about questions you ask, answer or track, and to help you retrieve your password if you forget it.

Your email address will not be used for any other purpose without your permission.
Already have an Answers.com account? Connect your accounts!
By doing so, you include all of your history (contributions, messages, profile) from your Answers.com account in your Facebook account.

If you don't connect accounts, your new account will be starting from scratch.

Home

Welcome
Help center
Browse categories
Random question
Community forum