Entering and Editing Data

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

Selecting multiple cells

In Excel, the cell that is currently selected is the active cell. A group of cells is called a range.

To select a range of cells:

  • Move to the first cell in the range.
  • The mouse pointer becomes a large cross. Large Cross
  • Hold down the left mouse button and drag to the last cell you want to select.
  • Release the mouse button.
  • The cells you selected are shaded.

To select all cells in a column or row:

  • Click the Column or Row heading.

To select multiple columns or rows:

  • Click one heading and drag to select the others.

Column Selected

Row Selected

To select the entire worksheet:

  • Click the gray rectangle in the upper-left corner to select entire worksheet.

Select All Button

Important pointIf the cells and columns you want to select are not directly next to each other, select one of the ranges you want to select and hold down the Control key while selecting other ranges. For example, you may want to select column A and column C, but not column B.