Skip i'r prif gynnwys

Sut i guddio rhesi gwag yn PivotTable yn Excel?

Fel y gwyddom, mae tabl colyn yn gyfleus inni ddadansoddi'r data yn Excel, ond weithiau, mae rhywfaint o gynnwys gwag yn ymddangos yn y rhesi fel y dangosir isod. Nawr, byddaf yn dweud wrthych sut i guddio'r rhesi gwag hyn yn nhabl colyn yn Excel.

doc-cuddio-gwag-pivottable-1

Cuddio rhesi gwag yn y bwrdd colyn

swigen dde glas saeth Cuddio rhesi gwag yn y bwrdd colyn

I guddio rhesi gwag mewn tabl colyn, does ond angen i chi hidlo'r labeli rhes.

1. Cliciwch wrth y saeth wrth ochr y Labeli Row yn y tabl colyn.

doc-cuddio-gwag-pivottable-2

2. Yna mae rhestr yn ymddangos, cliciwch y blwch isod Dewis maes a dewiswch y maes sydd ei angen arnoch i guddio ei resi gwag, a dad-wirio (gwag). Gweler y screenshot:

doc-cuddio-gwag-pivottable-3

3. Cliciwch OK. Nawr mae'r rhesi gwag wedi'u cuddio.

doc-cuddio-gwag-pivottable-4

Tip: Os ydych chi am ddangos y rhesi gwag eto, does ond angen i chi fynd yn ôl i'r rhestr a gwirio'r blwch gwirio (gwag).

Erthyglau Perthynas:

Offer Cynhyrchiant Swyddfa Gorau

Nodweddion Poblogaidd: Darganfod, Amlygu neu Adnabod Dyblygiadau   |  Dileu Rhesi Gwag   |  Cyfuno Colofnau neu Gelloedd heb Colli Data   |   Rownd heb Fformiwla ...
Super-edrych: VLookup Meini Prawf Lluosog  |   VLookup Gwerth Lluosog  |   VLookup Ar Draws Taflenni Lluosog   |   Edrych Niwlog ....
Rhestr gwympo Uwch: Creu Rhestr Gollwng yn Gyflym   |  Rhestr Gollwng Dibynnol   |  Rhestr Gollwng Aml-ddewis ....
Rheolwr Colofn: Ychwanegu Nifer Penodol o Golofnau  |  Symud Colofnau  |  Toglo Statws Gwelededd Colofnau Cudd  |  Cymharwch Ystodau a Cholofnau ...
Nodweddion dan Sylw: Ffocws ar y Grid   |  Golwg Dylunio   |   Bar Fformiwla Mawr   |  Rheolwr Llyfr Gwaith a Thaflen   |  Llyfrgell Adnoddau (Testun Auto)   |  Dewiswr Dyddiad   |  Cyfuno Taflenni Gwaith   |  Amgryptio/Dadgryptio Celloedd   |  Anfon E-byst trwy Restr   |  Hidlo Super   |   Hidlo Arbennig (hidlo mewn print trwm/italig/strikethrough...) ...
15 Set Offer Gorau:  12 Testun offer (Ychwanegu Testun, Dileu Cymeriadau,...)   |   50 + Siart Mathau (Siart Gantt,...)   |   40+ Ymarferol Fformiwlâu (Cyfrifwch oedran yn seiliedig ar ben-blwydd,...)   |   19 mewnosod offer (Mewnosod Cod QR, Mewnosod Llun o'r Llwybr,...)   |   12 Trosi offer (Rhifau i Eiriau, Trosi arian cyfred,...)   |   7 Uno a Hollti offer (Rhesi Cyfuno Uwch, Celloedd Hollt,...)   |   ... a mwy

Supercharge Eich Sgiliau Excel gyda Kutools for Excel, a Phrofiad Effeithlonrwydd Fel Erioed Erioed o'r blaen. Kutools for Excel Yn cynnig dros 300 o nodweddion uwch i hybu cynhyrchiant ac arbed amser.  Cliciwch Yma i Gael Y Nodwedd Sydd Ei Angen Y Mwyaf...

tab kte 201905

Office Tab Yn dod â rhyngwyneb Tabbed i Office, ac yn Gwneud Eich Gwaith yn Haws o lawer

  • Galluogi golygu a darllen tabbed yn Word, Excel, PowerPoint, Cyhoeddwr, Mynediad, Visio a Phrosiect.
  • Agor a chreu dogfennau lluosog mewn tabiau newydd o'r un ffenestr, yn hytrach nag mewn ffenestri newydd.
  • Yn cynyddu eich cynhyrchiant 50%, ac yn lleihau cannoedd o gliciau llygoden i chi bob dydd!
Comments (8)
No ratings yet. Be the first to rate!
Vincent
Vincent
This comment was minimized by the moderator on the site
I type zero (0) for all the blank cell and it fixed.
Reply
0
0
Manishankar
Manishankar
This comment was minimized by the moderator on the site
Yes, I have found a workaround to give multiple criteria.

1. First of all, I grouped those rows which I wanted hide from the pivot.
2. Then, excel adds duplicate field to our data by adding a number to it.
3. You need to remove the old field from the rows area.
4. Now, apply label filter as "does not equal to Group1"
5. That's it.

All the best.
Reply
0
0
Alli
Alli
This comment was minimized by the moderator on the site
BIG THANKS!! I have been searching for this answer for a couple of hours - nothing was working. That is all I wanted to do - just HIDE it if I couldn't get rid of it any other way (and I couldn't). New to pivot tables, so I really appreciate simple answers!
Reply
0
0
lsaez
lsaez
This comment was minimized by the moderator on the site
I just tried with a "label filter", including values that are NOT blank (when the filter asks for a value I input nothing).

That did the trick.
Reply
0
0
Stephen
Stephen
This comment was minimized by the moderator on the site
It is important to note that this is not a solution for pivot tables linked to changing data. When you de-select any entry, even (blank), the list is fixed to the number of items checked, and if updating the data brings in more items, the pivot table will not include them.
Reply
0
0
Herman
Herman     Stephen
This comment was minimized by the moderator on the site
Hi Stephen,


Im looking for a work around for this where the data is actually changing. Do you know of a possible solution?
Reply
0
0
Guest1
Guest1     Herman
This comment was minimized by the moderator on the site
Any luck? I've been trying to find the same work around.
Reply
0
0
lsaez
lsaez     Guest1
This comment was minimized by the moderator on the site
I just tried with a "label filter", including values that are NOT blank (when the filter asks for a value I input nothing).

That did the trick.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations