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: 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