Edit data on multiple worksheets

When you select several worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) and then change the data on one of them, the changes are applied to the same cells on all the selected worksheets.

  1. Click the tab of the first worksheet that contains the data that you want to edit. Then hold down CTRL while you click the tabs of other worksheets that contain the same data.

 Note   If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

Tab scrolling buttons

  1. On the active worksheet (active sheet: The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold.), select the cell or range of cells that contains the data that you want to edit.

ShowHow to select cells

To select Do this
A single cell Click the cell, or press the arrow keys to move to the cell.
A range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells Click the first cell of the range, and then drag to the last cell.
A large range of cells Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.
All cells on a worksheet

Click the Select All button.

Select All button

Nonadjacent cells or cell ranges Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
An entire row or column

Click the row or column heading.

Worksheet headings

Callout 1 Row heading
Callout 2 Column heading
Adjacent rows or columns Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
Nonadjacent rows or columns Select the first row or column, and then hold down CTRL while you select the other rows or columns.
More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) and the cell that you click becomes the new selection.

 Note   To cancel a selection of cells, click any cell on the worksheet.

  1. Edit the data in the selected cell, and then press ENTER or TAB to move the selection to the next cell.
  2. Repeat the previous step until all the changes have been made.

 Notes 

  • When you edit data, the changes affect all selected worksheets and may inadvertently replace data that you didn't mean to change. If needed, you can view worksheets at the same time:
    1. On the Window menu, click New Window.
    2. Switch to the new window, and then click a worksheet that you want to view. Repeat for each worksheet that you want to view.
    3. On the Window menu, click Arrange, and then click the option that you want.

To view worksheets in only the active workbook, select the Windows of active workbook check box.

  • To cancel a selection of multiple worksheets, click any unselected worksheet. If an unselected worksheet is not visible, right-click the tab of a selected worksheet, and then click Ungroup Sheets.
 
 
Applies to:
Excel 2003