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.
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.
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.