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.
Things You'll Need
- Microsoft Excel 2003
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.
Right-click on the highlighted area to access the Cell Properties submenu.
Add desired multiple cells. Scroll to “Insert” on the Cell Properties submenu and left-click to insert or add multiple cells.
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.
Implement your changes. To add the multiple cells, click on the "OK" button.
Tips & Warnings
- This feature is great for adding lines to an invoice or lengthening a spreadsheet as desired while carrying over the same properties.
- Adding multiple cells inside of cells that are either merged or carry a formula will un-merge said cells and disrupt any existing formulas.