how to put in alphabetical cells in openoffice excel

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.

How to put in alphabetical cells in openoffice excel