You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

How to lock cells in Excel. 1. Select your whole sheet, done most easily by pressing Crtl + A on your PC keyboard, or Command + A on a Mac.. 2. In the "Home" tab, click on the arrow under ...