Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Conas gach bileog oibre agus bileog in Excel a chur ar neamhní?

Soláthraíonn an t-alt seo roinnt modhanna chun gach bileog agus bileog oibre i bhfolach in Excel a chur ar leataobh céim ar chéim.

  1. Unhide gach bileog oibre i bhfolach ceann ar cheann in Excel
  2. Cuir gach bileog oibre i bhfolach de réir chód VBA
  3. Cuir gach bileog oibre i bhfolach le Kutools le haghaidh Excel le cliceáil amháin
  4. Unhide gach bileog oibre i bhfolach de réir gné Infheictheachta Bileoga Oibre Hidden
  5. Cuir gach bileog oibre an-fholaithe le Kutools le haghaidh Excel

Unhide gach bileog oibre i bhfolach ceann ar cheann in Excel

Is féidir linn an Bileog Unhide gné chun bileog oibre i bhfolach a chur ar neamhní ag am in Excel. Déan mar a leanas le do thoil:

1. Cliceáil Baile > déanta > Folaigh & Unhide > Bileog Unhide. Féach an pictiúr:
nótaí: Is féidir leat cliceáil ar dheis freisin ar aon cheann d’ainmneacha bileog sa bharra cluaisín Bileog, agus roghnaigh Unhide ón roghchlár comhthéacs.

2. Anois tá gach bileog oibre i bhfolach liostaithe sa Unhide bosca dialóige. Roghnaigh an bhileog oibre is mian leat a thaispeáint, agus ansin cliceáil ar an OK cnaipe.

3. Ansin taispeántar an bhileog i bhfolach roghnaithe. Déan arís thuas Céim 2 chun gach bileog oibre neamhcheadaithe a thaispeáint ceann ar cheann.

nótaí: Níl gach bileog oibre i bhfolach chomh simplí agus is féidir nuair a bhíonn na céadta bileog i bhfolach ann ní foláir iad a chur ar neamhní. B’fhéidir go mbeidh ort an luch a chliceáil na céadta uair chun na hoibríochtaí a athdhéanamh. Más mian leat bealach níos éasca a fháil, déan é de réir na nósanna imeachta a sholáthraíonn na modhanna seo a leanas.

Togáil Infheictheacht Bileog Oibre Hidden - Cliceáil amháin chun na bileoga ceilte uile a chur ar neamhní, agus cliceáil amháin chun iad a chur i bhfolach i bhfolach

Leis an gcnaipe scoránaigh áisiúil de Bileoga oibre arna sholáthar ag Kutools le haghaidh Excel, is féidir leat cliceáil amháin chun gach bileog oibre i bhfolach sa leabhar oibre gníomhach a thaispeáint, agus cliceáil arís chun gach bileog oibre i bhfolach a scoránaigh a bheith dofheicthe. Triail Saor in Aisce Gné Iomlán 30 lá!
scoránaigh ad bileoga seithí a thaispeáint

Kutools le haghaidh Excel - Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel. Triail saor in aisce gné iomlán 30 lá, níl aon chárta creidmheasa ag teastáil! Get sé anois

Cuir gach bileog oibre i bhfolach de réir chód VBA

Is féidir leis an gcód gairid VBA seo a leanas cabhrú leat gach ceann de na bileoga ceilte a thaispeáint ag an am céanna.

1. Coinnigh síos an Alt + F11 eochracha in Excel, agus osclaíonn sé an Microsoft Visual Basic d’Fheidhmchláir fhuinneog.

2. Cliceáil Ionsáigh > Modúil, agus greamaigh an macra seo a leanas i bhFuinneog an Mhodúil.

Sub UnhideAllSheets()
	Dim ws As Worksheet

	For Each ws In ActiveWorkbook.Worksheets
		ws.Visible = xlSheetVisible
	Next ws

End Sub

3. Brúigh an F5 eochair chun an macra seo a rith. Agus taispeánfar na bileoga i bhfolach ag an am céanna.


Cuir gach bileog oibre i bhfolach le Kutools le haghaidh Excel le cliceáil amháin

Kutools le haghaidh Excel's Unhide Gach Bileog Hidden d’fhéadfadh gné cabhrú leat na bileoga ceilte uile a thaispeáint go héasca gan ach cliceáil amháin.

Kutools le haghaidh Excel - Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel. Triail saor in aisce gné iomlán 30 lá, níl aon chárta creidmheasa ag teastáil! Get sé anois

cliceáil Kutools > Taispeáin / Folaigh > Unhide Gach Bileog Hidden, féach ar an scáileán:

Ansin taispeántar gach bileog i bhfolach ag an am céanna. Féach an pictiúr:

nótaí: Léiríonn an uimhir a thaispeánann tar éis na feidhme líon iomlán na mbileog oibre i bhfolach i do leabhar oibre. Mura bhfuil aon bhileog oibre i bhfolach, casfaidh an fheidhm liath agus ní féidir cliceáil uirthi.

Leis seo áisiúil Unhide Gach Bileog Hidden gné, is féidir leat gach bileog oibre i bhfolach a thaispeáint gan ach cliceáil amháin in Excel. Bíodh Triail In Aisce agat!


Unhide gach bileog oibre i bhfolach de réir gné Infheictheachta Bileoga Oibre Hidden

Soláthraíonn Kutools for Excel áisiúil freisin Bileoga oibre (Toggle Infhaighteacht Bileoga Oibre Hidden) gné chun gach bileog oibre i bhfolach a thaispeáint nó a cheilt gan ach cliceáil amháin sa leabhar oibre gníomhach.

Kutools le haghaidh Excel - Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel. Triail saor in aisce gné iomlán 30 lá, níl aon chárta creidmheasa ag teastáil! Get sé anois

Faoi Kutools cluaisín, cliceáil le do thoil ar an Bileog Oibre cnaipe chun gach bileog oibre i bhfolach a thaispeáint, agus cliceáil ar an Bileoga oibre cnaipe arís chun stádas i bhfolach a athbhunú.

Bileoga oibre scoránaigh bileoga oibre infheictheacht. Cliceáil amháin chun na bileoga ceilte uile a thaispeáint, agus cliceáil eile chun iad a cheilt arís. Bíodh Triail In Aisce agat!


Cuir gach bileog oibre an-fholaithe le Kutools le haghaidh Excel

Uaireanta ní féidir leis na modhanna thuas na bileoga oibre i bhfolach a chur ar neamhní. Sin toisc go bhfuil na bileoga oibre seo i bhfolach go mór. Sa chás seo, is féidir leat gné Leabhair Oibre agus Bileoga Folaigh / Unhide de Kutools a chur i bhfeidhm le haghaidh Excel chun iad a chur ar neamhní go tapa.

Kutools le haghaidh Excel - Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel. Triail saor in aisce gné iomlán 30 lá, níl aon chárta creidmheasa ag teastáil! Get sé anois

1. Cliceáil Kutools > Taispeáin / Folaigh > Folaigh / Folaigh Leabhair Oibre agus Bileoga.

2. Sa dialóg Folaigh / Folaigh Leabhair Oibre agus Bileoga, cliceáil le do thoil chun an leabhar oibre gníomhach a roghnú, agus cliceáil ar an Unhide go léir cnaipe sa Bileoga alt. Féach an pictiúr.

Anois tá gach bileog oibre i bhfolach lena n-áirítear na cinn an-fholaithe ar taispeáint ar an mórchóir. Dún an dialóg de réir mar is gá duit.

Folaigh / Folaigh Leabhair Oibre agus Bileoga mórleabhair oibre oscailte agus a mbileoga oibre a cheilt nó a cheilt ar an mórchóir, lena n-áirítear na cinn an-fholaithe. Bíodh Triail In Aisce agat!


Cuir gach bileog oibre i bhfolach le Kutools le haghaidh Excel le cliceáil amháin


Kutools le haghaidh Excel Cuimsíonn sé níos mó ná 300 uirlis áisiúil le haghaidh Excel, saor in aisce le triail gan teorainn i 30 lá. Íoslódáil agus Triail In Aisce Anois!

Earraí gaolmhara


Na hUirlisí Táirgiúlachta Oifige is Fearr

Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%

  • Athúsáid: Cuir isteach go tapa foirmlí casta, cairteacha agus aon rud a d'úsáid tú roimhe seo; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin gan Sonraí a chailleadh; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna / Colúin Dúblacha... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Níos mó ná 300 gné chumhachtach. Tacaíochtaí Office / Excel 2007-2019 agus 365. Tacaíonn sé le gach teanga. Imscaradh éasca i d’fhiontar nó d’eagraíocht. Gnéithe iomlána triail saor in aisce 30 lá. Ráthaíocht ar ais airgid 60 lá.
cluaisín kte 201905

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun officetab
Say something here...
symbols left.
You are guest
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.
    Corex · 1 years ago
    it is showing "he Worksbook structure is password protected.!! How to proceed further?
  • To post as a guest, your comment is unpublished.
    jO · 4 years ago
    Nice but can't scroll using mouse wheels. Very bad UX.
  • To post as a guest, your comment is unpublished.
    Prafull · 4 years ago
    Thanks a Lot for Sharing VB COde
  • To post as a guest, your comment is unpublished.
    Steph · 4 years ago
    This is very helpful. Thanks!

    Is there VBA code I can use to unhide all hidden rows/columns across all tabs at once?
  • To post as a guest, your comment is unpublished.
    aromAz · 4 years ago
    this thread is very helpful. Thanks!
  • To post as a guest, your comment is unpublished.
    Tony G · 4 years ago
    Nice Job!!!!
    I unhide all sheets in one shot!!! cool!!!!!

    Tkz

    Unhide multiple sheets!!!!

    Unhide all hidden worksheets by VBA code

    The following short VBA code also can help you display all of the hidden sheets at the same time.

    1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

    2. Click Insert > Module, and paste the following macro in the Module Window.


    Sub UnhideAllSheets()
    Dim ws As Worksheet

    For Each ws In ActiveWorkbook.Worksheets
    ws.Visible = xlSheetVisible
    Next ws

    End Sub

    3. Press the F5 key to run this macro. And the hidden sheets will be displayed at once.
  • To post as a guest, your comment is unpublished.
    Rudolph · 4 years ago
    Is there a faster way than just pasting that code ?
  • To post as a guest, your comment is unpublished.
    Harun · 5 years ago
    Awesome! I was looking; "how to unhide all sheets in excel at once" and I've learned to getting things done the right way. Thank you so much.
  • To post as a guest, your comment is unpublished.
    Sparky · 5 years ago
    This was great...Took seconds to copy and paste the code and nano-seconds to unhide 30 sheets..

    Thanks
  • To post as a guest, your comment is unpublished.
    Jamie · 5 years ago
    Whenever I click any function in kutools tab the entire workbook just closes - please help!
  • To post as a guest, your comment is unpublished.
    Neil · 5 years ago
    The VBA saved my A$s
  • To post as a guest, your comment is unpublished.
    Kamal · 5 years ago
    Thank you so much...VBA command worked, saved so much of my time! :)
  • To post as a guest, your comment is unpublished.
    gater · 6 years ago
    This week was the first I've encountered needing to unhide many, many, many worksheets and it's frustrating that Excel doesn't have what seems to be an easy option for that! Anyway, searched for an answer and your link was in the top five....worked like a charm and I am NOT macro literate by any means! THANK YOU!
  • To post as a guest, your comment is unpublished.
    Eve · 6 years ago
    I followed the following, however, it still did not open the hidden sheets.

    Unhide all hidden worksheets by VBA code
    The following short VBA code also can help you display all of the hidden sheets at the same time.

    1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

    2. Click Insert > Module, and paste the following macro in the Module Window.

    12345678 Sub UnhideAllSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = xlSheetVisible Next ws End Sub
    3. Press the F5 key to run this macro. And the hidden sheets will be displayed at once.


    --------------------------------------------------------------------------------
    • To post as a guest, your comment is unpublished.
      Derick · 5 years ago
      Make sure the 12345678 are not being copied. I didn't think I was copying them but I was getting an error because they were showing up after I ran the code. I went and deleted them (after they showed up) and re-ran the code. You will get a warning that the previous operation will be undone (or something). Just hit ok, and it should work.
  • To post as a guest, your comment is unpublished.
    Sunny · 6 years ago
    Great Job I used that VBA option to unhide all the sheets in just one click and it works thank you so much for your valuable advice.
  • To post as a guest, your comment is unpublished.
    krupa · 6 years ago
    I used the Unhide all hidden worksheets by VBA code. Pretty simple for basic user like me
    Thanks
  • To post as a guest, your comment is unpublished.
    NK · 6 years ago
    Thanks a lot. Saved me a lot of time under pressure :-)
  • To post as a guest, your comment is unpublished.
    Ola · 6 years ago
    Thanks! Using the macro saved me alot of time! Unreal they dont have a built in solution for this.
    • To post as a guest, your comment is unpublished.
      Troy · 6 years ago
      [quote name="Ola"]Thanks! Using the macro saved me alot of time! Unreal they dont have a built in solution for this.[/quote]
      It's a Microsoft product...I'm sure they will steal, err, I mean borrow the idea and claim it as their own soon enough. :0)
  • To post as a guest, your comment is unpublished.
    JACK · 6 years ago
    COOl! thanks for sharing very helpful.. meme square
  • To post as a guest, your comment is unpublished.
    Rose · 6 years ago
    The marco option worked perfectly! Thank You
  • To post as a guest, your comment is unpublished.
    Markus · 7 years ago
    Thanks for this! Great!
  • To post as a guest, your comment is unpublished.
    latha · 7 years ago
    Thanks you so much !!! this code is awesome!!!
  • To post as a guest, your comment is unpublished.
    Panicos · 7 years ago
    Thanks. The macro worked and saved me a lot of time
  • To post as a guest, your comment is unpublished.
    mtariqraheem · 7 years ago
    Thanks..... this code saved my 30 mins.
  • To post as a guest, your comment is unpublished.
    Dena · 7 years ago
    THANK YOU!!! The macro worked like a charm!
  • To post as a guest, your comment is unpublished.
    ravi shanakar · 7 years ago
    Thnaks. helped a lot
  • To post as a guest, your comment is unpublished.
    Adam · 7 years ago
    Excellent! Macro worked perfectly. It really doesn't make sense that MS did not build this in.
    • To post as a guest, your comment is unpublished.
      Troy · 6 years ago
      [quote name="Adam"]Excellent! Macro worked perfectly. It really doesn't make sense that MS did not build this in.[/quote]

      Yeah, no kidding. So simple. Oh well, at least it can be added to the default so it will work in all workbooks. :0)
  • To post as a guest, your comment is unpublished.
    Tom · 7 years ago
    Worked like a charm!

    Love always,
    Tom
  • To post as a guest, your comment is unpublished.
    Victor · 7 years ago
    Excelent, saved me more than enough time to post this "thank you post".
    • To post as a guest, your comment is unpublished.
      Troy · 6 years ago
      [quote name="Victor"]Excelent, saved me more than enough time to post this "thank you post".[/quote]

      Ditto...saved me more than enough time to post a 'Thank you'!

      Troy
  • To post as a guest, your comment is unpublished.
    Diane · 7 years ago
    I downloaded so that I could try all features before I purchased. Tried to unhide all sheets in a workbook but that option is greyed out. Consequently, I had to unhide them one by one.
    • To post as a guest, your comment is unpublished.
      Tom · 7 years ago
      [quote name="Diane"]I downloaded so that I could try all features before I purchased. Tried to unhide all sheets in a workbook but that option is greyed out. Consequently, I had to unhide them one by one.[/quote]It works fine. Get your s### together Diane! With lots of Love, Tom
    • To post as a guest, your comment is unpublished.
      Admin_jay · 7 years ago
      [quote name="Diane"]I downloaded so that I could try all features before I purchased. Tried to unhide all sheets in a workbook but that option is greyed out. Consequently, I had to unhide them one by one.[/quote]

      Please get in touch with me. Or please make sure you have downloaded and installed the latest version from this link: http://www.extendoffice.com/downloads/KutoolsforExcelSetup.exe

      Contact me:Jaychivo#extendoffice.com, replace # with @.

      :-)
  • To post as a guest, your comment is unpublished.
    Diane · 7 years ago
    Downloaded free to try and it would not unhide all the worksheets at the same time, still had to do it 1 by 1. Would love it if it worked.
  • To post as a guest, your comment is unpublished.
    Luis · 7 years ago
    awesome! saved me 15 mins of worthless unhiding of sheets, done in 1 min...appreciate it!
    • To post as a guest, your comment is unpublished.
      nancy · 6 years ago
      thank you so much - this was a huge time saver for me. :D
    • To post as a guest, your comment is unpublished.
      Harinder · 7 years ago
      This was great. Saved me atleast 30 mins from clicking the same buttons again n again