Select cell contents in Excel

In Excel, you can select cell contents of one or more cells, rows and columns.

Select one or more cells

1. Click on a cell to select it. Or use the keyboard to navigate to it and select it.

2. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.

   Or use the Shift + arrow keys to select the range.

3. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Select one or more rows and columns

1. Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.

2. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.

3. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.

Select table, list or worksheet

1. To select a list or table, select a cell in the list or table and press Ctrl + A.

2. To select the entire worksheet, click the Select All button at the top left corner.

   

Insert Data

In MS Excel, there are 1048576*16384 cells. MS Excel cell can have Text, Numeric value or formulas. An MS Excel cell can have maximum of 32000 characters.

Inserting Data

For inserting data in MS Excel, just activate the cell type text or number and press enter or Navigation keys.

Inserting Formula

For inserting formula in MS Excel go to the formula bar, enter the formula and then press enter or navigation key. See the screen-shot below to understand it.

Modifying Cell Content

For modifying the cell content just activate the cell, enter a new value and then press enter or navigation key to see the changes. See the screen-shot below to understand it.