Difference between revisions of "LibreOffice-Suite-Calc/C2/Formatting-Data/English"

Title Slide

Learning objectives

Formatting Borders, background colors. Formatting multiple lines of text using Automatic Wrapping. Merging Cells. Shrinking text to fit the cell.

Formatting Borders, background colors. Formatting multiple lines of text using Automatic Wrapping. Merging Cells. Shrinking text to fit the cell.

OS and versions

Open “personal finance tracker.ods” file.

Let us open our “personal finance tracker.ods” file.

Point to “SN”, “Item”, “Cost”, “Spent”, “Received”, “Date”, “Account”

For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date”, ”Account”.

Now hold down the left mouse button and drag it along the cells containing the headings.

After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar.

Now hold down the left mouse button and drag it along the cells containing the headings.

After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar.

Click on the last border style option.

Press “CTRL + Z”.

Click on one of the styles you want to apply on the borders. I will click on the last option.

We see that the borders get formatted according to our selected style.

Let us undo this change.

Right-click → click on “Format Cells” .

Click on the “Borders” tab. Point to “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”.

Now click on the “Borders” tab. You will see the options for “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”. Displayed in each of these are the default settings of Calc. But one can change any of these to suit our requirement.

Click on the third option under “Default” → Point to the preview window.

Click on “Style” and choose dotted line. Click on “Width” and choose 2.00pt. Click on “Color” and choose “Turquoise”.

Point to the preview window.

I will choose the third option under “Default” and you can see that it is reflected in the preview window.

I will also change the “Style”, “Width” and “Color”.

Again notice the change in the preview window.

Click on any one of the scroll counters and increase the spacing pt to “2.4pt”. Point and show that Bottom, Top, Right, Left margins have changed.

Un-check “Synchronize” option check-box. Click on “Top” and “Bottom” scroll counters and decrease the spacing pt to “1.4pt”.

One can uncheck it and change the margin spacing as per the requirement. I will change “Top” and “Bottom” margins to 1.4pt.

I will leave you to explore the various Shadow styles, on your own.

Click on a cell below to display the changes to the selected cells.

This will apply the chosen style to the selected cells.

For example, let us give a background color to the cells containing the headings.

Hold down left mouse button and select cells that have the headings.

Click on “Background Color” in the Formatting toolbar.

Point to the drop-down colour pallette.

Click on “Grey”.

Point to the cells in grey color.

Now hold down the left mouse button and drag it along the cells containing the headings.

After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting toolbar.

A pop up menu opens up where you can select the color you want to apply as a background.

Let us click on “Grey” color.

You can see that the cell background for the headings turns grey.

The first one is by using “Automatic Wrapping”.

“Automatic Wrapping” allows a user to enter multiple lines of text into a single cell.

Click on cell referenced as “B12”->do right click on the cell->click on “Format Cells”

Now in our “personal finance tracker.ods” sheet, let us click on a empty cell.

For example lets click on cell number “B12”.

Now do a right click on cell and then click on the “Format Cells” option.

Click on “Wrap text automatically”->click on “OK”

At the bottom of the dialog box click on the “Wrap text automatically” option and then click on the “OK” button.

UNDO the action.

You see that the multiple statements get wrapped in a single cell.

Lets undo the changes

Hold down the “Shift” button->click on “Salary”->leave “Shift” button.

Now hold down the “Shift” key on the keyboard and click on the cell with its corresponding item, “Salary”.

This highlights the two cells that are to be merged.

Click on “Yes”.

In the sidebar which pops up, click on the “Merge Cells” option.

In order to move the contents of both the cells in a single cell, click on the “Yes” option in the dialog box which appears.

Undo the action performed.

Now let us undo the merging we did by clicking on the “undo” option in the toolbar or by pressing “CTRL+Z” together.

The font size of the data in a cell can be automatically adjusted to fit into a cell.

Let us learn how to do it.

Click on cell “B14”

You see that the text doesn't fit into the cell.

In order to shrink the text so that it fits, click on the cell referenced as B14 first.

Click on “Alignment” tab.

Click on “Shrink to fit cell size”->click on “OK”.

You see that the “Format Cells” dialog box opens. Click on the “Alignment” tab in the dialog box.

At the bottom of the dialog box, click on the “Shrink to fit cell size” check-box and then click on the “OK” button.

UNDO the action

Lets undo the changes

SUMMARY

Formatting Borders, background colors in Calc. Formatting multiple lines of text using Automatic Wrapping. Merging Cells. Shrinking text to fit the cell.

To summarize, we learned about: Formatting Borders, background colors in Calc. Formatting multiple lines of text using Automatic Wrapping. Merging Cells. Shrinking text to fit the cell.

COMPREHENSIVE ASSIGNMENT

Open “spreadsheet practice.ods” sheet. Select all the headings. Give the background color to the headings as blue. Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”. Shrink this text to fit in the cell.

About the Spoken Tutorial Project

• Watch the video available at http://spoken-tutorial.org/What_is_a_Spoken_Tutorial

• It summarises the Spoken Tutorial project

• If you do not have good bandwidth, you can download and watch it

• Watch the video available at the following link

• It summarises the Spoken Tutorial project

• If you do not have good bandwidth, you can download and watch it

Spoken Tutorial Workshops

The Spoken Tutorial Project Team

• Conducts workshops using spoken tutorials

• Gives certificates for those who pass an online test

• For more details, please write to contact@spoken-tutorial.org

The Spoken Tutorial Project Team

• Conducts workshops using spoken tutorials

• Gives certificates for those who pass an online test

• For more details, please write to contact at spoken hyphen tutorial dot org

Acknowledgements

• Spoken Tutorial Project is a part of the Talk to a Teacher project

• It is supported by the National Mission on Education through ICT, MHRD, Government of India

• More information on this Mission is available at

• http://spoken-tutorial.org/NMEICT-Intro

• Spoken Tutorial Project is a part of the Talk to a Teacher project

• It is supported by the National Mission on Education through ICT, MHRD, Government of India

• More information on this Mission is available at

• spoken hyphen tutorial dot org slash NMEICT hyphen Intro

About the contributor This tutorial has been contributed by ...............................(Name of the translator and narrator)

Thanks for joining

This tutorial has been contributed by ...............................(Name of the translator and narrator)

Thanks for joining