• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Inserting Cells

Inserting Cells

Click the spot in your worksheet where you want to insert a cell.

Open the Insert menu and choose Cells to open the Insert dialog box.

Select what you want to happen to the existing cells when the new cell is inserted; for example, Shift cells down, and click OK.

The existing cells shift and a new cell is inserted.

INTRODUCTION

There might be times when you are entering data into your worksheet and notice that you typed the wrong information, so that you are off by one cell in a column or row. To avoid retyping all the data again, or copying and pasting, you can insert cells and shift the current cells to their correct locations.


TIP

Using the shortcut menu

Another way to insert a cell is to right-click the spot in your worksheet where you want the new cell to appear and choose Insert from the shortcut menu that appears. The Insert dialog box opens; proceed as normal.


TIP

Using the Insert Options Format Painter smart tag

When the new cell is inserted, click the Insert Options Format Painter smart tag to apply formatting to the inserted cell. Format the new cell like the cell above it or below it, or specify that no formatting be applied.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint