LibreOffice-Suite-Calc-6.3/C2/Viewing-and-printing-a-spreadsheet-in-Calc/English

From Script | Spoken-Tutorial
Revision as of 20:09, 12 July 2020 by Arvindpillai90 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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\Point 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