Microsoft Office Tutorials and References
In Depth Information
Inserting rows, columns, and cells
IMPORTANT If you hide the first row or column in a worksheet, you must click the Select All
button in the upper-left corner of the worksheet (above the first row header and to the left of
the first column header) or press Ctrl+A to select the entire worksheet. Then, on the Home tab,
in the Cells group, click Format, point to Hide & Unhide, and then click either Unhide Rows or
Unhide Columns to make the hidden data visible again.
Just as you can insert rows or columns, you can insert individual cells into a worksheet. To
insert a cell, click the cell that is currently in the position where you want the new cell to
appear. On the Home tab, in the Cells group, in the Insert list, click Insert Cells to open the
Insert dialog box. In the Insert dialog box, you can choose whether to shift the cells
surrounding the inserted cell down (if your data is arranged as a column) or to the right (if
your data is arranged as a row). When you click OK, the new cell appears, and the contents
of affected cells shift down or to the right, as appropriate. Similarly, if you want to delete
a block of cells, select the cells, and on the Home tab, in the Cells group, in the Delete list,
click Delete Cells to open the Delete dialog box—complete with options that you can use to
choose how to shift the position of the cells around the deleted cells.
TIP The Insert dialog box also includes options you can click to insert a new row or column;
the Delete dialog box has similar options for deleting an entire row or column.
If you want to move the data in a group of cells to another location in your worksheet,
select the cells you want to move and point to the selection’s border. When the pointer
changes to a four-pointed arrow, you can drag the selected cells to the desired location
on the worksheet. If the destination cells contain data, Excel displays a dialog box asking
whether you want to overwrite the destination cells’ contents. If you want to replace the
existing values, click OK. If you don’t want to overwrite the existing values, click Cancel and
insert the required number of cells to accommodate the data you want to move.
In this exercise, you’ll insert a column and row into a worksheet, specify insert options, hide
a column, insert a cell into a worksheet, delete a cell from a worksheet, and move a group
of cells within the worksheet.