LibreOffice-Suite-Calc-6.3/C2/Working-with-Sheets-in-Calc/English - Revision history

Arvindpillai90 at 15:08, 17 July 2020

2020-07-17T15:08:17Z

Nancyvarkey at 18:01, 3 July 2020

2020-07-03T18:01:55Z

Arvindpillai90: Created page with "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..."

2020-07-03T13:11:22Z

Created page with "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..."

New page

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.

{| border="1"
|-
|| '''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 that we saved in the earlier tutorial.
|-
|| '''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''' '''from''' context menu, '''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 '''SN.'''
|-
|| 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.
|-
|| Point to new '''Columns''' inserted
|| Observe that the 3 new columns before '''SN''' gets 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 from the '''context menu''', 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'''
* Rename '''Sheets'''
* Move '''Sheets'''

|-
|| '''Slide: '''Assignment
|| As an assignment
* Open '''Spreadsheet'''-'''Practice'''.'''ods'''.
* Select and delete the column with the heading '''Serial''' '''Number'''.
* Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns
* Refer to the Code file 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.
|-
|}

@@ Line 397: / Line 397: @@
 || As an assignment
 * 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
 * Refer to the '''Code files''' link for details.

@@ Line 35: / Line 35: @@
 |-
 || Open''' Personal-Finance-Tracker.ods'''
-|| Let us open our '''Personal-Finance-Tracker.ods''' file that we saved in the earlier tutorial.
+|| Let us open our '''Personal-Finance-Tracker.ods''' file.
 |-
 || '''Slide: Code files'''
@@ Line 108: / Line 108: @@
 |-
 || Right-click on '''cell C1'''→click on '''Insert'''
-|| Right-click on '''cell C1 '''and''' '''from''' context menu, '''click on '''Insert '''option.
+|| Right-click on '''cell C1 '''and click on '''Insert '''option.
 |-
 || '''Insert Cells '''dialog box
@@ Line 159: / Line 159: @@
 |-
 || Point to new '''Columns''' inserted
-|| Notice that 4 new columns get added before '''SN.'''
+|| Notice that 4 new columns get added before '''Serial Number.'''
 |-
 || Click cell '''D6 '''
-|| Now click any random cell to deselect.
+|| Now click any random '''cell''' to deselect.
 |-
 || Only Narration
@@ Line 171: / Line 171: @@
 |-
 || Only Narration
-|| Next we will learn about how to delete '''Columns''' individually and in groups.
+|| Next we will learn about how to delete columns individually and in groups.
 |-
 || Click on column '''D'''
@@ Line 199: / Line 199: @@
 The selected columns get deleted.
-|-
-|| Point to new '''Columns''' inserted
-|| Observe that the 3 new columns before '''SN''' gets deleted.
 |-
 || Only Narration
@@ Line 234: / Line 232: @@
 |-
 || Point to the empty space besides '''Sheet''' '''2'''
-|| We can also add '''sheets''' by clicking on the empty area next to the '''sheet '''tabs.
+|| We can also add '''sheets''' by clicking on the empty area next to the '''Sheet '''tabs.
 |-
-|| '''Insert''' '''Sheet''' dialog box
+|| '''Insert Sheet''' dialog box
@@ Line 297: / Line 295: @@
-And then from the '''context menu''', select the '''Delete''' '''Sheet''' option.
+And then, select the '''Delete Sheet''' option.
 |-
 || Point to '''confirmation''' dialog box
@@ Line 370: / Line 368: @@
 |-
 || Click '''Sheet 2 '''and bring it to second position on '''Sheets''' tab
-|| We can manually rearrange the sheets by clicking on a '''sheet'''
+|| We can manually rearrange the '''sheets''' by clicking on a '''sheet'''
@@ Line 387: / Line 385: @@
 |-
 || '''Slide''': Summary
-|| In this tutorial, we learnt to :* Insert and Delete
+|| In this tutorial, we learnt to :
 ** '''Rows'''
 ** '''Columns'''
 ** '''Sheets'''
-* Rename '''Sheets'''
+* Renaming '''Sheets'''
 * Move '''Sheets'''
@@ Line 400: / Line 399: @@
 * Select and delete the column with the heading '''Serial''' '''Number'''.
 * Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns
-* Refer to the Code file link for details.
+* Refer to the '''Code files''' link for details.
-* Rename the '''sheet''' as '''Department'''-'''Sheet'''.
+* Rename the '''sheet''' as '''Department-Sheet'''.
 * Save and close the file.
@@ Line 415: / Line 414: @@
 * The Spoken Tutorial Project Team conducts workshops and gives certificates.
 * For more details, please write to us.
 |-