Enter, Edit, and Delete 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

The currently selected cell in Excel is called the active cell. You can also select a group of adjacent cells, or a cell range. Many operations can be performed against a cell range, including moving, copying, deleting, and formatting. A cell range can be defined in different ways: Select a specific range of cells, select multiple columns or rows, or select the entire worksheet.

To select a range of cells:

  • Move to the first cell in the range.
  • The mouse pointer becomes a large cross.
  • Click and hold the left mouse button and drag left or right, up or down to the last cell you want to select.
  • Release the mouse button.
  • The cells you selected are shaded.

    Cell Range

To select all cells in a column or row:

  • Click the gray Column heading to select the entire column. (Click and drag the cursor across other column headings to select those columns.)

    Select All Cells in a Column
  • Click the gray Row heading to select the entire row. (Click and drag the cursor down through the row headings select those rows.)

    Select All Cells in a Row

To select the entire worksheet:

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

    Select Entire Workbook

If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select and hold down the Control key while selecting other ranges.

Use Cntrl Key to Select Specific Columns, Rows, Cells