Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Question about number of possible cells in Excel.
The book I'm reading says Excel has 255 worksheets, 256 columns and 65,536
rows. It also says Excel has 16.5 million cells. Is that correct, and if so, how is that calculated? Another thing...it says columns are labeled A through Z, AA through AZ, and so on, up to IV. I typed "IV" into the name box, and couldn't visualize the cell reference. Am I reading it correctly as the letter "I" and the letter "V"? Thanks in advance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Question about number of possible cells in Excel.
Try this in an empty worksheet.
Edit|Goto (or F5 or ctrl-g) type: IV65536 That's the last cell on the worksheet in xl97-xl2003. xl2007 adds more columns and more rows. xl95 had fewer rows. Put this formula in that cell. =row()*column() and you'll see it evaluate to: 16,777,216 The 255 worksheets isn't correct. The number of worksheets that you can have in a workbook is limited by your computer's memory. And if you would have typed: IV1 or IV2 or iv:iv into the name box, your attempt would have worked ok. You have to type something that looks like an address. sheana wrote: The book I'm reading says Excel has 255 worksheets, 256 columns and 65,536 rows. It also says Excel has 16.5 million cells. Is that correct, and if so, how is that calculated? Another thing...it says columns are labeled A through Z, AA through AZ, and so on, up to IV. I typed "IV" into the name box, and couldn't visualize the cell reference. Am I reading it correctly as the letter "I" and the letter "V"? Thanks in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Question about number of possible cells in Excel.
Sun, 3 Feb 2008 07:09:00 -0800 from sheana
: The book I'm reading says Excel has 255 worksheets, 256 columns and 65,536 rows. It also says Excel has 16.5 million cells. Is that correct, and if so, how is that calculated? If you had a chart with three rows and five columns, how would you figure the number of cells in the chart? (By the way, the limits you cite have been greatly expanded in Excel 2007.) Another thing...it says columns are labeled A through Z, AA through AZ, and so on, up to IV. I typed "IV" into the name box, and couldn't visualize the cell reference. Am I reading it correctly as the letter "I" and the letter "V"? Thanks in advance. Yes, letter I and letter V. But you don't navigate a Excel worksheet by typing things in the Name box. When you did that, you just created a name "IV" to refer to the current cell. Scroll, or use F5 or Edit | Goto. In the goto box you specify a valid row and column, such as IV1 or IV65536. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question For Importing Data Into Excel/Converting General Number to Dollar Amount | Excel Discussion (Misc queries) | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
excel question Formats and number pad | Excel Discussion (Misc queries) | |||
Excel atuo filling cells- question | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |