LibreOffice-Suite-Calc-6.3/C2/Formatting-Data--in-Calc/English-timed
From Script | Spoken-Tutorial
TIME | NARRATION |
00:01 | Welcome to the spoken tutorial on Formatting Data in Calc. |
00:07 | In this tutorial, we will learn to: |
00:11 | Format cell borders and cell background colors. |
00:16 | Format multiple lines of text using Automatic Wrapping. |
00:22 | Merge cells. |
00:25 | Shrink the text to fit inside the cell. |
00:29 | This tutorial is recorded using
Ubuntu Linux OS version 18.04 and LibreOffice Suite version 6.3.5 |
00:42 | First let us learn about formatting cell borders in Calc. |
00:47 | Open our Personal Finance Tracker dot ods file. |
00:52 | Formatting of borders can be done on a particular cell or a block of cells. |
00:59 | Select the cells, A2 to G2 by holding the left mouse button. |
01:06 | Then go to the Formatting toolbar and select the Borders icon. |
01:12 | If you have resized your LibreOffice window, some of the icons may not be visible. |
01:18 | In that case, click on the double arrow icon at the end of the toolbars to see the hidden icons. |
01:27 | Click on the Borders icon. |
01:30 | A drop-down box opens up containing several border styles. |
01:35 | Click on any one of the styles you wish to apply on the borders.
I will select the last option. |
01:45 | Now click anywhere on the spreadsheet to deselect the cells. |
01:51 | Notice that the cell borders are formatted according to the selected border style. |
01:58 | Let us undo this change by pressing Ctrl+Z keys. |
02:03 | We can also do the same thing using the Format cells dialog box. |
02:09 | Right-click on the selected cells and choose Format Cells option. |
02:15 | Or press Ctrl+1 keys on the keyboard. |
02:20 | Either way, the Format Cells dialog box opens up.
Now go to the Borders tab. |
02:29 | We see the options for Line arrangement, Line, Padding and Shadow style. |
02:38 | One can change any of these as per our preference. |
02:43 | In the Line Arrangement section, we can see a small preview window named: User-defined. |
02:51 | Under Presets, I will click on the third option. |
02:56 | You can see that it gets reflected in the preview window. |
03:01 | I will also change the Style, Width and Color from the Line section, as shown. |
03:09 | From the style drop-down, I will select the dotted lines. |
03:15 | I will set the width as 2 point and select the color as Red. |
03:24 | Observe the changes in the preview window. |
03:28 | Next, go to the Padding section. |
03:32 | Observe that all the values are the same. |
03:36 | If we try to change the padding value of any one of the sides, all of them get changed. |
03:44 | This is because the Synchronize option is checked. |
03:49 | If we wish to set different values for each side. |
03:53 | Then the Synchronize option needs to be unchecked. |
03:58 | Let’s uncheck the Synchronize option. |
04:02 | I will set the padding value for Top and Bottom margins to 1.5 mm. |
04:11 | And the Left and Right margins to 1 mm. |
04:16 | You can explore the various Shadow styles on your own later. |
04:21 | Click on the OK button at the bottom. |
04:25 | Now click anywhere on the spreadsheet to deselect the cells. |
04:30 | Notice that our chosen border style is now applied to all the selected cells. |
04:37 | In our earlier tutorial, we had set one of the default styles to the headings. |
04:43 | Now let us set some other colors to the headings, using the Background Color option. |
04:50 | Now select the cells A1 to G1 by holding the left mouse button. |
04:57 | Then go to the Formatting toolbar and select the drop-down next to the Background Color icon. |
05:05 | The Background Color popup menu opens up. |
05:09 | Select the color you wish to apply as a background to the cells.
I will click on the color Orange. |
05:18 | Observe the change. |
05:21 | Now the background color for the headings is set to Orange. |
05:26 | Calc provides various options for formatting multiple lines of text. |
05:33 | One of them is Automatic Wrapping. |
05:36 | It allows a user to type multiple lines of text into a single cell. Let us try this. |
05:46 | Right-click on cell B9 and select Format Cells option. |
05:53 | Then go to the Alignment tab. |
05:57 | Under the Properties section, check the Wrap text automatically option.
Then click on the OK button at the bottom. |
06:09 | Now type the following text in cell B9. |
06:14 | “This is a personal Finance Tracker. It is very useful”.
And press Enter. |
06:23 | We see that the multiple statements get wrapped into the same cell. |
06:30 | Undo these changes by pressing Ctrl+Z keys. |
06:36 | Next we will learn how to merge cells in Calc. |
06:41 | First click on the cell with value 1 under the heading SN. |
06:47 | Now hold down the Shift key on the keyboard and click on the cell which has the word Salary. |
06:55 | The selected cells get highlighted. |
06:58 | Click on the Merge and centre cells icon in the Formatting bar. |
07:06 | Merge Cells dialog box opens up. |
07:10 | Here three options for merging the cells are displayed along with a preview.
We can select any one as per our preference. |
07:22 | I want to move the contents of both the cells into a single cell. |
07:28 | So, I will select the Move the content of hidden cells into the first cell radio button. |
07:36 | Then click on the OK button at the bottom of the dialog box. |
07:42 | Observe that the selected cells and their values are merged together. |
07:48 | Alternatively, we can merge cells by clicking on the Format menu in the menu bar. |
07:55 | From the sub-menu, go to Merge Cells and select any one preferred option.
Explore these on your own later. |
08:06 | Undo these changes by pressing Ctrl+Z keys. |
08:12 | Next we will learn how to shrink text to fit into a cell. |
08:18 | The font size of the data in a cell can be automatically adjusted to fit the data into the cell.
Let us learn how to do it. |
08:30 | First type the following text in cell B10 “This is for the month of June”. Then press Enter. |
08:41 | In order to shrink the text so that it fits, right-click on cell B10. |
08:48 | Then select the option Format Cells. |
08:53 | Format cells dialog box opens up. |
08:57 | Go to the Alignment tab. |
09:00 | Under the Properties section, click on the Shrink to fit cell size check-box. |
09:07 | Then click on the OK button at the bottom of the dialog box. |
09:13 | Observe that, the entire text inside the cell shrinks and fits within the cell. |
09:20 | It adjusts itself by decreasing its font size so that the text fits into the cell. |
09:28 | Undo the changes by pressing Ctrl+Z keys together. |
09:35 | Then save and close the file. |
09:40 | This brings us to the end of this tutorial, let us summarize. |
09:45 | In this tutorial, we learnt to: |
09:49 | Format cell borders and cell background colors. |
09:54 | Format multiple lines of text using Automatic Wrapping. |
09:59 | Merge cells and |
10:01 | Shrink the text to fit inside the cell. |
10:06 | As an assignment:
Open “spreadsheet hyphen practice dot ods” sheet. |
10:12 | Select all the headings. |
10:15 | Give Grey background color to the headings. |
10:19 | Using “Automatic Wrapping” type the text in cell A10 “This is a Department Spreadsheet”. |
10:27 | Shrink this text to fit inside cell A11. |
10:33 | The video at the following link summarizes the Spoken Tutorial project.
Please download and watch it. |
10:41 | The Spoken Tutorial Project Team conducts workshops and gives certificates.
For more details, please write to us. |
10:51 | Please post your timed queries in this forum. |
10:56 | Spoken Tutorial projects are funded by MHRD, Govt. of India. |
11:03 | This tutorial was originally contributed by DesiCrew Solutions Pvt.Ltd. in 2011.
This is Arvind along with the spoken tutorial team from IIT Bombay signing off. Thank you for watching. |