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

When you are working with a small screen computer, such as a laptop, or browsing a workbook with too much data, have you ever try 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 4 types of working area size in your Excel.

  1. To minimize the Ribbon;
  2. To minimize the ribbon and hide the status bar;
  3. To minimize the ribbon, hide the status bar and the formula bar;
  4. To hide the ribbon, the status bar and the formula bar. Demo

arrow blue right bubbleClick "Kutools">>"Work Area Size". See screenshot (Fig.1).

Work-Area-Size

Fig. 1 Work Area Size


arrow blue right bubbleUsage:

  1. Click on “Work Area Size”, you will have a toolbar with 5 buttons locating on the top right of your screen.
  2. Click on first button will reset your Excel to the normal working area size.
  3. Click on the other 4 buttons will switch among 4 types of working area sizes in your Excel. See following Screenshots.

arrow blue right bubbleSee Work Area Size feature demo (Video 1).

Video 1. Work Area Size feature demo.


arrow blue right bubble This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.

Screen shot

btn read more     btn download     btn purchase