提示:其他语言是Google翻译的。 你可以访问 English 版本。
登录
x
or
x
x
注册账户
x

or

更改工作区域大小:在Excel中显示或隐藏功能区,编辑栏和状态栏

当您使用笔记本电脑等小屏幕电脑时,或浏览数据量过大的工作簿时,是否尝试通过切换状态栏,编辑栏和功能区来获得更大的浏览区域? 如果是这样,用这个 工作区大小 您可以在Excel中快速切换以下3类型的工作区大小。


点击 Kutools >> 工作区域,看截图:

拍摄工作区域004


用法:

点击 工作区域,您将有一个工具栏,4按钮位于屏幕上,如下所示:

点击第一个按钮将重置您的Excel到正常的工作区域大小。

单击其他3按钮将在Excel中的3类型的工作区域大小之间切换。


单击即可隐藏状态栏

单击第二个按钮,工作簿下面的状态栏将被隐藏。

单击即可隐藏状态栏和配方栏

点击第三个按钮,状态栏和公式栏将被隐藏。

单击即可隐藏功能区,状态栏和配方栏

点击第四个按钮,状态栏,编辑栏和功能区将被隐藏。

拍摄工作区域04


演示:一次隐藏并显示功能区,状态栏和配方栏:

Kutools for Excel:比200方便的Excel加载项,可以在60天免费试用。 下载并免费试用现在!


生产力推荐工具
以下工具可以大大节省您的时间和金钱,哪一个适合您?
Office Tab: 在您的Office中使用方便的选项卡,作为Chrome,Firefox和新Internet Explorer的方式。
Kutools for Excel: Excel的300高级函数 2019,2016,2013,2010,2007和Office 365。
Classic Menu for Office: 把熟悉的菜单带回到Office 2007,2010,2013,2016,2019和365,就像它是Office 2000和2003一样。

Kutools for Excel

上述功能只是Kutools for Excel的300强大功能之一。

专为Excel(Office)2019,2016,2013,2010,2007和Office 365而设计。 免费下载并使用60天。

Excel的Kutools屏幕截图

BTN阅读更多 BTN下载 btn购买

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    David Turner · 1 years ago
    I had the same issue that Marion and Terry had (3 years ago!) but I don't think the question was understood - when I select the WORK AREA button, the ribbon goes away & the spreadsheet window is maximized (correctly), but there is no floating 'work area' icon. Without that icon, there is nothing I can do to bring back the ribbon except quit Excel & re-start it.

    ** I have just discovered that 'work area' icon - it was floating on a second monitor!!! I didn't see it because it was lost in my other windows. I had to ALT-TAB to find it.
    I would suggest to KuTools, that you add this icon to the navigation window that is defaulting to the left margin.

    Also - when I restore the work area, my Excel maximizes in its monitor. I only want it to return to its original window size.
    This may be particular to WIndows 10, or Excel 2016, or something else, so it could be a bug; but if everyone else has this happen, then it should be fixed in future versions - perhaps add a choice: 'return ribbon & window to original size' or 'return ribbon & maximize window'?
  • To post as a guest, your comment is unpublished.
    Riaan · 4 years ago
    I was working on my second screen. When I moved Excel back to the first screen the floating tool bar appeared. Why does the toolbar not follow excel to the second screen?
  • To post as a guest, your comment is unpublished.
    Riaan · 4 years ago
    I have the same problem. I clicked on the work area button and the ribbon, the status bar and the formula bar dissapeared. I do not have the floating menu on my sheet. How do I restore my ribbon, status bar and the formula bar ?
  • To post as a guest, your comment is unpublished.
    Marion McNeill · 4 years ago
    When I select work area the floating work are toolbar is no where to be found. Can someone help?
  • To post as a guest, your comment is unpublished.
    Terry Rosengarten · 4 years ago
    I have just started trying Kutools for Excel. I do not have the floating work area toolbar on my screen, so I don't know how to get my ribbon and status back. Can someone help me?
    • To post as a guest, your comment is unpublished.
      Manjunath s · 4 years ago
      [quote name="Terry Rosengarten"]I have just started trying Kutools for Excel. I do not have the floating work area toolbar on my screen, so I don't know how to get my ribbon and status back. Can someone help me?[/quote
      hi you restart the your computer so you will get on riban
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Terry Rosengarten"]I have just started trying Kutools for Excel. I do not have the floating work area toolbar on my screen, so I don't know how to get my ribbon and status back. Can someone help me?[/quote]
      Hello, Can you see there are Kutools and Enterprise tabs in your Excel?