How do I shift cells down in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have excel 2002 and need to shift cells down in a column without effecting
the rest of the sheet. Please help
 
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


message
news:D[email protected]...
 
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?
 
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


message
 
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.
 
Have you filtered your data?

Do you have a filter in effect?

If yes, data|filter|show all, then follow Chip's instructions.
 
You are a rock star! Thanks!

Dave Peterson said:
Have you filtered your data?

Do you have a filter in effect?

If yes, data|filter|show all, then follow Chip's instructions.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can only delete an entire row not a cell in excel 2013? 1
How do I shift cells down in Excel? 1
"cannot shift objects off sheet" error 8
Excel Staff Grade and Shift 0
Formula Audit mode active in one column only; cannot kill. 2
Need cell color to equal text 8
shift and down keys in macro 3
shifting cells disabled. 2

Back
Top