Microsoft Office Tutorials and References
In Depth Information
Editing a Worksheet
Creating a Basic Worksheet
Choose the direction you want existing cells to move.
Inserting additional columns.
Click the desired insert option and then click OK.
Excel shifts existing data according to your selection.
In Figure 8-16, a blank cell was inserted in cell C13.
Inserting Multiple Columns or Rows
To insert multiple columns or rows, select
headings or row numbers across multiple
columns or rows.
Bypass Dialog Box
To bypass the Insert dialog box and just
insert a cell, choose Home>Cells>Insert.
If you insert a column, Excel moves information in
the current column (and all columns to the right
of the current column) to the right. If you insert a
row, Excel moves information in the current cell
and all cells below the current row down.
No matter how many rows or columns
you insert, Excel does not exceed its
original worksheet size of 16,384 columns and
Instead of inserting an entire column or an entire
row, you can also insert just a single cell or even a
group of cells. Excel then moves existing data
down or to the right, depending on an option you
specify. Begin by selecting the cells where you
want new cells. Then choose Home>Cells>Insert
(arrow) and choose Insert Cells. You see the Insert
dialog box seen in Figure 8-15.
Inserting cells where needed.