Selecting range of cells

To print a selected range of cells within a worksheet, first select (highlight) the range to be printed, then choose Print... from the File menu. Then press the Selection button in the Print What category box in the lower left comer of the dialog box. The selected range will be printed, but the selection will not be "remembered" the next time you print. 

You can also create array formulas that return an array of different values in a selected range of cells. Formulas that operate on matrices, described in Chapter 9, are examples of formulas that return an array. 

Criteria to the selected range of cells. (Unfortunately, there is no Set Criteria command in the Excel 97 Data menu.) At any time, only one range in a worksheet can be defined as the Criteria range. 

MAKING A REFERENCE TO THE ACTIVE CELL OR A SELECTED RANGE OF CELLS... 

Highlight the range of cells corresponding to 2 x n matrix, where n is the number of parameters, x. Select LINEST from the Function Wizard and enter the input as before. 

Alternatively, you can import/export data between Access and Excel by Copy and Paste operations, provided that matching records/fields (Access) and range of cells (Excel) are selected in the exchange. 

You can select a range of cells on the worksheet in several ways ... 

Click on the cell in one comer of the range, hold down the mouse button and drag to the cell in the opposite corner of the range. The range of cells will be highlighted. The size of the selection (e.g., lOR x 3C) is displayed in the Reference Area of the formula bar. 

A block of cells is a range of cells containing values and bounded by empty cells. There are several ways to select cells within a block ... 

Excel Tip. To enter the same value in a range of cells, select the range of cells, type the value, then press COMMAND+RETURN or CONTROL+ RETURN (Macintosh) or CONTROL+ ENTER (Windows). 

Choose Page Setup from the File menu, and choose the Sheet tab. Click in the Print Area text box to select it. Now select the range of cells that you want to print (you can move the dialog box out of the way if necessary), and press the OK button. To cancel a Print Area selection, delete the text within the Print Area text box. 

First, select the range of cells to be printed, then choose Print Area from the File menu, and choose Set Print Area from the submenu. 

Excel Tip. It s much better to select a single cell, then Paste, instead of selecting a destination range that is the same size as the copied or cut range. The selected cell will be the upper left corner of the pasted range of cells. 

To Cut and Paste by Using Drag-and-Drop Select the range of cells to be moved. 

Before you begin, it s important to know that when a new worksheet is opened, the status of all cells in the document is Locked. Thus if you select a range of cells to be locked, and set the status using Protect Sheet..., you will find that all cells in the document are locked. 

---