Question

What are the three Different ways to select cells in a worksheet ? Explain all the methods.​

Answer 1

Selecting Cells with the Mouse

To select a single cell, left-click on it.

To select a range of cells, click and hold the left mouse button and drag through the range you want to select. When a range is selected, it becomes highlighted.

To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. Any previously selected ranges remain selected.

Once you select a range or multiple ranges, you can move the active cell within the range without deselecting the range or ranges by using the ENTER, SHIFT + ENTER, TAB, or SHIFT + TAB keys.