Skip to main content

Change working area size: show or hide ribbon, formula bar, and status bar in Excel

Author Zhoumandy Last modified

Kutools for Excel

Boosts Excel With 300+
Powerful Features

When you are working with a small screen computer, such as a laptop, or browsing a workbook with too much data, have you ever tried to get a bigger browsing area by toggling the status bar, the formula bar and the ribbon off? If so, with this Work Area Size you can quickly switch among the following 3 types of working area size in your Excel.


 Click Kutools > Show & Hide > Work Area, See screenshot:

shot work area 01


 Usage:

Click Kutools > Show & Hide > Work Area, you will have a toolbar with 4 buttons locating on your screen as:

shot work area 02

Click on the first button will reset your Excel to the normal working area size.

shot work area 03

Click on the other 3 buttons will switch among 3 types of working area sizes in your Excel.

shot work area 04


hide the status bar with one click

Click the second button, the status bar below the workbook will be hidden.

shot work area 05

hide the status bar and the formula bar with one click

Click the third button, the status bar and the formula bar will be hidden.

shot work area 06

hide the ribbon, the status bar and the formula bar with one click

Click the fourth button, the status bar, formula bar and the ribbon will be hidden.

shot work area 07


Demo: Hide and show the ribbon, the status bar and the formula bar at once:

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

šŸŒ Supports 40+ interface languages
āœ… Trusted by 500,000+ users and 80,000+ businesses worldwide
šŸš€ Compatible with all modern Excel versions
šŸŽ 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon