• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Excel: Quick Start! > Navigating and Working with Worksheets

Navigating and Working with Worksheets

Each Excel worksheet is comprised of 256 columns and 65,536 rows. Sometimes, you can get lost in the vast forest of worksheet cells, so one of the first things you need to learn is how to read cell names, called addresses. Excel worksheets are laid out like grids, and each cell in the grid has a name or reference based on which row and column it's in.

Excel labels columns with alphabet letters, and rows with numbers. Cell names always reference the column letter first, and then the row number. For example, the cell in the top left corner in a worksheet is A1. If you become confused about which cell you're in, look at the reference area at the far left end of the formula bar, called the Name box (if you've worked with other spreadsheet programs, you may know this box as the Reference box). This is kind of like a "you-are-here" marker; it will always show you which cell you're in. Figure 1.5 points out the Name box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint