How to Zoom In, Zoom out in LibreOffice Calc Sheet


Here’s how you can perform zoom in and zoom out in LibreOffice Calc sheet.

When you are working with a large set of data in a LibreOffice Calc sheet, you often need to zoom in or zoom out to fit the data in the available display resolution. Calc provides easiest way to provide these two features.

Zoom Options

  • In the Calc workspace, at the bottom right section, the zoom controls are present. See Figure 1.
  • By default, the zoom is set to 100%. Right-click on the zoom number (100%), and you can see quick zoom options. You can also access this via View > Zoom from the menu. See Figure 2.
  • A single left click on the zoom% label brings up the below dialog with more exhaustive options for Zoom. You can select your desired options to complete your tasks. See Figure 3.
  • If you are using the Tabbed bar (ribbon), you can get these options in the View tab as shown below. See Figure 4.
Calc - Zoom Controls
Figure 1: Calc – Zoom Controls
Zoom Options - via right click
Figure 2: Zoom Options – via right click
Zoom & View Layout - Options
Figure 3: Zoom & View Layout – Options
Zoom in and out options in Tabbed bar (ribbon)
Figure 4: Zoom in and out options in Tabbed bar (ribbon)

Different Zoom in Sheets / Synchronize Zoom

  • It is possible to have different Zoom levels in different sheets of Calc.
  • By default, zoom levels are synchronized, i.e. if you zoom to, say, 150% on Sheet1, the same zoom is to be applied to Sheet2 and so on.
  • If you want to have different zoom levels, i.e. while zooming Sheet1, the other sheet’s zoom level remains the same, then follow the below steps:
    • Go to the menu. Tools > Options for Windows and Linux. For macOS, open LibreOffice > Preferences.
    • On the left side, click LibreOffice Calc > View. Then, uncheck the option Synchronize Sheets under Zoom.
    • Press OK.
    • Now, you can have different zoom levels on different sheets. To revert back, open the above dialog again and check the option.
Synchronize Zoom
Synchronize Zoom

Drop a comment below if you have any questions or are having trouble zooming in and out in LibreOffice Calc.

Join our Telegram channel and stay informed on the move.

Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Newest Most Voted
Inline Feedbacks
View all comments
Josif Britz

Why are not there a simple zoom in / zoom out icons available to be placed on a toolbar? Than would zoom by 10% each time they are clicked?

Ole Kr Bendiksen

Why is there no such function in libre office base

Ed Peltzman

1. How do you print the spreadsheet grid pattern?
2. How do you print the compleat spread sheet using page landscape?
3. How do you reduce the size of the spreadsheet to print on one page>

Ofer Barsadeh

can we zoom into a specific cell by – say – control mouse-wheeling it?

Ofer Barsadeh

actually, it’d be nice if we could pan or tilt on the page by shift/alt/combination mouse wheeling.


I go to “tools” but there isn’t an ” options” in the dialog box