Removing Data

[Guest]

I have a spreadsheet with data on half and data history on the other half, I
need to delete the data on the 2006 and leave the 2005 data, however it is on
the same row. When it comes to inserting I have the same problem. It is a
spreadsheet seperated by a column.

 

[Dave Peterson]

First, I'd put that data on two separate worksheets or even add a column to
serve as an indicator and make it one giant list.

But you can select your range (not the whole row!) and
edit|delete|Shift cells up

Or
Insert|Cells|Shift cells down

You can get to both of those options by selecting the range
then rightclicking on that range
and choosing either Insert or Delete

But either two separate worksheets or a combined list would be much easier (my
opinion).