Difference between revisions of "LibreOffice-Suite-Calc-6.3/C2/Viewing-and-printing-a-spreadsheet-in-Calc/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with "Title: Viewing and Printing Spreadsheet document Author: Arvind Pillai Novice Reviewer: Pooja, Nikita and Manish Domain Review: Nancy, Praveen Keywords: libreoffice, Calc...")
 
 
Line 54: Line 54:
  
 
|-
 
|-
|| Point to Column B>>Point to Miscellaneous  
+
|| Point to Column B >> Point to Miscellaneous  
 
+
 
+
 
|| Notice that some part of the text is not readable inside column '''B'''.
 
|| Notice that some part of the text is not readable inside column '''B'''.
 
|-
 
|-
Line 65: Line 63:
 
|-
 
|-
 
|| Place cursor on '''B''' column header
 
|| Place cursor on '''B''' column header
 
 
 
 
 
 
|| Place the cursor on the right edge on column header '''B.'''  
 
|| Place the cursor on the right edge on column header '''B.'''  
  
Line 76: Line 69:
 
|-
 
|-
 
|| Left click and drag towards left.
 
|| Left click and drag towards left.
 
 
 
 
 
 
  
  
 
Point to the Data
 
Point to the Data
 
|| Now click and hold the left mouse button.  
 
|| Now click and hold the left mouse button.  
 
  
 
Drag a little towards the right side as shown to increase the width of column '''B'''.
 
Drag a little towards the right side as shown to increase the width of column '''B'''.
 
  
 
Now, we can see all the text of column '''B '''clearly.
 
Now, we can see all the text of column '''B '''clearly.
Line 120: Line 105:
 
|-
 
|-
 
|| Scroll down  
 
|| Scroll down  
 
  
 
Point to the dotted lines
 
Point to the dotted lines
 
 
 
 
  
 
|| Scroll down until you see a horizontal dotted line.
 
|| Scroll down until you see a horizontal dotted line.
 
  
 
In my case the dotted line is passing between row number 50 and 51.
 
In my case the dotted line is passing between row number 50 and 51.
 
  
 
In your case it may vary.
 
In your case it may vary.
 
  
 
This indicates the bottom page margin.
 
This indicates the bottom page margin.
Line 164: Line 141:
 
|-
 
|-
 
|| Click on cell '''G10'''
 
|| Click on cell '''G10'''
 
 
 
  
 
Scroll down to''' row no. 51'''
 
Scroll down to''' row no. 51'''
 
|| Click anywhere outside the selection area to deselect the '''cells'''.
 
|| Click anywhere outside the selection area to deselect the '''cells'''.
 
  
 
Now I will scroll down to row number 51.
 
Now I will scroll down to row number 51.
 
  
 
You should scroll down to the row number where your bottom page margin is seen.
 
You should scroll down to the row number where your bottom page margin is seen.
Line 181: Line 153:
 
|-
 
|-
 
|| Click anywhere on the page to deselect cells
 
|| Click anywhere on the page to deselect cells
 
  
 
Scroll up and press '''Esc'''
 
Scroll up and press '''Esc'''
 
|| Click anywhere outside the selection area to deselect the '''cells'''.
 
|| Click anywhere outside the selection area to deselect the '''cells'''.
 
  
 
Scroll up and press the '''Escape''' key to remove the dotted line selection.
 
Scroll up and press the '''Escape''' key to remove the dotted line selection.
Line 196: Line 166:
 
|-
 
|-
 
|| Scroll upwards and downwards.
 
|| Scroll upwards and downwards.
 
 
 
  
 
Point to '''Page 2 '''and''' Page 1'''
 
Point to '''Page 2 '''and''' Page 1'''
 
 
 
  
 
Point to '''Page 3 '''and''' Page 4'''
 
Point to '''Page 3 '''and''' Page 4'''
 
|| Scroll the page down and up to see the page breaks.
 
|| Scroll the page down and up to see the page breaks.
 
  
 
We can see a new page with the watermark '''Page''' '''2''' below '''Page''' '''1.'''
 
We can see a new page with the watermark '''Page''' '''2''' below '''Page''' '''1.'''
 
  
 
We can also see '''Page 4 '''below '''Page''' '''3''' adjacent to these pages.
 
We can also see '''Page 4 '''below '''Page''' '''3''' adjacent to these pages.
Line 225: Line 187:
 
|| Only Narration  
 
|| Only Narration  
 
|| The '''Full screen''' mode is useful for editing '''spreadsheets'''.
 
|| The '''Full screen''' mode is useful for editing '''spreadsheets'''.
 
  
 
It’s also useful for projecting them on a projector.
 
It’s also useful for projecting them on a projector.
Line 273: Line 234:
  
 
Point to '''Top to bottom, then right'''  
 
Point to '''Top to bottom, then right'''  
 
  
 
The red arrows should indicate the И flow of pages
 
The red arrows should indicate the И flow of pages
 
|| Under''' Page Order''', we see that '''Top to bottom, then right''' is selected.
 
|| Under''' Page Order''', we see that '''Top to bottom, then right''' is selected.
 
  
 
Recall, that’s exactly how our pages are displayed in the '''Page break''' view.
 
Recall, that’s exactly how our pages are displayed in the '''Page break''' view.
 +
 +
 
|-
 
|-
 
|| Click on '''Left to right, then bottom'''
 
|| Click on '''Left to right, then bottom'''
Line 299: Line 260:
 
|-
 
|-
 
|| Highlight the '''Zoom''' '''slider''' at the bottom right corner  
 
|| Highlight the '''Zoom''' '''slider''' at the bottom right corner  
|| The easiest way to zoom or magnify a '''spreadsheet''' is to use the '''Zoom''' slider.
 
  
 +
 +
|| The easiest way to zoom or magnify a '''spreadsheet''' is to use the '''Zoom''' slider.
  
 
This is located at the bottom right corner of the '''Calc''' window.
 
This is located at the bottom right corner of the '''Calc''' window.
Line 318: Line 280:
 
|-
 
|-
 
|| Click on '''View''' >> '''Zoom'''
 
|| Click on '''View''' >> '''Zoom'''
 
 
 
  
 
Point to option
 
Point to option
 
 
 
  
 
Click on '''Optimal''' '''View'''
 
Click on '''Optimal''' '''View'''
 
|| Click on the '''View menu''' in the '''menu bar''' and click on '''Zoom'''.  
 
|| Click on the '''View menu''' in the '''menu bar''' and click on '''Zoom'''.  
 
  
 
A few more options are displayed in the context menu.
 
A few more options are displayed in the context menu.
 
  
 
Here select '''Optimal''' '''View'''.
 
Here select '''Optimal''' '''View'''.
Line 340: Line 294:
 
|-
 
|-
 
|| Click on '''View''' >> '''Zoom'''
 
|| Click on '''View''' >> '''Zoom'''
 
 
 
  
 
Click on '''Zoom'''
 
Click on '''Zoom'''
 
|| Again click on '''View''' '''menu''' in the '''menu bar''' and then on the '''Zoom''' option.
 
|| Again click on '''View''' '''menu''' in the '''menu bar''' and then on the '''Zoom''' option.
 
  
 
This time from the context menu we’ll click on the '''Zoom '''option.
 
This time from the context menu we’ll click on the '''Zoom '''option.
Line 363: Line 313:
 
|-
 
|-
 
|| Click on '''Fit width and height '''option >> click on '''Ok'''
 
|| Click on '''Fit width and height '''option >> click on '''Ok'''
 
 
 
 
  
  
Line 373: Line 319:
 
Scroll down and up
 
Scroll down and up
 
|| Click on '''Fit width and height''' and then on the''' Ok''' button at the bottom right'''.'''
 
|| Click on '''Fit width and height''' and then on the''' Ok''' button at the bottom right'''.'''
 
  
 
This view fits the '''spreadsheet''' across the entire width and height of the page.  
 
This view fits the '''spreadsheet''' across the entire width and height of the page.  
 
  
 
Scroll down and up, it displays many pages at a time.
 
Scroll down and up, it displays many pages at a time.
Line 385: Line 329:
 
|| Point to '''Fit to Width'''
 
|| Point to '''Fit to Width'''
 
|| Next option is '''Fit Width'''.  
 
|| Next option is '''Fit Width'''.  
 
  
 
This fits the page to its width.
 
This fits the page to its width.
Line 403: Line 346:
 
|| Change value field as '''75%''' >> click on '''OK'''
 
|| Change value field as '''75%''' >> click on '''OK'''
 
|| For example, let’s type the value as '''75%''' in the '''Variable''' field.
 
|| For example, let’s type the value as '''75%''' in the '''Variable''' field.
 
  
 
And then click on the '''OK''' button.
 
And then click on the '''OK''' button.
 
|-
 
|-
 
|| Point to the texts.
 
|| Point to the texts.
 
  
 
Click on '''View''' >> '''Zoom>>Optimal View'''
 
Click on '''View''' >> '''Zoom>>Optimal View'''
 
|| Observe how the text is '''zoomed'''.
 
|| Observe how the text is '''zoomed'''.
 
  
 
Let's switch back to '''Optimal''' '''View''' for better visibility.
 
Let's switch back to '''Optimal''' '''View''' for better visibility.
Line 436: Line 376:
 
|| Show '''Page''' '''2''' and '''Page''' '''4'''
 
|| Show '''Page''' '''2''' and '''Page''' '''4'''
 
|| Notice that the '''Account '''column is going on to the next page.
 
|| Notice that the '''Account '''column is going on to the next page.
 
  
 
So now, we will try to fit the '''data''' into one single page.
 
So now, we will try to fit the '''data''' into one single page.
 
|-
 
|-
 
|| Click on the '''Close''' '''Preview''' button.
 
|| Click on the '''Close''' '''Preview''' button.
 
 
 
 
|| Click on the''' Close Preview '''button at the top to exit the '''Toggle Print View.'''
 
|| Click on the''' Close Preview '''button at the top to exit the '''Toggle Print View.'''
 
|-
 
|-
Line 450: Line 386:
 
|-
 
|-
 
|| Place cursor on '''H''' column header
 
|| Place cursor on '''H''' column header
 
 
 
 
 
 
|| Place the cursor on the right edge on the column header '''H.'''  
 
|| Place the cursor on the right edge on the column header '''H.'''  
 
  
 
Notice that the cursor changes into a double-sided arrow.  
 
Notice that the cursor changes into a double-sided arrow.  
 
|-
 
|-
 
|| Left click and drag towards left.
 
|| Left click and drag towards left.
 
 
 
 
 
 
 
  
 
Point to the Data
 
Point to the Data
 
|| Now click and hold the left mouse button  
 
|| Now click and hold the left mouse button  
 
  
 
Drag a little towards the left side as shown to reduce the margins.
 
Drag a little towards the left side as shown to reduce the margins.
 
  
 
On doing so, all the columns from '''C''' to''' H '''get resized proportionally.
 
On doing so, all the columns from '''C''' to''' H '''get resized proportionally.
Line 480: Line 401:
 
|| Point to the hashtags
 
|| Point to the hashtags
 
|| While doing so some '''data''' in the '''cells''' may look like a series of '''hashtags'''.
 
|| While doing so some '''data''' in the '''cells''' may look like a series of '''hashtags'''.
 
  
 
If so, resize the''' columns''' and '''zoom''' level in such a way that we are able to see the '''data '''again.  
 
If so, resize the''' columns''' and '''zoom''' level in such a way that we are able to see the '''data '''again.  
Line 498: Line 418:
 
|| Point to the '''Print''' icon
 
|| Point to the '''Print''' icon
 
|| From this screen, one can proceed to printing the '''spreadsheet''', by clicking the '''Print''' icon.
 
|| From this screen, one can proceed to printing the '''spreadsheet''', by clicking the '''Print''' icon.
 
  
 
But I will not do so now.
 
But I will not do so now.
Line 518: Line 437:
 
|| Point on '''Print''' icon  
 
|| Point on '''Print''' icon  
 
|| To directly print the entire '''spreadsheet''', click on the
 
|| To directly print the entire '''spreadsheet''', click on the
 
  
 
'''Print''' icon in the '''Standard toolbar'''.
 
'''Print''' icon in the '''Standard toolbar'''.
 
  
 
This is known as quick printing.  
 
This is known as quick printing.  
Line 529: Line 446:
 
|-
 
|-
 
|| '''Print '''dialog box appears  
 
|| '''Print '''dialog box appears  
 
  
 
Highlight the 2 tabs
 
Highlight the 2 tabs
 
 
 
 
 
  
 
Highlight the settings below also
 
Highlight the settings below also
 
|| The '''Print '''dialog box appears on the screen.
 
|| The '''Print '''dialog box appears on the screen.
 
  
 
There are 2 tabs with different settings in this dialog box.
 
There are 2 tabs with different settings in this dialog box.
 
  
 
We can either leave these as default or change the settings as per our printing requirement.
 
We can either leave these as default or change the settings as per our printing requirement.
Line 549: Line 458:
 
|| Click Printer >>''' Print to File'''
 
|| Click Printer >>''' Print to File'''
 
|| Under '''Printer drop-down''', let’s select '''Print to File '''option.
 
|| Under '''Printer drop-down''', let’s select '''Print to File '''option.
 
  
 
This option is used predominantly to print the '''spreadsheet '''into '''PDF '''file''' '''format.
 
This option is used predominantly to print the '''spreadsheet '''into '''PDF '''file''' '''format.
Line 555: Line 463:
 
|| Point and then click on '''Print to File'''
 
|| Point and then click on '''Print to File'''
 
|| The button at the bottom of the dialog box says '''Print to File'''.
 
|| The button at the bottom of the dialog box says '''Print to File'''.
 
  
 
Click on it.
 
Click on it.
Line 561: Line 468:
 
|| Choose '''Desktop '''>> type '''sample-file >> '''Click '''Save'''
 
|| Choose '''Desktop '''>> type '''sample-file >> '''Click '''Save'''
 
|| Choose the location to save and type a '''filename''' for the '''pdf'''.
 
|| Choose the location to save and type a '''filename''' for the '''pdf'''.
 
  
 
Then click on the '''Save''' button at the top right.
 
Then click on the '''Save''' button at the top right.
Line 567: Line 473:
 
|| Only narration
 
|| Only narration
 
|| This saves the file in '''PDF''' format.
 
|| This saves the file in '''PDF''' format.
 
  
 
You can open this file in any '''PDF''' viewer and print it in future.
 
You can open this file in any '''PDF''' viewer and print it in future.
 
|-
 
|-
 
||  
 
||  
 
 
  
 
Press '''Ctrl+P '''keys
 
Press '''Ctrl+P '''keys
 
|| Let’s learn about some more printing features.
 
|| Let’s learn about some more printing features.
 
  
 
Press '''Ctrl+P '''keys on the keyboard.
 
Press '''Ctrl+P '''keys on the keyboard.
 
  
 
This is the shortcut to open the '''Print '''dialog box.
 
This is the shortcut to open the '''Print '''dialog box.
Line 590: Line 491:
 
'''Number of copies''' = 3.
 
'''Number of copies''' = 3.
 
|| Under '''Range and Copies''', let’s set the '''Pages''' as 2 and '''Number of copies''' as 3.
 
|| Under '''Range and Copies''', let’s set the '''Pages''' as 2 and '''Number of copies''' as 3.
 
  
 
So we are printing 3 copies of Page 2 of our '''spreadsheet'''.
 
So we are printing 3 copies of Page 2 of our '''spreadsheet'''.
Line 610: Line 510:
 
|-
 
|-
 
|| '''From which''' >> Click on dropdown
 
|| '''From which''' >> Click on dropdown
 
  
 
Select '''Print selected cells'''
 
Select '''Print selected cells'''
 
|| In the '''Print '''dialog box, click on the dropdown besides '''From''' '''which''' option.  
 
|| In the '''Print '''dialog box, click on the dropdown besides '''From''' '''which''' option.  
 
  
 
From the available options select''' Print selected cells.'''
 
From the available options select''' Print selected cells.'''
Line 630: Line 528:
 
|| Click on the '''Tools menu '''in the '''menu bar''' and then click on '''Options.'''
 
|| Click on the '''Tools menu '''in the '''menu bar''' and then click on '''Options.'''
 
|-
 
|-
|| Click\Point on '''Libreoffice'''>>'''Print'''
+
|| Click on '''Libreoffice'''>>'''Print'''
 
|| Click on the arrow beside '''LibreOffice '''if not already expanded and then click on '''Print.'''
 
|| Click on the arrow beside '''LibreOffice '''if not already expanded and then click on '''Print.'''
 
|-
 
|-
 
|| Dialog box appears
 
|| Dialog box appears
 
|| A dialog box, giving us several options to select from.
 
|| A dialog box, giving us several options to select from.
 
  
 
Choose these options as per requirements.
 
Choose these options as per requirements.
Line 655: Line 552:
 
|| Slide: Summary
 
|| Slide: Summary
 
|| In this tutorial, we learnt to:  
 
|| In this tutorial, we learnt to:  
 +
 
* View '''spreadsheets''' and
 
* View '''spreadsheets''' and
 
* Print '''spreadsheets''' in '''LibreOffice Calc.'''
 
* Print '''spreadsheets''' in '''LibreOffice Calc.'''
 
 
|-
 
|-
 
|| Slide: Assignment
 
|| Slide: Assignment
 
|| As an assignment
 
|| As an assignment
 +
 
* Open “'''Spreadsheet-Practice.ods'''” file.  
 
* Open “'''Spreadsheet-Practice.ods'''” file.  
 
* Print '''Sheet 1 '''data in '''Landscape''' mode option.
 
* Print '''Sheet 1 '''data in '''Landscape''' mode option.

Latest revision as of 20:37, 12 July 2020

Title: Viewing and Printing Spreadsheet document

Author: Arvind Pillai

Novice Reviewer: Pooja, Nikita and Manish

Domain Review: Nancy, Praveen

Keywords: libreoffice, Calc, spreadsheet, print, normal view, page break, print spreadsheet, print cells, page format, page layout, page style, zoom factor, print settings, print to file, full screen mode, print ranges, print copies, print as pdf, spoken tutorial, video tutorial


Visual Cue Narration
Slide: Title Slide Welcome to the spoken tutorial on Viewing and Printing a spreadsheet.
Slide : Learning Objectives In this tutorial we will learn to
  • View spreadsheets and
  • Print spreadsheets in LibreOffice Calc.
Slide: System Requirements This tutorial is recorded using
  • Ubuntu Linux OS version 18.04 and
  • LibreOffice Suite version 6.3.5
Only Narration We’ll first learn about the various viewing options in LibreOffice Calc.
Slide : Viewing options There are basically two widely used viewing options in Calc - Normal and Page Break.
Slide: Normal and Page Break
  • The Normal option displays how the spreadsheet will look when printed.
  • The Page break option displays the spreadsheet data in different pages when the data is large.
  • It helps us to organise and arrange data to fit within the pages we want to print.
Open Personal-Finance-Tracker.ods Open the Personal-Finance-Tracker.ods file.
Slide: Code files
  • 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.
Point to Column B >> Point to Miscellaneous Notice that some part of the text is not readable inside column B.
Only Narration If we print as it is, that text will be truncated in the print.

Let us sort this out first.

Place cursor on B column header Place the cursor on the right edge on column header B.


Notice that the cursor changes into a double-sided arrow.

Left click and drag towards left.


Point to the Data

Now click and hold the left mouse button.

Drag a little towards the right side as shown to increase the width of column B.

Now, we can see all the text of column B clearly.

Click on View >> Normal To access the Normal View, click on View menu in the menu bar and then on Normal.


This is the default view in Calc

Click on View >> Page Break To access the Page Break option, click on the View menu in the menu bar and then on Page Break.
Zoom the interface using zoom slider For the better visibility I'm zooming in.
Point to Page 1 We can see a watermark named as Page 1 and Page 2 displayed.
Click on View >> Normal Let’s go back to the Normal view on the Calc window.
Point to the dotted lines

(Editing: point with a red arrow)

Notice a vertical dotted line passing between Date and Account columns.


This indicates the right page margin.

Scroll down

Point to the dotted lines

Scroll down until you see a horizontal dotted line.

In my case the dotted line is passing between row number 50 and 51.

In your case it may vary.

This indicates the bottom page margin.

Only Narration Within these margins, we can see how much data of our spreadsheet fits within a single page.
Scroll the page upwards. Scroll the page back up to the top.
Only Narration Now let's copy our existing data and paste it below.
Click on cell A1 >> holding the Shift key on the keyboard, click on cell H8. First click on cell A1.


Now holding the Shift key on the keyboard, click on cell H8.

Point to selection area.


Right Click on the selection area >> Click on copy option

All the cells have been selected.


Now right-click anywhere on the selected cells and then click on the Copy option.

Click on cell G10

Scroll down to row no. 51

Click anywhere outside the selection area to deselect the cells.

Now I will scroll down to row number 51.

You should scroll down to the row number where your bottom page margin is seen.

Right click on cell A51 >> click on Paste option. Right-click on cell A51 and then click on the Paste option.
Click anywhere on the page to deselect cells

Scroll up and press Esc

Click anywhere outside the selection area to deselect the cells.

Scroll up and press the Escape key to remove the dotted line selection.

Click on View menu >> Page Break Now click on the View menu and the Page Break option.
Click Zoom out Let us zoom out for better visibility.
Scroll upwards and downwards.

Point to Page 2 and Page 1

Point to Page 3 and Page 4

Scroll the page down and up to see the page breaks.

We can see a new page with the watermark Page 2 below Page 1.

We can also see Page 4 below Page 3 adjacent to these pages.

Click on View Menu >> Normal Option Click on View menu and go back to the Normal view again.
Only narration Apart from both these options, one can also view a spreadsheet in full screen mode.
Click on View >> Full screen Click on the View menu in the menu bar and then on Full Screen option.
Only Narration The Full screen mode is useful for editing spreadsheets.

It’s also useful for projecting them on a projector.

Point to Full Screen button >> Press Esc key To exit the full screen mode, press either the Full Screen button or the Escape key.
Only Narration We are back to the Normal view on the Calc window.
Click on Format menu >> Page Click on Format in the menu bar and then on Page option.
Point to dialog box The Page Style:Default dialog box opens.
Point to the tabs at top There are various tabs here.
Click on Page tab Click on the Page tab.
Point to >> Paper Format >> Margins >> Layout settings. There are various settings here for Paper Format, Margins and Layout settings.
Point to Orientation

Point to Portrait

Under Paper Format, notice that the Orientation field has the Portrait option pre-selected.
Point to the preview area. Look at the preview area to see the page orientation.
Click on the Landscape option. Now, click on the Landscape option.
Point to the preview area. Look at the preview area to see how the page orientation has changed.
Click on the Portrait option. Click on the Portrait option once again.
Click on Sheet tab Next, click on the Sheet tab.
Point to Page Order

Point to Top to bottom, then right

The red arrows should indicate the И flow of pages

Under Page Order, we see that Top to bottom, then right is selected.

Recall, that’s exactly how our pages are displayed in the Page break view.


Click on Left to right, then bottom

Click on Ok button

Let’s click on Left to right, then bottom and click on the OK button at the bottom right.
Click on View menu >>Page Break Click on View in the menu bar and then on Page break option.
Point towards the page numbers. Observe the change in the page numbering.
Click on View >> Normal Let’s go back to the Normal view.
Only Narration Now, let’s learn to use the Zoom option.
Highlight the Zoom slider at the bottom right corner


The easiest way to zoom or magnify a spreadsheet is to use the Zoom slider.

This is located at the bottom right corner of the Calc window.

Click on plus icon

Click on minus icon

We can use the plus and minus icons on either side of the slider, like this.
Drag the Zoom head to plus side

Drag the Zoom head to minus side

Or we can drag the Zoom head to increase or decrease the magnification, like this.
Only Narration Let's learn another way of zooming.
Click on View >> Zoom

Point to option

Click on Optimal View

Click on the View menu in the menu bar and click on Zoom.

A few more options are displayed in the context menu.

Here select Optimal View.

Point to the spreadsheet. Now, we get the most comfortable magnified view of the spreadsheet.
Click on View >> Zoom

Click on Zoom

Again click on View menu in the menu bar and then on the Zoom option.

This time from the context menu we’ll click on the Zoom option.

Only narration Zoom & View Layout dialog box opens up.
Point to Zoom factor and View layout It has 2 headings namely - Zoom Factor and View Layout.
Point to Zoom factor option The Zoom Factor sets the magnification in which to display the spreadsheet.
Point to options Under Zoom Factor we see many options.
Click on Fit width and height option >> click on Ok



Scroll down and up

Click on Fit width and height and then on the Ok button at the bottom right.

This view fits the spreadsheet across the entire width and height of the page.

Scroll down and up, it displays many pages at a time.

Click on View >> Zoom>> Zoom & View Layout dialog box >> Open the Zoom & View Layout dialog box again.
Point to Fit to Width Next option is Fit Width.

This fits the page to its width.

Point on 100% 100% view will display the page in its actual size.
Highlight both options with a red box Try out these 2 options on your own.
Click on Variable option Next we have the most important zoom option called the Variable.
Point to Zoom factor Here, we can type the zoom factor at which we want to view the spreadsheet.
Change value field as 75% >> click on OK For example, let’s type the value as 75% in the Variable field.

And then click on the OK button.

Point to the texts.

Click on View >> Zoom>>Optimal View

Observe how the text is zoomed.

Let's switch back to Optimal View for better visibility.

Only Narration Next, we will learn about Print Preview.
Click on Toggle Print Preview icon Click on the Toggle Print Preview icon in the Standard toolbar.
Show print preview mode The Print Preview bar appears when we view the spreadsheet in preview mode.
Zoom the interface using zoom slider For the better visibility I'm enlarging the view.
Only narration It basically shows how the spreadsheet will look like, when it is printed.
Scroll down to see all the pages Scroll down and up to see all the pages in the spreadsheet.
Show Page 2 and Page 4 Notice that the Account column is going on to the next page.

So now, we will try to fit the data into one single page.

Click on the Close Preview button. Click on the Close Preview button at the top to exit the Toggle Print View.
Select column C to H Now select the columns C to H as shown here.
Place cursor on H column header Place the cursor on the right edge on the column header H.

Notice that the cursor changes into a double-sided arrow.

Left click and drag towards left.

Point to the Data

Now click and hold the left mouse button

Drag a little towards the left side as shown to reduce the margins.

On doing so, all the columns from C to H get resized proportionally.

Point to the hashtags While doing so some data in the cells may look like a series of hashtags.

If so, resize the columns and zoom level in such a way that we are able to see the data again.

Point to the dotted lines. The data in the columns A to H. are now within the dotted boundary line of the page.
Click on Toggle Print Preview icon Again, click on the Toggle Print Preview icon in the Standard toolbar.
Point at the Pages Now the data fits within two pages.
Only narration. In this way we can adjust the data before printing, so that it looks neat and organised.
Point to the Print icon From this screen, one can proceed to printing the spreadsheet, by clicking the Print icon.

But I will not do so now.

Click Close Preview button Click on the Close Preview button to close the preview.
Click on File >> Print Preview

Press Esc key

We can also click on File menu in the menu bar and click on Print Preview.
Only narration Next, we will learn how to print our LibreOffice Calc spreadsheet.
Text on screen: Printer connection should be configured correctly on your machine. First, ensure that the printer connection is configured correctly on your machine.
Point on Print icon To directly print the entire spreadsheet, click on the

Print icon in the Standard toolbar.

This is known as quick printing.

Click File >> Print Alternatively, you can click on the File menu in the menu bar and then click on Print.
Print dialog box appears

Highlight the 2 tabs

Highlight the settings below also

The Print dialog box appears on the screen.

There are 2 tabs with different settings in this dialog box.

We can either leave these as default or change the settings as per our printing requirement.

Click Printer >> Print to File Under Printer drop-down, let’s select Print to File option.

This option is used predominantly to print the spreadsheet into PDF file format.

Point and then click on Print to File The button at the bottom of the dialog box says Print to File.

Click on it.

Choose Desktop >> type sample-file >> Click Save Choose the location to save and type a filename for the pdf.

Then click on the Save button at the top right.

Only narration This saves the file in PDF format.

You can open this file in any PDF viewer and print it in future.

Press Ctrl+P keys

Let’s learn about some more printing features.

Press Ctrl+P keys on the keyboard.

This is the shortcut to open the Print dialog box.

Select my configured printer’s name (HP LaserJet). Under Printer, we will select our configured printer’s name.
Under Range and Copies >> Pages = 2 and

Number of copies = 3.

Under Range and Copies, let’s set the Pages as 2 and Number of copies as 3.

So we are printing 3 copies of Page 2 of our spreadsheet.

Click Ok Click on the OK button at the bottom right of the dialog box, to start the printing.
Only narration If our printer is configured correctly, the pages and copies we mentioned will now get printed.
Only narration Now let’s see how to print certain parts of data by selecting some cells.
Select A1 to C8 Let’s select the data from A1 to C8 as shown here.
Press Ctrl+P keys Press Ctrl+P keys on the keyboard.
From which >> Click on dropdown

Select Print selected cells

In the Print dialog box, click on the dropdown besides From which option.

From the available options select Print selected cells.

Point to print preview. Observe that only selected cells are displayed in the Print preview section.
Click Ok Now, click on the OK button at the bottom right to start the printing.
Only narration Next, we will see how to access other Print options.
Click on Tools>>options Click on the Tools menu in the menu bar and then click on Options.
Click on Libreoffice>>Print Click on the arrow beside LibreOffice if not already expanded and then click on Print.
Dialog box appears A dialog box, giving us several options to select from.

Choose these options as per requirements.

Click on OK button I will keep all the default settings and then click on the OK button at the bottom.
Only narration These settings are now valid for all prints from LibreOffice Calc, in the future.
Ctrl + S & Close Save and Close the file
Only Narration This brings us to the end of this tutorial.

Let us summarize.

Slide: Summary In this tutorial, we learnt to:
  • View spreadsheets and
  • Print spreadsheets in LibreOffice Calc.
Slide: Assignment As an assignment
  • Open “Spreadsheet-Practice.ods” file.
  • Print Sheet 1 data in Landscape mode option.
  • Choose View and select Full Screen option
  • Exit Full Screen option
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: Forums Please post your timed queries in this forum.
Slide: Acknowledgement Spoken Tutorial project is funded by MHRD, Govt. of India.
Slide: Thank you This is Arvind from IIT Bombay signing off. Thank you for watching.

Contributors and Content Editors

Arvindpillai90