How to Zoom In, Zoom out in LibreOffice Calc Sheet

By | August 28, 2018
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, it is often needed 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.
Calc - Zoom Controls

Calc – Zoom Controls

By default, the zoom is set to 100%. Right click on zoom number (100%), you can see quick zoom options.
Zoom Options - via right click

Zoom Options – via right click

Single left click brings up below dialog with more exhaustive options for Zoom. You can select your desired options to complete your tasks.
Zoom & View Layout - Options

Zoom & View Layout – Options

 

Different Zoom in Sheets / Synchronize Zoom

It is possible to have different Zoom levels in different sheet of Calc. By default, zoom levels are synchronized i.e. if you zoom to say 150% in sheet1, the same zoom 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 same, then follow below steps:

  • Go to menu. Tools > Options.
  • On the left side, click LibreOffice Calc > View. Then uncheck the option Synchronize Sheets under zoom.
Synchronize Zoom

Synchronize Zoom

  • Press ok.
SEE ALSO:  Maximum Number of Rows, Columns, Cells in LibreOffice Calc

Now you can have different zoom levels in different sheets. To revert back, open the above dialog again and check the option.

 

Drop a comment below if you have any questions, feedback about this article. You can also follow us using Social links present at the top of this page.


For the latest tutorials, news and how-to guides, follow libreofficehelp.com on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 568 other subscribers.