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.
- Press ok.
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.
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?
Why is there no such function in libre office base
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>
You can find these options in Print dialog. You can enable the cell borders to print the grids. Landscape option is available in Page setup from Print preview.
To fit the spreadsheet in one page, you have to reduce the font size of the entire sheet.
can we zoom into a specific cell by – say – control mouse-wheeling it?
No. When you zoom, the entire sheet zooms in or out.
actually, it’d be nice if we could pan or tilt on the page by shift/alt/combination mouse wheeling.