Microsoft Office Tutorials and References
In Depth Information
Editing a Worksheet
To insert an entire column, select a
column where you want your new column
to be. Choose Home > Cells > Insert
(arrow) and choose Insert Sheet Columns.
Excel inserts a new blank column and
shifts the selected column and all other
columns to the right to make room.
You don’t always need to insert an entire row or
column. You can also insert a single cell, or range
of cells, into your worksheet.
1. Select a cell, or cells, adjacent to where you
want to place the new cells.
2. Choose Home > Cells > Insert (arrow) and
choose Insert Cells.
3. On the Insert dialog box (see Figure 1-20),
choose the option that will place your new
cells where you want them to be.
4. Click OK and Excel will shift the existing cells
to make room for your new cells.
Inserting a new column.
Choose the option that will place your
new cells in the correct location.
Selecting and Inserting Rows
To insert multiple rows or columns, select
an equal number of rows or columns ﬁrst
and follow the previous steps. For instance,
if you want to insert two columns, you must
ﬁrst select two columns.
Deleting Cells Is Easy
You can delete cells just as easily in Excel.
The Ribbon path for deleting cells is Home
> Cells > Delete (arrow). Then choose Delete
Cells, Delete Sheet Rows, or Delete Sheet
Columns to suit your needs.