If your Google Sheets toolbar or menus are missing, they’re most likely hidden. Press Ctrl + Shift + F (Command + Shift + F on a Mac) to show them again, or click the small arrow (Show the menus) at the top-right corner of the sheet. If the whole interface is gone, you may be in full screen: press Esc, or reload the page. Browser zoom, extensions, and a narrow window can also hide toolbar buttons.
This guide covers every cause of a missing toolbar, formula bar, gridlines, or menus, plus fixes on the mobile app.
Fix 1: Show the menus (compact mode)
- Press Ctrl + Shift + F.
- Or click the arrow in the top-right corner of the Sheets window (it points down when menus are hidden).
- Or open View > Show and choose Menus, if the View menu is visible.
Fix 2: Exit full screen
If you chose View > Full screen, Sheets hides the menus and toolbar. Press Esc to exit. Also check your browser’s own full screen mode (press F11 on Windows or Control + Command + F on a Mac).
Fix 3: Show the formula bar and gridlines
- Formula bar – click View > Show > Formula bar.
- Gridlines – click View > Show > Gridlines.
Fix 4: Reset zoom and widen the window
If some toolbar buttons are missing, they may be collapsed into the More (three dots) button at the right end of the toolbar because the window is narrow or zoomed in. Press Ctrl + 0 to reset browser zoom, and maximize the window.
Fix 5: Check extensions and browser issues
- Open the sheet in an incognito or private window. If the toolbar appears, a browser extension is interfering; disable extensions one at a time.
- Clear the browser cache for google.com, update the browser, or try a different browser.
- Reload the page with Ctrl + Shift + R.
Fix 6: Check your access
If you have view-only access, most editing tools are hidden. Click Request edit access at the top, or ask the owner to share it with you as an editor.
On the mobile app
- Tap a cell to show the formatting toolbar and formula bar.
- Tap the Edit (pencil) button if you’re in view mode.
- Update the Google Sheets app if tools seem missing.
Frequently asked questions
Why did my menus disappear?
You probably pressed Ctrl + Shift + F by accident or clicked the arrow at the top right, which toggles compact mode.
Does hiding menus affect other people?
No. It only changes your view.
Does the same shortcut work in Google Docs?
Yes. Ctrl + Shift + F shows or hides menus in Docs and Slides too.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.