|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: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.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.00 pt. 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-practice.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.|
| 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.