Home > Articles

Navigating in a Notebook

  • Print
  • + Share This
This chapter is from the book

In this chapter

  • Selecting cells
  • Navigating around spreadsheets and notebooks
  • Entering information into notebooks
  • Saving a notebook

Navigating a new software package is like finding your way around a new town after a move—you need to learn how to move around in it efficiently. In Quattro Pro, you also need to learn how to select so that you can move and copy information as those actions become necessary. In this chapter, you'll learn how to move around a notebook, select cells, enter information into a spreadsheet, correct mistakes, and, most importantly, save a notebook so that you save the fruit of your efforts.

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.

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.1

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

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."

Figure 3.2

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

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.

  • + Share This
  • 🔖 Save To Your Account