Tuesday, May 17, 2011

How to Make a Spreadsheet in Excel 2003


1. Launch Excel 2003 and open a blank document. Click the 'File' menu and select the 'New' option, which opens a task pane to the right of the screen. Click the 'Blank Workbook' link in the 'New' section.
2. Enter your desired data into the individual spreadsheet cells. You may input text or numbers into cells. Format your data, as necessary, by highlighting the appropriate cells and clicking the 'Format' menu. Select the 'Cells' option to open a separate window. Click one of the options in the 'Category' section of the 'Number' tab -- for example, 'Number' to format the data in the selected cells.
3. Use preformatted formulas to calculate data in the spreadsheet. Select a blank cell and click the 'Insert Function' button to the left of the 'Formula Bar,' which opens a separate dialog window. Select a function, such as 'SUM,' from the Insert Function menu and click the 'OK' button. Select the cells that you want to use your formula, according to the required information to complete the selected formula. Click the 'OK' button.
4. Save your spreadsheet. Click the 'File' menu and select the 'Save As' option; select a folder in the resulting dialog window in which to save the XLS file using the 'Look in' menu. Type a name for the file in the 'File name' field and click the 'Save' button.

Blogger news