How do you insert a single cell in the middle of the table without shifting the entire row down. I just want the single cell I selected to move down one in the column.

Hi Shaunm,

Insertion of a single cell is not supported in Numbers.

You can, however, move the content of cells in and below the location where you want to 'insert' a cell, then [ace the content you want into the cell in the location where you wanted to add a cell.

• Select the target cell and all cells below it in the same column.
• Press command-x to Cut that content from the cells and place that content on the Clipboard.
• Select the cell below the target cell, then press command-V to paste the clipboard contents into the cells below the target cell. (Assuming that all cells are filled, this will result in an added row at the bottom of the table.)
• Select the target cell and enter the informaion that was to be inserted in this space.

Regards,

Barry

Here is a slightly different method. The results are different too, in a very important way.

1. Select the target cell
2. Use Shift Cmd Down Arrow to select from there to the end of the column or use Option Shift Cmd Down Arrow to select from there to the lowest cell that has something in it or select what you want with your mouse using Shift Click.
3. Click and hold on the target cell. All the selected cells will "lift" out of the table.
4. Drag them to where you want them (anywhere at all, even to a new table or to a blank spot on the canvas) and let go. If this extends off the bottom of the table, it will create new rows.

Here is the important difference in the two methods:

Suppose cell C3 has the formula =D3. You want to move cell C3 down to C4. If you Cut/Paste it down one row, the resulting formula in C4 will be =D4. If you use the lift-drag-drop method the formula will remain unchanged as =D3.

If you haven't used this method to move cells around or to rearrange rows or columns, you will soon find it to be very handy. Just select the range of cells you want to move (including entire columns or rows) and drag them to somewhere else.