Welcome to the spoken tutorial on Working with Sheets.
In this tutorial, we will learn to:
Insert and Delete Rows, Columns, Sheets
Rename Sheets and
Move Sheets
This tutorial is recorded using Ubuntu Linux OS version 18.04 and LibreOffice Suite version 6.3.5
Let us open our Personal-Finance-Tracker.ods file.
This file has been provided to you in the Code files link on this tutorial page. Please download and extract the file.
Make a copy and then use it for practising.
Columns and rows can be inserted individually or in bulk.
First we will learn how to insert a new row or a new column in the spreadsheet.
In our Personal-Finance-Tracker.ods file, let's click on the cell C1.
This cell has “Cost” written in it.
Now click on the Row icon in the Standard toolbar.
Many options related to rows are displayed in the context menu.
Notice 2 specific options Insert Rows Above and Insert Rows Below.
I will click on the option Insert Rows Above.
A new row gets inserted just above the cell C1.
Now click on the Column icon in the Standard toolbar.
Many options related to columns are displayed in the context menu.
Notice 2 specific options Insert Columns before and Insert Columns after.
I will click on the option Insert Columns Before.
A new column gets inserted to the left of the cell C1.
Let’s undo these changes.
Rows and columns can be inserted by clicking on Sheet menu in the menu bar, as well.
Another quick way to insert a new row or column is by right-clicking on any cell.
Right-click on cell C1 and click on Insert option.
The Insert Cells dialog box opens.
Here choose as per your requirement and click on the Ok button.
Explore these options on your own for your understanding.
I will skip this and click the Cancel button to close the dialog box.
Next, we’ll learn to insert multiple rows and columns at the same time.
Let’s say we want to insert 4 columns before SN which is cell A1.
So select the cells A1 to D1 by clicking and dragging the left mouse button. All the 4 cells get selected.
Right-click anywhere on the selection and select Insert.
In the Insert Cells dialog box, click on the option Entire Column.
Then click on the OK button at the bottom.
Notice that 4 new columns get added before Serial Number.
Now click any random cell to deselect.
In a similar manner, we can add multiple rows as well. Explore this on your own.
Next we will learn about how to delete columns individually and in groups.
Select any one column by clicking on the alphabet of the column above, as shown.
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.
In my case, I want to delete these 3 columns which we inserted just now.
So, select the 3 columns by clicking on the alphabet of the column above, as shown.
All the 3 columns get selected.
Now click on the Column icon in the Standard toolbar and then on Delete Columns option.
The selected columns get deleted.
In a similar manner, we can delete multiple rows as well. Explore this on your own.
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.
At the bottom left, we see a tab named Sheet 1.
There are some icons located before that.
When we click on the Plus icon, a new sheet named Sheet2 gets added.
This new sheet gets added to the right of the current one.
We can also add sheets by clicking on the empty area next to the Sheet tabs.
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.
Under Position, I will select Before the current sheet. And in No. of sheets, I will specify 2.
And then click on the OK button at the bottom.
Notice that Sheet 3 and Sheet 4 get added before Sheet 2.
Another way to insert sheets is to click on the Sheet menu in the menu bar. Then click on Insert Sheet.
On doing so, the Insert Sheet dialog box opens up.
I will skip this and click on the Cancel button at the bottom.
Next let us learn how to delete sheets.
Sheets can be deleted individually or in groups.
To delete a single sheet, right-click on the tab of the sheet you wish to delete.
And then, select the Delete Sheet option.
A confirmation dialog box pops up. Click on the Yes button.
The selected sheet gets deleted.
How can we delete multiple sheets at a time?
For example, say we want to delete Sheet 2 and Sheet 3.
First click on the Sheet 2 tab.
Then holding the Shift key on the keyboard, click on Sheet 3 tab.
Now right-click on any one of the tabs and click on the Delete Sheet option.
A confirmation dialog box pops up.
Click on the Yes button to delete the sheet. Both the sheets get deleted.
Let us undo these changes by pressing Ctrl + Z keys.
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.
For example, let’s rename Sheet 2 as “Dump”.
Do this by simply double-clicking on Sheet 2 tab.
Rename Sheet dialog box opens up.
There is a textbox with Sheet 2 written in it.
Delete this and type “Dump” as the new name.
Click on the OK button.
Sheet 2 tab has now been renamed to “Dump”.
Let us undo these changes by pressing Ctrl + Z keys.
We can manually rearrange the sheets by clicking on a sheet And dragging it to the desired location.
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.
This brings us to the end of this tutorial. Let us summarize.
In this tutorial, we learnt to :
Insert and Delete Rows, Columns, Sheets
Renaming Sheets and Move Sheets
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 files link for details.
Rename the sheet as Department-Sheet.
Save and close the file.
The video at the following link summarizes the spoken tutorial project. Please download and watch it.
The Spoken Tutorial Project Team conducts workshops and gives certificates.
For more details, please write to us.
Please post your timed queries in this forum.
Spoken Tutorial project is funded by MHRD, Govt. of India.
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.