swissfere.blogg.se

Hold down the Control key and click on the sheet tab.Move the mouse pointer over the second sheet tab.To select multiple non contiguous sheets: Any actions that you perform will now affect all highlighted sheets. Hold down the Shift key and click on the sheet tab.Īll the tabs between these two sheets will turn white.Move the mouse pointer over the last sheet tab.Click on the sheet tab for the first sheet.The active sheet becomes white (see Figure 4). It can be advantageous to select multiple sheets at times when you want to make changes to many sheets at once.Ĭlick on the sheet tab for the sheet you want to select. You can select either one or multiple sheets. You can also use the keyboard to select the entire sheet by pressing Control+A. To select the entire sheet, click on the small box between the A column header and the 1 row header. Click on all of the subsequent columns or rows while holding down the Control key.To select multiple columns or rows that are not contiguous: Click the last column or row in the group.Click on the first column or row in the group.To select multiple columns or rows that are contiguous: To select a single row, click on the row identifier number. To select a single column, click on the column identifier letter (see this figure). Hold down the Control key and click or click-and-drag to select a range.Įntire columns and rows can be selected very quickly in OOo.Move the mouse pointer to the start of the next range or single cell.Select the cell or range of cells using one of the methods above.

For example, to select the range that would go from A3 to C6, you would enter A3:C6. To select a range of cells, enter the cell reference for the upper left hand cell, followed by a colon (:), and then the lower right hand cell reference. Click into the Name box as described in Using a cell reference. You can also directly select a range of cells using the Name box. The result of any of these methods looks like the right side of this figure. While holding down the Shift key, use the cursor arrows to select the rest of the range.Select the cell that will be one of the corners in the range of cells.To select a range of cells without using the mouse:

Click in the cell which is to be one corner of the range of cells.To select a range of cells without dragging the mouse: Once the desired block of cells is highlighted, release the left mouse button.Press and hold down the left mouse button.To select a range of cells by dragging the mouse: You can verify your selection by looking in the Name box.Ī range of cells can be selected using the keyboard or the mouse. The result will look like the left side of this figure. Cells can be selected in a variety of combinations and quantities.