LibreOffice-Suite-Calc-6.3/C2/Working-with-Sheets-in-Calc/English
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:
|
Slide: System Requirements
|
This tutorial is recorded using
|
Open Personal-Finance-Tracker.ods | Let us open our Personal-Finance-Tracker.ods file that we saved in the earlier tutorial. |
Slide: Code files |
|
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
|
In our Personal-Finance-Tracker.ods file, let's click on the cell C1.
|
Click on Row icon in the Standard toolbar | Now click on the Row icon in the Standard toolbar.
|
Highlight Insert Rows Above and Insert Rows Below.
|
Notice 2 specific options Insert Rows Above and Insert Rows Below.
|
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.
|
Highlight Insert Rows Before and Insert Rows After.
|
Notice 2 specific options Insert Columns before and Insert Columns after.
|
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
|
The Insert Cells dialog box opens.
|
Click on Cancel |
Explore these options on your own for your understanding.
|
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
|
So select the cells A1 to D1 by clicking and dragging the left mouse button.
|
Click on cell B1→ Insert
|
Right-click anywhere on the selection and select Insert.
|
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.
|
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.
|
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.
|
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.
|
Narration:
|
We will now learn about how to insert and delete sheets in Calc.
|
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
|
By doing so, the Insert Sheet dialog box opens up.
|
Select Position >> Before Current Sheet
Sheet >> No. of sheets >> 2 |
Under Position, I will select Before the current sheet.
|
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.
|
Insert Sheet dialog box
|
On doing so, the Insert Sheet dialog box opens up.
|
Narration: | Next let us learn how to delete sheets.
|
Right click on Sheet 4 tab
|
To delete a single sheet, right-click on the tab of the sheet you wish to delete.
|
Point to confirmation dialog box
|
A confirmation dialog box pops up.
|
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.
|
For example, let’s rename Sheet 2 as “Dump”.
|
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
|
Press Ctrl+S keys
Press X |
Save the file by pressing Ctrl+S keys on the keyboard.
|
Narration: | This brings us to the end of this tutorial. Let us summarize. |
Slide: Summary | In this tutorial, we learnt to :* Insert and Delete
|
Slide: Assignment | As an assignment
|
Slide: About Spoken Tutorial Project |
|
Slide: Spoken Tutorial Workshops |
|
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
Thank you for watching. |