Selecting Cells


To perform an activity or function in a cell, you need to select a cell or group of cells. For example, if you want to enter text or numbers into a cell, you need to first select the cell. If you want to move or copy the contents of a cell or group of cells, you must first select the cell or cells. Selecting a cell involves making the cell selector surround the cell. In Figure 3.1, I've selected cell A4.

Figure 3.1. In this figure, I selected a single cell.


In Figure 3.2, I've selected the block of cells with an upper-left boundary of cell A5 and a lower-right boundary of E6. When you select a group of cells, called a range, the cell selector surrounds the cell in the upper-left corner of the group, but the rest of the cells appear highlighted. I selected this range by dragging the mouse pointer across the cells. You also can make this selection if you click the cell at one corner of the range (I like the upper-left corner cell), hold down the Shift key, and then click the diagonal corner cell.

Figure 3.2. In this figure, I selected a group of cells.


When you select a range of cells, you refer to the range by naming its upper-left and lower-right cell, and you write the cell address of a range of cells using the upper-left corner and the lower-right corner, separated by a pair of periods. In Figure 3.2, I selected the range A5..E6 and, out loud, I would say, "I selected cells A5 through E6."

You also can select an entire row by clicking the number identifying the row; to select multiple contiguous rows, drag across the row numbers. Similarly, you select a single column by clicking its column letter and multiple contiguous columns by dragging across their column letters.

You also can select noncontiguous rows or columns by holding down the Ctrl key as you click each row number or column letter.

In writing, you can refer to a range using the upper-left cell and the lower-right cell separated either by two periods, as I did above, or by one period. Throughout the rest of this book, I'll refer to ranges using only a single period between the cell boundaries of the range.





Absolute Beginner's Guide to Quattro Pro X3
Absolute Beginners Guide to Quattro Pro X3
ISBN: 0789734265
EAN: 2147483647
Year: 2007
Pages: 128
Authors: Elaine Marmel

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net