Difference between revisions of "LibreOffice-Suite-Calc-6.3/C2/Working-with-Sheets-in-Calc/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
Line 397: Line 397:
 
|| As an assignment
 
|| As an assignment
 
* Open '''Spreadsheet'''-'''Practice'''.'''ods'''.
 
* Open '''Spreadsheet'''-'''Practice'''.'''ods'''.
* Select and delete the column with the heading '''Serial''' '''Number'''.
+
* Select and delete the column with the heading '''SN'''.
 
* Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns
 
* Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns
 
* Refer to the '''Code files''' link for details.
 
* Refer to the '''Code files''' link for details.

Latest revision as of 20:38, 17 July 2020

Title: Working with Sheets

Author: Arvind Pillai

Keywords: LibreOffice Calc, Sheets, Insert rows in Calc, Delete rows in Calc, Insert columns in Calc, Delete columns in Calc, Insert sheets in Calc, Delete sheets in Calc, Rename sheets in Calc, Move sheets.


VISUAL CUE NARRATION
Slide:Title Welcome to the spoken tutorial on Working with Sheets.
Slide: Learning objectives In this tutorial, we will learn to:
  • Insert and Delete
    • Rows
    • Columns
    • Sheets
  • Rename Sheets
  • Move Sheets
Slide: System Requirements


This tutorial is recorded using
  • Ubuntu Linux OS version 18.04 and
  • LibreOffice Suite version 6.3.5
Open Personal-Finance-Tracker.ods Let us open our Personal-Finance-Tracker.ods file.
Slide: Code files
  • This file has been provided to you in the Code files link on this tutorial page.
  • Pls download and extract the file.
  • Make a copy and then use it for practising.
Highlight a column and a row. Columns and rows can be inserted individually or in bulk.
Only Narration First we will learn how to insert a new row or a new column in the spreadsheet.
Click on C1



Point to “Cost

In our Personal-Finance-Tracker.ods file, let's click on the cell C1.


This cell has “Cost” written in it.

Click on Row icon in the Standard toolbar Now click on the Row icon in the Standard toolbar.


Many options related to rows are displayed in the context menu.

Highlight Insert Rows Above and Insert Rows Below.


Click on Insert Rows Above

Notice 2 specific options Insert Rows Above and Insert Rows Below.


I will click on the option Insert Rows Above.

Point to the new row added A new row gets inserted just above the cell C1.
Click on Row icon in the Standard toolbar Now click on the Column icon in the Standard toolbar.


Many options related to columns are displayed in the context menu.

Highlight Insert Rows Before and Insert Rows After.


Click on Insert Rows Before

Notice 2 specific options Insert Columns before and Insert Columns after.


I will click on the option Insert Columns Before.

Point to the new column added A new column gets inserted to the left of the cell C1.
Press CTRL + Z twice Let’s undo these changes.
Click on Sheet >> mouse over on Insert Rows and

Insert Columns to show their context menu

Rows and columns can be inserted by clicking on Sheet menu in the menu bar, as well.
Point to Cell Reference→ Numbers and Alphabets Another quick way to insert a new row or column is by right-clicking on any cell.
Right-click on cell C1→click on Insert Right-click on cell C1 and click on Insert option.
Insert Cells dialog box


Highlight Entire row & Entire column and Ok button

The Insert Cells dialog box opens.


Here choose as per your requirement and click on the Ok button.



Click on Cancel

Explore these options on your own for your understanding.


I will skip this and click the Cancel button to close the dialog box.

Only narration Next, we’ll learn to insert multiple rows and columns at the same time.
Point to SN i.e A1 Let’s say we want to insert 4 columns before SN which is cell A1.
Holding the left mouse key click and drag from cells A1 to D1


Point to Cells A1 to D1

So select the cells A1 to D1 by clicking and dragging the left mouse button.


All the 4 cells get selected.

Click on cell B1 Insert


Insert Cells dialog box >> click Entire Column

Right-click anywhere on the selection and select Insert.


In the Insert Cells dialog box, click on the option Entire Column.

Click Ok Then click on the OK button at the bottom.
Point to new Columns inserted Notice that 4 new columns get added before Serial Number.
Click cell D6 Now click any random cell to deselect.
Only Narration In a similar manner, we can add multiple rows as well.


Explore this on your own.

Only Narration Next we will learn about how to delete columns individually and in groups.
Click on column D Select any one column by clicking on the alphabet of the column above, as shown.
Click Column icon in the Standard toolbar >> click Delete Columns. Now click on the Column icon in the Standard toolbar and then on Delete Columns option.


The selected column gets deleted.

Suppose we want to delete more than one column at a time.
Point to the 3 columns In my case, I want to delete these 3 columns which we inserted just now.
Select columns A to C So, select the 3 columns by clicking on the alphabet of the column above, as shown.
Point to the 3 Columns All the 3 columns get selected.
Click the Column icon in the Standard toolbar >> click Delete Columns. Now click on the Column icon in the Standard toolbar and then on Delete Columns option.


The selected columns get deleted.

Only Narration In a similar manner, we can delete multiple rows as well.


Explore this on your own.

Narration:


We will now learn about how to insert and delete sheets in Calc.


There are several ways to insert a new sheet in Calc.


We will learn about each one of them one-by-one.

Point to Sheet 1 at the bottom left At the bottom left, we see a tab named Sheet 1.
Highlight all the icons located before that. There are some icons located before that.
Point to + icon before Sheet 1 >> then click on it When we click on the Plus icon, a new sheet named Sheet2 gets added.
Point to Sheet 2 This new sheet gets added to the right of the current one.
Point to the empty space besides Sheet 2 We can also add sheets by clicking on the empty area next to the Sheet tabs.
Insert Sheet dialog box


Point to Position options



Point to Sheet >> No. of sheets option

By doing so, the Insert Sheet dialog box opens up.


Using this dialog box, we can add a sheet before or after the current sheet.


We can also add any no. of sheets at a time.

Select Position >> Before Current Sheet

Sheet >> No. of sheets >> 2

Under Position, I will select Before the current sheet.


And in No. of sheets, I will specify 2.

Click on Ok button And then click on the OK button at the bottom.
Highlight the sheet tab Notice that Sheet 3 and Sheet 4 get added before Sheet 2.
Click on Sheet >>Click on Insert Sheet Another way to insert sheets is to click on the Sheet menu in the menu bar.


Then click on Insert Sheet.

Insert Sheet dialog box


Click on Cancel button

On doing so, the Insert Sheet dialog box opens up.


I will skip this and click on the Cancel button at the bottom.

Narration: Next let us learn how to delete sheets.


Sheets can be deleted individually or in groups.

Right click on Sheet 4 tab



Select Delete Sheet

To delete a single sheet, right-click on the tab of the sheet you wish to delete.


And then, select the Delete Sheet option.

Point to confirmation dialog box


Click Yes

A confirmation dialog box pops up.


Click on the Yes button.

Point to Sheets tab The selected sheet gets deleted.
How can we delete multiple sheets at a time?
Point to Sheet 2 and Sheet 3 For example, say we want to delete Sheet 2 and Sheet 3.
Click on Sheet 2 tab First click on the Sheet 2 tab.
Hold Shift key >> click on Sheet 3 tab. Then holding the Shift key on the keyboard, click on Sheet 3 tab.
Right click >> Delete Sheet Now right-click on any one of the tabs and click on the Delete Sheet option.
Confirmation dialog box A confirmation dialog box pops up.
Click Yes button Click on the Yes button to delete the sheet.

Both the sheets get deleted.

Press CTRL + Z keys once Let us undo these changes by pressing Ctrl + Z keys.
Point to Sheet 1, Sheet 2, Sheet 3. Sheets are named by default as Sheet 1, Sheet 2, Sheet 3 and likewise.

Calc has a provision to rename the sheets based on our needs.

Point to the Sheet 2 tab below.


Double click on Sheet 3 tab.

For example, let’s rename Sheet 2 as “Dump”.


Do this by simply double-clicking on Sheet 2 tab.

Rename Sheet dialog box Rename Sheet dialog box opens up.
Point to the text box Sheet 2 There is a textbox with Sheet 2 written in it.
Delete Sheet 2 written in the text box and write “Dump”. Delete this and type “Dump” as the new name.
Click on OK Click on the OK button.
Point to the Sheet 2 tab below. Sheet 2 tab has now been renamed to “Dump”.
Press CTRL + Z keys once Let us undo these changes by pressing Ctrl + Z keys.
Click Sheet 2 and bring it to second position on Sheets tab We can manually rearrange the sheets by clicking on a sheet


And dragging it to the desired location.

Press Ctrl+S keys

Press X

Save the file by pressing Ctrl+S keys on the keyboard.


Now close the file by clicking the X icon on the top right corner.

Narration: This brings us to the end of this tutorial. Let us summarize.
Slide: Summary In this tutorial, we learnt to :
  • Insert and Delete
    • Rows
    • Columns
    • Sheets
  • Renaming Sheets
  • Move Sheets
Slide: Assignment As an assignment
  • Open Spreadsheet-Practice.ods.
  • Select and delete the column with the heading SN.
  • Enter relevant data in Name, Department and Salary columns
  • Refer to the Code files link for details.
  • Rename the sheet as Department-Sheet.
  • Save and close the file.
Slide: About Spoken Tutorial Project
  • The video at the following link summarizes the spoken tutorial project.
  • Please download and watch it.
Slide: Spoken Tutorial Workshops
  • The Spoken Tutorial Project Team conducts workshops and gives certificates.
  • For more details, please write to us.
Slide: Forum Please post your timed queries in this forum.
Slide: Acknowledgement Spoken Tutorial project is funded by MHRD, Govt. of India.
Slide: Thank you

Acknowledgement to DesiCrew

This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011


This is Arvind along with Spoken Tutorial team from IIT Bombay signing off.

Thank you for watching.

Contributors and Content Editors

Arvindpillai90, Nancyvarkey