bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > General > Inserting Cells

Inserting Cells

Summary: Using the insert menu to add cells to an Excel table. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

As you are editing your worksheet, it not untypical that you will need to move things around. One of the most common way of doing this is to insert cells, which will result in the movement of existing cells. You can insert a cell (or cells) in your worksheet by following these steps:

  1. Select the cell or cells that indicate where you want your new cells inserted. Make sure that the number of cells you select represents the same number you want to insert. Thus, if you want to insert four cells, you would select four cells at the point where the insertion is to take place.
  2. Choose Cells from the Insert menu. The Insert dialog box is displayed. (Click here to see a related figure.)
  3. Select how you want the current cells in the worksheet affected.
  4. Click on OK. Your cells are inserted.

Tip #2656 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
 
Check out Timesheet Templates today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)