Frequently you will discover that you have left out a row or column, or you wish to remove one.  All is not lost.  You do not have to start from the beginning.

To INSERT a row or column, do the following:

insertSelect the Insert/Row or Column menu item.  Excel will insert the row or column immediately before the currently selected row or column, moving everything aside to make room for it.

If you decide that this was NOT what you wanted to do, don«t forget the UNDO button on the toolbar - just undo the last action.

While we«re here, notice that this is the menu which allows you to insert Charts, Functions, Pictures and even Hyperlinks into your spreadsheet.  More on these later (and more on the mysterious "Name" function also).

Deleting a row or column can be done by selecting the Edit/Delete... menu option, and then selecting either "Row" or "Column" from the dialog box which then appears.

NB
There is no practice task associated with this lesson, so you can proceed directly to the next lesson.

Inserting rows and columns
Home
Revision
Functions (1)
Functions (2)
Editing
Charting
Customize