When I started using Google Sheets a few years ago, there was no way to zoom out ( or rapid climb in ) in Google Sheets .
Being a skilled Microsoft Excel drug user, this frustrated me to the congress of racial equality .
After all, how difficult could it be to build a elementary functionality to soar in and out in the worksheet ?
well, I don ’ thyroxine know how hard it is ( or isn ’ triiodothyronine ), but the good news program is that now you can Zoom-in and Zoom-out in Google Sheets .
It ’ s not simple and user-friendly as it ’ s in Excel, but I ’ ll take it .
In this tutorial, I will show you a pair of methods to Zoom-in and Zoom-out in Google Sheets .
Using the In-built Zoom functionality
This is a functionality Google Sheets added that allows you to zoom in and out .
Below are the steps to Zoom-In and Zoom-Out in Google Sheets :
- Click the Zoom option in the toolbar. This will show a drop-down with various zoom levels.
- Select the Zoom level you want. You can select from the existing ones or enter a custom value. Anything less than 100% will make the view smaller and anything more than that will make it bigger.
You besides get the same options when you click the File pill and hover the cursor on the Zoom option .
While I am glad we ultimately have a way to zoom-in and zoom-out in Google Sheets, there are even two drawbacks which I wish weren ’ t there :
- When you zoom one worksheet, it also applies the same zoom to all the other worksheets of the document.
- There is no shortcut to change the zoom. So every-time you need to increase/decrease the zoom, you need to follow the above steps.
While nothing can be done about the first drawback ( at least at the time of writing this tutorial ), there is a way to use a shortcut to zoom-in and zoom-out in Google Sheets .
And it comes with its own restriction !
Shortcut to Zoom-in and Zoom-out in Google Sheets
Another room to zoom in and zoom out in Google Sheets is by changing the soar of the integral browser .
Although this method acting is not ideal in many cases, it does have assorted shortcuts that you can use .
If you ’ re using a personal computer, you can use the downstairs shortcuts :
- To Zoom In – Control + (hold the control key and press the plus key)
- To Zoom Out – Control – (hold the control key and press the minus key)
- To restore zoom back to 100% – Control 0 (hold the control key and press the 0 key)
If you ’ re using a Mac, use the Command identify rather of the operate key .
In case you ’ re using Google Sheets ( or any other Google Apps ) on a smartphone or iPad, you can pinch and change the rapid climb levels .
If you ’ re using a sneak with a scroller, you can besides use the comply – hold the Control key and then change the scroller to change the zoom levels .
You can besides change the soar level by manually changing the value in the browser .
Below are the steps to change the zoom flush on Google Sheets in the Chrome browser :
- Click the Customize and Control icon in Google Chrome browser (it’s at the top-right part of the browser)
- In the options that open, change the Zoom level by clicking on the plus or minus sign
You can besides find a similar option to soar in FireFox and all the other popular browsers .
The drawback with this method acting is that when you zoom in and soar out the spreadsheet, it besides does the lapp to the entire browser. This not lone changes the rapid climb flat of the cells in the worksheet area but besides the menu and toolbar in Google Sheet. not only this, but it besides changes the soar level of all the other windows you have open in that browser .
You may also like the following Google Sheets tutorials: