How to Add Multiple Cells in Microsoft Excel 2003

Many people use spreadsheet software to track their daily accounting. New versions of popular spreadsheet programs offer the end-user a wide array of features. Among the most commonly used of those features is the ability to extend the length of a spreadsheet by inserting or adding multiple cells.

Step

Before you can add multiple cells, you need to define the area. You can easily do this by left-clicking on the desired cell and dragging the mouse cursor over the area where you wish to add cells and then releasing it. The selected area will stay highlighted.

Step

Right-click on the highlighted area to access the Cell Properties submenu.

Step

Add desired multiple cells. Scroll to “Insert” on the Cell Properties submenu and left-click to insert or add multiple cells.

Step

Set cell rotation for the addition of cells. A cell insert properties box will open, in which you can select the rotation and placement of the cells to be added. You can shift the existing cells either to the left or down to make room, all by selecting the corresponding radial button.

Step

Implement your changes. To add the multiple cells, click on the "OK" button.