Adjust the display size of Sheets using zoom bar, keyboard shortcuts, trackpad gestures, or zoom box. Take a closer look or have a broader view of your spreadsheets whenever you like.
- 1.Zoom bar
Find the zoom bar in the lower-right corner of the page. Click the + or - button to zoom in or out of the page by 10% with each click.
- 2.Keyboard shortcuts
Action | Windows | Mac |
Zoom in | Ctrl+Plus or Ctrl+mouse wheel scroll | ⌘+Plus or ⌘+mouse wheel scroll |
Zoom out | Ctrl+Minus or Ctrl+mouse wheel scroll | ⌘+Minus or ⌘+mouse wheel scroll |
Restore page scale to 100% | Ctrl+0 | ⌘+0 |
View list of common keyboard shortcuts | Ctrl+/ | ⌘+/ |
Hover your mouse over the + or - button in the zoom bar and a tooltip will automatically show the keyboard shortcuts to zoom in or out. You can also click the ? button in the lower-right corner and select Keyboard Shortcuts to view a list of shortcuts.
- 3.Zoom box
Click on the zoom box in the lower-right corner to set a zoom factor. You can either select from the zoom factors provided or enter a customized zoom factor ranging from 25% to 200%.
III. FAQs
Will zooming a sheet affect other sheets in the same spreadsheet?
No. Other sheets won't be affected. Sheets under the same spreadsheet can have different zoom factors that are independent from each other.
Will refreshing the page restore its default zoom factor?
No. When you refresh or re-open a spreadsheet, it'll be scaled according to your latest settings.
Will zooming a sheet affect the view of other collaborators?
No. The zooming action only takes effect locally and won't be synchronized across devices. Different collaborators can set different zooming factors on the same sheet.