answersLogoWhite

0


Best Answer

Select the cell where you want the new cell to be. Right click and pick insert, and there will be a shift cells down option which will do it for you.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How to insert a cell and shift remaining cells down?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you insert a new cell in excel?

Right-click then select ''Insert" and choose shift cells to right or shift cells down, depending on what way you want to do it.


What short-cut key do you use to insert a cell or range of cells?

Ctrl+Shift+=


Used to insert a cell or range of cells?

insert cells command


How can you move from one cell to another in Excel?

You can use the Cut and Paste option. There are various ways of doing this, like using Ctrl - X to cut, or picking it off the Edit Menu or off the shortcut menu by right clicking on the mouse or by doing Alt - E - T. Paste can be done in several corresponding ways, with the key controls being Ctrl - V or Alt - E - P. You can also move a cell by putting the cursor on the edge of a cell or a group of selected cells and then dragging them. You can also do this when also hold Shift, in which case they will be inserted into a new location rather than overwriting cells that they are moved to.


What on the insert gallery of the insert button on the ribbon allows you to insert a single cell or range of cells?

Cells Command


On insert gallery used to insert a cell or range of cells?

the button used to move the contents of a cell to the right three cells


How do you insert brackets in cells?

To insert a bracket in a cell, you just press the [ or ] key.If you are trying to enter braces { or } (usually Shift-[ and Shift-]) to indicate an array formula, you use a special procedure:Type your array formula in a cell.Press CTRL+SHIFT+ENTER.If you edit the formula, you need to press Press CTRL+SHIFT+ENTER again to let Excel know you want an array formula.


What is it called when you shift data within a cell and insert space between the cell border and its content?

It could be called centering.


What key do use to insert current time in a worksheet cell?

Ctrl - shift and the colon key. So it would be Ctrl - Shift - : Without the Shift it will give you the current date.


What happens to cell references when you insert new rows or columns?

The following rows or columns shift down


How do you name a selected cell IN EXCEL 2003?

Select the cell or cells you want. Go to the Insert menu, then pick Name, and then pick Define. You can then give the cell or cells the name you want.


Describe how animal cells can be transformed by directly injecting DNA?

It is much like doing it with plant cells. You insert DNA into the egg cell. Then once in the cell the enzymes usually responsible for DNA repair help insert forein DNA into the chromosomes of the cells that have been injected.:)