Monday, July 18, 2011

How to Add Cells in Excel


Add Blank Cells to an Excel Spreadsheet
1. Highlight the location for the new cells.
2. Click on a cell and drag the mouse until all the cells in the location have been highlighted. The number of cells you select should be equal to the number of cells you want to add.
3. Click on 'Insert' on the toolbar and select 'cells' from the menu.
4. Select 'Shift cells right' or 'Shift cells down.' 'Shift cells right' will move the data in the cells you have selected to the right and put new cells where the old data used to be, while 'Shift cells down' will move the data down, making space for the new cells above.
Create Totals on a Worksheet
5. Enter data in your worksheet. Type in the figures you want to calculate in a column or a row.
6. Click on the cell where you want the sum total to appear. This is usually the blank cell beneath, or on the side of, the last cell containing data.
7. Click the 'Autosum' button on the toolbar to add the numbers. This will display a formula for the calculation that corresponds to the cells in the range. You can manually adjust the formula if you want to remove some of the cells or include others.
8. Press the 'Enter' key to accept the formula and proceed with the calculation. The sum of the figures will appear in the cell.
9. Find more help on how to add cells on Excel at Microsoft.com. The 'Help and How-to' home page lists the different versions of Microsoft Office products (see Resources below). You can search for information that is specific to your version of Excel.

Blogger news