Basic Cell Formatting in Calc.mp4 скачать в хорошем качестве

Basic Cell Formatting in Calc.mp4

http://openofficevideo.com how to do basic cell formatting in Calc Transcript: Welcome to OpenOffice video. My name is Maarten and I am going to show you today how to do basic formatting to cells in Calc. We have here a pretty random data set that I just made up, to serve as an example. It is supposed to be Sales, Profit and Complaints figures for a company. We have a number of columns, with data in them. We have titles for the columns and here we have the rows which are 12 months, I think 11 this time, apparently the company shut down in December. The first thing I want to show you is a very useful function. A lot of common series are built-in into Calc. For example, it understands months of the year. So I just start in January and if I now go with the mouse to the corner of the cell, until the mouse pointer becomes a + sign, and click the left mouse button, and I drag down, you see what it is going to do -it is going to add months. Saves a lot of typing and a lot of type bugs as well. So that's a very useful trick. Now let's say we want to make a neat little table to include in our report to the company Director. The cell boundaries you see here, are, on the monitor a bit grayish, but once you print them, they disapper. So we want to make a nice table. What we do is, we select the entire table, and we go to this -function-Borders. There is a number of pictures here that delineate where it will put the lines on the selection that I just created. The most simple one is -all cell borders to be aligned. Now you see every single cell has a line. Let's say for the header we don't want lines in between, we just want the outside to be delineated. Then we click here, and now we select the first one, and now you see the lines in between the cells here are light gray so they won't show up. There's a whole lot of options you can select here for the whole table or for a single cell. Just remember that it will only adjust the cell border for the cells you have selected. To make this a neat table, we can do a number of things. As you see here, the title of this column is too wide, there are too many letters in here to fit in the cell. So we will adjust the cell width. We can do this in a number of ways. The easiest one is to just move the mouse pointer over the separation between the columns over the letters and you will see it will change to the sign for adjusting the width. We have this sign and we click the left mouse button, we hold it and we can adjust it. Let's say we want to stretch it a little bit. We can also have it adjust automatically -we can just put it here and double-click, it will adjust like this. Now we want to have the titles of these columns nice in the middle. We select this one and we click "Align Center Horizontally". Here the same, we select it and we click "Align Center Horizontally", and we do the same thing here which doesn't have a lot of effect. Alright, that was the basics for how to format cells. I hope you enjoyed this video and you find it helpful. If you have any questions, please leave them in the comments. Until next time. Bye.