There are exterior sites that have templates as well. You can find templates for graph paper, budget sheets, amortization schedules, grocery lists and even a Sudoku game! Just like in Writer, has loads of templates for use in Calc. Conveniently, there's usually more than one way to do something. You can delete that text, or you can cancel out of that, go back to the header tab and uncheck the 'Header On' box. There is a button that says 'Edit.' Click that one and you will see a chart showing items displayed in the header of your document. Now, if you've gone to print your spreadsheet, and it says 'Sheet 1' at the top - and you don't know who put it there - you should go to Format > Page and choose the 'Header' tab. Therefore, I use an extra column to the left of my numbers so I can put the dollar signs where I want them. Why? Because when you format them as currency, each number includes the currency label you choose, and I only want my dollar signs at the top and bottom of each series, not on every amount. I format them as numbers rather than currency. In a financial worksheet, I like them all to have two decimal points and a comma for the thousands place.
In the same formatting box, the tabs across the top include 'Number.' This is where you can format numbers to look the way you want them. You will get a drop down with several choices. If you only have a few places you want the borders to go, you can highlight the cells and use the Borders button on the toolbar (in my example, the borders button is in the bottom row of tools to the left of the background color button). You can get close, but if you want several of them the same width or height, you're more accurate highlighting the ones you want to change and using the format menu. Click on Format > Rows > Row Height (or Format > Column > Column Width) to change the size of the row or column - or if your hands are very steady, you can 'grab' the row border at the bottom of the box with the row number in it, or the column border at the right of the letter, and drag it to suit you. I also made the row height smaller, so that my cells would look like a colored border. I highlighted 5 cells, then clicked on the background color button on the toolbar, and chose a light blue. You can make your document a little prettier, if you wish, by putting colored backgrounds in some of the cells. You can also get the same list from the fn button to the left of the formula bar. The Insert > Function menu has a list of formulas you can use. In the example above, the formula is =SUM(E4:E11) which means that the numbers in cells E4 through E11 will be added together and the answer displayed in E12 (which is the cell where the formula is located.) In a budget, for example, we could add our income and bills separately, then put a formula in a third cell which would stand for the difference between incoming and outgoing cash to let us know our month-end balance. If you are doing a spreadsheet with mathematical calculations in it (like the number sum above), it will show the formula for getting that answer. If you have numbers or text in the cell, the formula bar will show what is there. The formula bar has the characters that are in the cell you have selected.
You can also display a graph to go with your data if appropriate. Also, two sorting buttons are in the top row to sort your data alphabetically, or reverse. Instead of editing text, you can choose a filler color for the cells you have highlighted. You can highlight cells and format them as currency, add or subtract a decimal place from your numbers or put borders around specific cells. Instead of the numbering and bullet buttons that are used in Writer, you will have buttons for changing cell contents. The formatting toolbar is different in places.
The main toolbar has all the standard features, like cut & paste, save, open, new, print, etc. The toolbars are almost identical to those found in OO Writer however, some of the individual buttons are different. This will be a very basic review, because there are many things that Calc can do that I've never used. When you open it, you will have an empty spreadsheet grid for whatever data you want to organize. This month we'll look at some of the basics of OpenOffice Calc, which is the spreadsheet program in the OpenOffice suite. We have looked at OpenOffice Writer, covering some of the basics of the program and what was included.
0 kommentar(er)
