| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I shift cells down in a column
I have excel 2002 and need to shift cells down in a column without effecting
the rest of the sheet. Please help |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
Have you filtered your data?
Do you have a filter in effect? If yes, data|filter|show all, then follow Chip's instructions. lillysmom wrote: 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 -- Dave Peterson |
|
#7
|
|||
|
|||
|
You are a rock star! Thanks!
"Dave Peterson" wrote: Have you filtered your data? Do you have a filter in effect? If yes, data|filter|show all, then follow Chip's instructions. lillysmom wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
| removing blank cells from a column | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Linear Mode
