Ide: Lòt lang yo se Google-tradui. Ou ka vizite a English vèsyon nan lyen sa a.
Ouvri yon sesyon
x
or
x
x
enskri
x

or

Chanje gwosè zòn k ap travay: montre oswa kache riban, ba fòmil, ak bar estati nan Excel

Lè ou ap travay ak yon òdinatè ekran ti, tankou yon laptop, oswa Navigasyon yon workbook ki gen done twòp, èske ou janm eseye jwenn yon zòn pi gwo Navigasyon pa aktive ba a sitiyasyon, ba a fòmil ak riban la koupe? Si se konsa, ak sa Zòn travay la ou ka byen vit chanje nan mitan kalite sa yo 3 k ap travay nan gwosè zòn nan Excel ou.


Klike sou Kutools >> Zòn Travay, Al gade nan Ekran:

piki travay zòn 004


L ':

Klike sou Zòn Travay, ou pral gen yon ba ikòn ak bouton 4 ki lokalize sou ekran ou tankou:

Klike sou bouton premye ap Reyajiste Excel ou nan gwosè a nòmal k ap travay nan zòn nan.

Klike sou bouton yo 3 lòt pral chanje nan mitan kalite 3 k ap travay nan gwosè zòn nan Excel ou.


Pou kache ba a sitiyasyon ak yon sèl klike sou

Klike sou bouton an dezyèm, ba a sitiyasyon anba a travayè a ap kache.

Pou kache ba a estati ak ba a fòmil ak yon sèl klike sou

Klike sou bouton an twazyèm, ba a sitiyasyon ak ba a fòmil yo pral kache.

Pou kache riban an, ba a sitiyasyon ak ba a fòmil ak yon sèl klike sou

Klike sou katriyèm bouton an, ba a sitiyasyon, ba fòmil ak riban an ap kache.

piki travay zòn 04


Demo: Kache epi montre riban an, ba estati a ak ba fòmil la nan yon fwa:

Kutools pou Excel: ak plis pase 200 sou la men Excel ajoute-ins, gratis eseye ki pa gen okenn limit nan jou 60. Download ak gratis jijman Koulye a!


Zouti Productivity Rekòmande
Zouti sa yo ka anpil sove tan ou ak lajan, ki yon sèl ki bon pou ou?
Biwo Tab: Sèvi ak onglè sou lamen nan biwo ou, kòm wout la nan Chrome, Firefox ak New Internet Explorer.
Kutools pou Excel: Plis pase 300 Fonksyon avanse pou Excel 2019, 2016, 2013, 2010, 2007 ak Biwo 365.
Klasik Menu pou Biwo: Pote meni yo abitye nan Biwo 2007, 2010, 2013, 2016, 2019 ak 365, tankou si li te Biwo 2000 ak 2003.

Kutools pou Excel

Fonksyonalite ki dekri pi wo a se jis youn nan fonksyon 300 pwisan nan Kutools pou Excel.

Ki fèt pou Excel (Biwo) 2019, 2016, 2013, 2010, 2007 ak Biwo 365. Gratis download epi itilize pou jou 60.

Piki ekran nan Kutools pou Excel

btn li plis btn download achte 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?