I checked to make sure the sheet is unprotected, but the cell option is still
grayed. I do only want to move the cell not the entire row.

"Chip Pearson" wrote:

If the Cells option is grayed out, it is probably because the
worksheet is protected. Unprotect the sheet and you should be
able to insert cells. To move all the cells down, go to the
Insert menu and choose Row.


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


"lillysmom" wrote in
message
...
The "cells" option isn't available (grayed out) and did I
mention that I
wanted to move all of the data in the cells down?

"Chip Pearson" wrote:

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