Insert and delete Excel table cells cells and columns

You can insert blank cells above or to the left of the active cell in an Excel worksheet, and move the other cells in the same column down or to the right of the other cells in the same row. Similarly, you can insert multiple rows above a row and insert multiple columns to the left of a column. You can also delete cells, rows, and columns.

Note Microsoft Office Excel 2007 has more rows and columns than before, with new restrictions as follows: Width is 18,278 (A to ZZZ) column, height is 1,048,576 rows.

　　Insert blank cells in a worksheet

1. Select the cell or range of cells (range: two or more cells on the worksheet that you want to insert into the new blank cell. Cells in a range can be contiguous or nonadjacent. )。 The number of cells you select should be the same as the number of cells you want to insert. For example, to insert five blank cells, you need to select five cells.

> How to select a cell, range, row, or column

Select action

A cell clicks the cell or presses the arrow keys to move to the cell.

Cell range Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while pressing the arrow keys to extend the selection.

You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.

A larger 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 use the scrolling feature to display the last cell.

All cells in the worksheet click the Select All button.

To select the entire worksheet, you can also press CTRL + A.

　　Note If the worksheet contains data, press CTRL + A to select the current range. Press CTRL + A for one second to select the entire worksheet.

nonadjacent cells or range of cells select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.

You can also select the first cell or range of cells, and then press Shift+f8 to add another nonadjacent cell or range to the selected range. To stop adding cells or ranges to the selected range, press Shift+f8 again.

　　Note You cannot deselect a cell or range of cells in nonadjacent selections without canceling the entire selection.

Click the row or column heading for the entire row or column.

Row headers

Column headings

You can also select a cell in a row or column by selecting the first cell, and then pressing the ctrl+shift+ arrow key (right ARROW or LEFT arrow for the row, or up ARROW or DOWN arrow for the column).

　　Note If the row or column contains data, press the ctrl+shift+ arrow key to select the portion of the row or column before the last cell that has been used. Press the ctrl+shift+ arrow key for one second to select an entire row or column.

Adjacent rows or columns drag the mouse between row headings or column headings. Either select the first row or column, and then hold down Shift while you select the last row or column.

nonadjacent rows or columns click the row or column heading for the first row in the selection, and then hold down CTRL while you click the column headings for the row headings or other columns that you want to add to the other rows in the selected range.

The first or last cell in the row or column selects a cell in the row or column, and then presses CTRL + the ARROW keys (for rows, use the right arrow or left arrow; Use the UP or DOWN ARROW keys for columns).

The first or last cell in the worksheet or Microsoft Office Excel table, press Ctrl+home to select the first cell in the worksheet or Excel list.

Press Ctrl+end to select the last cell in the worksheet or Excel list that contains data or formatting.

The cell range before the last cell in the worksheet (lower-right corner) selects the first cell, and then presses Ctrl+shift+end to extend the selected range to the most-used cell in the worksheet (lower-right corner).

To the range of cells at the beginning of the worksheet select the first cell, and then press Ctrl+shift+home to extend the cell selection to the beginning of the worksheet.

Increase or decrease the number of cells in the active selection hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular area between the active cell and the cell you clicked becomes the new selected range.

Tip To deselect a range of cells, click any cell in the worksheet.

2, on the Start tab, in the Cells group, click the arrow next to Insert, and then click Insert Cell.

Insert Cell

Tip You can also right-click the selected cell, and then click Insert on the shortcut menu.

3, in the Insert dialog box, click the direction in which you want to move the surrounding cells.

Comments

• When inserting cells into a worksheet, all references that are affected by the insertion are adjusted accordingly, whether they are relative (relative cell references: In a formula, the cell address based on the relative position of the cell that contains the formula and the cell that is referenced). If you copy the formula, the relative reference is automatically adjusted. Relative references take the A1 style. ) or an absolute reference. This also applies to deleting cells, except when the cells you delete are referenced directly by the formula. If you need to reference automatic tuning, it is recommended that you use a range reference as much as possible in the formula instead of specifying a single cell.

• You can insert cells that contain data and formulas by copying or cutting them, right-clicking where you want to paste them, and then clicking Insert Copied cells or insert cut cells on the shortcut menu.

Tips

• To quickly repeat the action of inserting cells, click where you want to insert the cell, and then press Ctrl+y.

• If you are formatting, you can use the Insert Options

To choose how to format the inserted cells.

Insert rows in a worksheet

1. Do one of the following:

• To insert a single line, select the row above which you want to insert a new row or a cell in that row. For example, to insert a new row above line 5th, click one of the cells in row 5th.

• To insert multiple rows, select those rows above which you want to insert a new row. The number of rows selected should be the same as the number of rows to be inserted. For example, to insert three new rows, you need to select three rows.

• To insert nonadjacent rows, press and hold CTRL while you select nonadjacent rows.

> How to select a cell, range, row, or column

See the section Insert a blank cell.

Tip To deselect a range of cells, click any cell in the worksheet.

2, on the Start tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Row.

Insert Sheet Rows

Tip You can also right-click the selected row, and then click Insert on the shortcut menu.

Note When you insert rows in a worksheet, all references that are affected by the insertion are adjusted accordingly, whether they are relative or absolute references. This also applies to deleting rows, except when the cells you delete are referenced directly by the formula. If you need to reference automatic tuning, it is recommended that you use a range reference as much as possible in the formula instead of specifying a single cell.

Tips

• To quickly repeat the action of inserting rows, click where you want to insert the row, and then press Ctrl+y.

• If you are formatting, you can use the Insert Options

To choose how to format the inserted rows.

　　Insert columns in a worksheet

1. Do one of the following:

• To insert a single column, select the column or cell in the column to which you want to insert the new column immediately to the right. For example, to insert a column to the left of column B, click a cell in column B.

• To insert multiple columns, select those columns to which you want to insert the column directly to the right. The number of columns you select should be the same as the number of columns you want to insert. For example, to insert three new columns, you need to select three columns.

• To insert nonadjacent columns, press and hold CTRL while you select nonadjacent columns.

> How to select a cell, range, row, or column

See the section Insert a blank cell.

Tip To deselect a range of cells, click any cell in the worksheet.

2, on the Start tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Column.

Insert Sheet Rows

Tip You can also right-click the selected cell, and then click Insert on the shortcut menu.

Note When you insert a column in a worksheet, all references that are affected by the insertion are adjusted accordingly, regardless of whether they are relative or absolute references. This also applies to deleting columns, except when the cells you delete are referenced directly by the formula. If you need to reference automatic tuning, it is recommended that you use a range reference as much as possible in the formula instead of specifying a single cell.

Tips

• To quickly repeat the insertion of a column, click where you want to insert the column, and then press Ctrl+y.

• If you are formatting, you can use the Insert Options

To choose how to format the inserted column.

　　Delete a cell, row, or column

1. Select the cells, rows, or columns you want to delete.

> How to select a cell, range, row, or column

See the section Insert a blank cell.

Tip To deselect a range of cells, click any cell in the worksheet.

2, on the Start tab, in the Cells group, do one of the following:

Delete a worksheet row

• To delete the selected cells, click the arrow next to delete, and then click Delete Cells.

• To delete the selected row, click the arrow next to delete, and then click Delete Sheet Rows.

• To delete the selected column, click the arrow next to delete, and then click Delete Sheet column.

Tip You can also right-click the selected cell, row, or column, click Delete on the shortcut menu, and then click the option that you want.

3. If you want to delete a cell or range of cells Range: two or more cells on a worksheet. Cells in a range can be contiguous or nonadjacent. , in the Delete dialog box, click Move left cell to the right, move the lower cell up, entire row, or entire column.

If you delete a row or column, the other rows or columns are automatically moved up or left.

Tips

• To quickly repeat the deletion of cells, rows, or columns, select the next cell, row, or column, and then press Ctrl+y.

• If necessary, you can restore the data that you just deleted. On the Quick Access Toolbar menu, click Undo Delete, or press ctrl+z.

Comments

• Press DELETE to delete only the contents of the selected cells without deleting the cells themselves.

· Microsoft Office Excel keeps the formula updated by adjusting the references to move cells to reflect their new position. However, if the cell referenced in the formula has been deleted, the error value is displayed #REF!.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join