Starting a New Spreadsheet and Entering Data

There are a few ways to start a new spreadsheet. If you are already working in Writer (as I am right now), you can click File on the menu bar, move your mouse to the New submenu, and select Spreadsheet from the drop-down list. Another way is to click the application starter (the big K) and select Calc from the or Office menu. When Calc starts up, you'll see a blank sheet of cells, as in Figure 14-1.

Figure 14-1. Starting with a clean sheet.


Directly below the menu bar is the Function bar. As with Writer, the icons here give you access to the common functions found throughout, such as cut, paste, open, save, and so on. Below the Function bar is the Object bar. Some features here are similar to those in Writer, such as font style and size, but others are specific to formatting content in a spreadsheet (percentage, decimal places, frame border, etc.).

Finally, below the Object bar you'll find the Formula bar. The first field here displays the current cell but you can also enter a cell number here to jump to that cell. You can move around from cell to cell by using your cursor keys, <Tab> (and <Shift+Tab>) key, or simply by clicking on a particular cell. The current cell you are working on will have a bold black outline around it.