Microsoft Office Tutorials and References
In Depth Information
Moving around a Worksheet
Moving around a Worksheet
This section describes various ways to navigate the cells in a worksheet.
Every worksheet consists of rows (numbered 1 through 1,048,576) and columns (labeled A
through XFD). Column labeling works like this: After column Z comes column AA, which is
followed by AB, AC, and so on. After column AZ comes BA, BB, and so on. After column ZZ
is AAA, AAB, and so on.
The intersection of a row and a column is a single cell, and each cell has a unique address
made up of its column letter and row number. For example, the address of the upper-left
cell is A1. The address of the cell at the lower right of a worksheet is XFD1048576.
At any given time, one cell is the active cell. The active cell is the cell that accepts keyboard
input, and its contents can be edited. You can identify the active cell by its darker border,
as shown in Figure 12.2. Its address appears in the Name box. Depending on the technique
that you use to navigate through a workbook, you may or may not change the active cell
when you navigate.
FIGURE 12.2
The active cell is the cell with the dark border — in this case, cell C8.
Notice that the row and column headings of the active cell appear in a different color to
make it easier to identify the row and column of the active cell.
Excel 2013 is also available in a version for devices such as tablets and phones. These devices use a touch interface.
this topic assumes the reader has a traditional keyboard and mouse in Excel — it doesn’t cover the touch-related
commands.
 
Search JabSto ::




Custom Search