Microsoft Works includes a spreadsheet program you can use to organize data and perform calculations. Microsoft Works Spreadsheet uses a grid-like structure for entering data (text or numbers).
The individual cells of the grid are formed by the intersection of a row with a column, so a cell is identified by a column letter followed by a row number. For example, B3 identifies the cell located at the intersection of the second column over and third row down.
Practice now by moving around the spreadsheet. After you have located several cells, end up by clicking on cell A1 to make it the current or active cell. Identifying the active cell's coordinates Look in the top left hand corner of the Excel. Create a new spreadsheet and edit it with others at the same time — from your computer, phone or tablet. Free with a Google account.
1To start a new spreadsheet choose Start→All Programs→Microsoft Works→Microsoft Works Spreadsheet.
Spreadsheet starts, and displays a blank spreadsheet.
If you're already working in Spreadsheet, you can start a new spreadsheet by choosing File→New. To open an existing spreadsheet so you can make changes to it, choose File->Open to locate and open it.
2Click in a cell.
When you click in a cell, it's surrounded by a border to show that it's active.
3Type data (text or numbers) into the cell.
Notice that what you type appears in both the cell and the Formula bar.
If your laptop doesn't include a number pad, press the Fn (Function) key on your keyboard, and then press any of the keys that display the numbers 0 through 9 next to the letters to enter those numbers.
Use the two scrollbars, the one to the right and the one at the bottom, to move vertically or horizontally through a large spreadsheet. How to open 72 files.
4Press Tab to complete the entry and move to the next cell.
You can also click the Enter button, which looks like a check mark, to complete your entry and keep the current cell active.
To make changes to a cell, click it and edit the contents displayed in the Formula bar.
Remember to save your work often to avoid losing anything. Choose File→Save, type a filename for the spreadsheet, then click Save. After saving the spreadsheet for the first time, you can keep working on it if you like; just click the Save button on the toolbar or choose File→Save to save any changes you make.
- MS Excel Basics
- Editing Worksheet
- Formatting Cells
- Formatting Worksheets
- Working with Formula
- Advanced Operations
- MS Excel Resources
- Selected Reading
Creating New Worksheet
- Editing Worksheet
- Formatting Cells
- Formatting Worksheets
- Working with Formula
- Advanced Operations
- MS Excel Resources
- Selected Reading
Creating New Worksheet
Three new blank sheets always open when you start Microsoft Excel. Below steps explain you how to create a new worksheet if you want to start another new worksheet while you are working on a worksheet, or you closed an already opened worksheet and want to start a new worksheet.
Step 1 − Right Click the Sheet Name and select Insert option.
Step 2 − Now you'll see the Insert dialog with select Worksheet option as selected from the general tab. Click the Ok button.
Convert Sheets To Excel
Now you should have your blank sheet as shown below ready to start typing your text.
Excel Formulas Sheet To Sheet
You can use a short cut to create a blank sheet anytime. Try using the Shift+F11 keys and you will see a new blank sheet similar to the above sheet is opened.
