answersLogoWhite

0

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).

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How many cells in a worksheet?

16,777 216


How many character in a single worksheet?

It is unlimited.


When using a spreadsheet software each worksheet can have how many cells?

The number of cells in a worksheet depends on the spreadsheet software being used. For example, in Microsoft Excel, a single worksheet can contain up to 1,048,576 rows and 16,384 columns, resulting in over 17 billion cells. Google Sheets, on the other hand, has a limit of 10 million cells per spreadsheet, which includes all worksheets. Thus, the specific number of cells varies by application and its version.


To create a worksheet you enter information into cells?

Technically, a worksheet is a worksheet even if it is empty. To create a worksheet that will do calculations, then you would start to enter things into its cells.


Many worksheet cells contain a number that can be used in a calculation called?

value.


What is the difference between sheet tabs and worksheets?

A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.


Is a worksheet range a group of adjacent worksheet?

Yes, a worksheet range refers to a group of adjacent cells in a spreadsheet, typically defined by a starting cell and an ending cell (e.g., A1:B10). These cells can be selected or manipulated together for various operations, such as calculations or formatting. A range can also consist of a single column, row, or even a non-contiguous selection of cells if specified correctly.


What appear between cells in a worksheet but they do not print if the worksheet is printed?

Gridlines


What can you apply conditional formatting to?

You apply conditional formatting to as many cells on a worksheet as you like.


How many cells are in a 2010 worksheet?

There are 17,179,869,184 cells in Excel 2010. That is based on having 16,384 columns and 1,048,576 rows.


What cell does formulas and functions in Excel make use of?

Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.


When considering which cells another worksheet user should be able to manipulate leave the cells?

When considering which cells another worksheet user should be able to manipulate, leave the cells _____.