Just select the location where you want the new cell to appear,
go to the Insert menu, choose Cells, and select "Shift cells
down" in the dialog that is displayed.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"lillysmom" wrote in
message
...
I have excel 2002 and need to shift cells down in a column
without effecting
the rest of the sheet. Please help