Microsoft Office Tutorials and References
In Depth Information
Creating Your First Spreadsheet
Creating a Basic
• The smallest unit in your worksheet is the cell . Cells are identified by column
and row. For example, C6 is the address of a cell in column C (the third column)
and row 6 (the sixth row). Figure 14-2 shows this cell, which looks like a
rectangular box. Incidentally, an Excel cell can hold up to 32,000 characters.
• A worksheet can span an eye-popping 16,000 columns and 1 million rows .
In the unlikely case that you want to go beyond those limits—say you’re
tracking blades of grass on the White House lawn—you’ll need to create a new
worksheet. Every spreadsheet file can hold a virtually unlimited number of
• When you enter information, you enter it one cell at a time . However, you
don’t have to follow any set order. For example, you can start by typing
information into cell A40 without worrying about filling any data in the cells that appear
in the earlier rows.
The largest part of
the Excel window is
the worksheet grid,
where you type in your
Note: Obviously, once you go beyond 26 columns, you run out of letters. Excel handles this by doubling
up (and then tripling up) letters. For example, column Z is followed by column AA, then AB, then AC, all
the way to AZ and then BA, BB, BC—you get the picture. And if you create a ridiculously large worksheet,
you’ll find that column ZZ is followed by AAA, AAB, AAC, and so on.