Thursday, August 25, 2011

How to Create a Spreadsheet on Microsoft Excel


Using Microsoft Excel 2003 or earlier
1. Open Microsoft Excel.
2. Click 'File' in the top menu bar and select 'New.'
3. Select the 'General' tab and double-click the 'Workbook' item to create a blank spreadsheet. Alternately, select the 'Spreadsheet Solutions' tab to view the program's default templates. Create a new spreadsheet based on a template by double-clicking its icon.
4. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.
5. Click 'File' and select 'Save.' Give the file a name, select a save location, and click 'Save' to complete the process.
Using Microsoft Excel 2007
6. Open Microsoft Excel.
7. Click the round 'Office' button at the top-left corner of the window and select 'New.'
8. Select the 'Blank and recent' tab and double-click the 'Blank Workbook' item to create a blank spreadsheet. Alternately, select any tab below the 'Microsoft Office Online' heading to view templates by category (e.g., 'Calendars,' 'Expense Reports,' 'Inventories'). Create a new spreadsheet based on a template by double-clicking its icon.
9. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.
10. Click the 'Office' button and select 'Save.' Give the file a name, select a save location and click 'Save' to complete the process.

Blogger news