How To Use Semi Selection In Excel

Excel Choice Techniques

Using Selection Techniques

Before you tin can enter data, you have to select a cell. Before yous tin can alter the information, you lot have to select it. In this section, you'll acquire effective, easy Excel selection techniques that enable you to select cells, ranges, and nonadjacent cells. With one click, you can fifty-fifty select your entire worksheet, which is definitely a timesaver when information technology comes to making global changes.

Grooming Connection offer four levels of Excel training in Los Angeles.

Selecting a Cell

Selecting a cell in Excel is the outset step in entering data or executing most commands in a worksheet. The single cell that receives the data or formula you enter is the active prison cell. When a cell is selected, its border becomes assuming and the cavalcade and row indicators are highlighted.

Method

To select a cell:

1. Click the desired cell or
2. Utilise the arrow keys to move the desired cell

Exercise

In the post-obit exercise, yous volition select cells using the keyboard and the mouse.

1. If cell A1 is not selected, click it using the mouse. [Cell A1 is selected and is the active cell.]
2. Press Downwardly Arrow 4 times. [A5 becomes the active jail cell].
3. Printing Right Pointer 2 times. [C5 becomes the active cell].
4. Click cell E5. [E5 becomes the active prison cell].

Selecting a Range of Cells

A rectangular selection of multiple cells is referred to equally a range. You may wish to select a range when entering a group of data or when yous wish to perform the aforementioned action on several cells. The range appears equally a shaded block of cells, and the active prison cell in a range is defined by a bold border and white background. When a range is selected, its column and row headings are highlighted. In Figure i-vii, the selected range is referred to as B6:C9 ("B6 to C9").

Method

To select a range of cells in Excel:

Mouse method

1. Select the first jail cell of the desired range.
2. Drag the mouse pointer through the range of cells you wish to include. or
3. Printing and concord Shift, and then click the terminal jail cell of the range.
4. Release Shift

Keyboard method

1. Use the arrow keys to motion the cell pointer to the outset cell of the desired range.
2. Printing and hold Shift, and then utilize the arrow keys to highlight the desired range.
3. Release Shift.

Exercise

In the following exercise, you volition select ranges of cells in Excel using the mouse and the keyboard.

1. Open a Blank workbook select prison cell A1.
2. Drag the mouse pointer to jail cell D5. [The range A1 to D5 is selected].
3. Using the pointer keys, select prison cell B2. [Prison cell B2 is selected. The outset range, A5 to D5, is deselected].
4. Press and agree Shift, and then apply the pointer keys to select jail cell E7. [The range B2:E7 is selected].
5. Release Shift.
6. Select cell A1. [The range B2:E7 is deselected].
7. Printing and hold Shift, and then click jail cell D1.
8. Release Shift. [The range A1:D1 is selected].
9. Click cell A1. [The range A1:D1 is deselected].

Selecting Nonadjacent Cells and Ranges

As a rule, to select multiple, nonadjacent objects in Windows, yous employ the Ctrl fundamental. For instance, you may use Ctrl and the mouse to select multiple files or folders in Explorer or My Computer. This method also works in Excel to select nonadjacent cells and ranges.

Method

To select nonadjacent cells or ranges in Excel:

1. Select the first cell or range.
2. Press and hold Ctrl
3. Select the next cell or range.
4. Release Ctrl.

Exercise

In the following practice, you lot will select nonadjacent cells and ranges.

1. Make sure prison cell A1 is selected.
2. Press and hold Ctrl. [The range A1 to D5 is selected].
3. Select prison cell C4. [Cells A1 and C4 are selected].
4. Using the mouse, select the range B6:E10. [Cells A1 and C4, and the range B6:E10 are selected].
5. Release Ctrl.
6. Select cell A1.

Selecting an Entire Worksheet

Selecting an unabridged worksheet is useful when you lot want to make changes on a global calibration. For instance, you might want to change the size of the font in every cell in the worksheet. One time you select the entire worksheet using the Select All button, illustrated in Figure ane-four, you can do this in a single step.

Method

To select an entire worksheet in Excel:

1. Click the Select All button.

Exercise

In the following exercise, you lot will select the entire worksheet.

1. Click the Select All button. [The entire worksheet is highlighted].
2. Click any cell. [Simply the clicked cell is selected.].

Source: https://www.trainingconnection.com/excel/lessons/excel-selections.php

Posted by: moodytings1993.blogspot.com

Share this post