Use Fit to Mobile with 3 how-to topics: turn it on, turn it off, and combine it with landscape viewing; choose a topic from the index and follow the steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Turn On Fit to Mobile | Free |
| 2 | 2. Turn Off Fit to Mobile | Free |
| 3 | 3. Use It with Landscape View for Wide Sheets | Free |
How-to Guide
1. Turn On Fit to Mobile
Entry: Tools → View → Fit to Mobile
- Open the target spreadsheet.
- Tap the Tools button at the bottom.
- Switch to the View tab.
- Find Fit to Mobile and tap the switch next to it to turn it on.
- Check whether the spreadsheet has been rearranged to fit the screen width.
Success Criteria
- Interface result: the spreadsheet content is rearranged automatically, and cell widths fit the current screen width.
- What you can do next: continue scrolling through the sheet and reviewing data.
Tips While Using
- Common mistake: if you are not in the View tab, you may not find the Fit to Mobile option.
- Environment note: the display result depends on the number of columns and the amount of content in the sheet.
2. Turn Off Fit to Mobile
Entry: Tools → View → Fit to Mobile
- In the open spreadsheet, tap the Tools button at the bottom.
- Switch to the View tab.
- Find Fit to Mobile and turn the switch off.
- Confirm that the spreadsheet has returned to the original column width ratio.
Success Criteria
- Interface result: the spreadsheet returns to its original column width ratio.
- What you can do next: continue viewing or editing the spreadsheet in its original layout.
Tips While Using
- Common mistake: if the display still feels crowded after turning it off, try horizontal scrolling or landscape viewing.
- Environment note: turning the feature off changes only the current display mode and does not change spreadsheet data or formatting.
3. Use It with Landscape View for Wide Sheets
Entry: rotate the device to landscape, and combine it with viewing settings when needed
- Open the wide spreadsheet that you want to review.
- Turn on Fit to Mobile if needed.
- Rotate your Android device to landscape.
- Review more columns in the wider viewing area.
- If needed, switch Fit to Mobile on or off in landscape mode to compare layouts more clearly.
Success Criteria
- Interface result: the spreadsheet is shown in a wider viewing area in landscape mode.
- What you can do next: review multi-column data more easily.
Tips While Using
- Common mistake: if auto-rotate is disabled on the device, landscape mode may not activate automatically.
- Environment note: the visible range varies by device screen size.