Skip i'r prif gynnwys

Sut i analluogi clic dwbl ar ffin y gell yn Excel?

Fel rheol, rydym yn clicio ddwywaith ar gell i olygu cynnwys y gell, fodd bynnag, mae'r cyrchwr yn neidio i waelod data'r daflen waith oherwydd gallwch glicio ar ffin y gell yn ddamweiniol fel y dangosir y screenshot a ddangosir. Gall hyn fod yn annifyr os oes sawl rhes, dylech sgrolio i fyny i'r gell sydd wedi'i chlicio. Yr erthygl hon, byddaf yn siarad am sut i analluogi clic dwbl ar ffin celloedd yn Excel.

doc analluogi clic dwbl 1

Analluoga cliciwch ddwywaith ar ffin y gell i neidio i'r gwaelod

swigen dde glas saeth Analluoga cliciwch ddwywaith ar ffin y gell i neidio i'r gwaelod

I analluogi clic dwbl ar nodwedd ffin celloedd, gallwch fynd i'r Dewisiadau Excel i ffurfweddu opsiwn, gwnewch fel hyn:

1. Cliciwch Ffeil > Dewisiadau i fynd i'r Dewisiadau Excel blwch deialog.

2. Yn y Dewisiadau Excel blwch deialog, cliciwch Uwch opsiwn o'r cwarel chwith, ac yna dad-diciwch y Galluogi handlen llenwi a llusgo a gollwng celloedd opsiwn o dan y Golygu opsiynau, gweler y screenshot:

doc analluogi clic dwbl 2

3. Yna cliciwch OK i gau'r blwch deialog hwn, ac yn awr, mae clic dwbl ar nodwedd ffin celloedd yn anabl ar unwaith.

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 (22)
Rated 5 out of 5 · 1 ratings
peterthegreate
peterthegreate
This comment was minimized by the moderator on the site
This is why i use LibreOffice whenever possible!

#Linuxforever
Reply
0
0
Rated 5 out of 5
aa
aa
This comment was minimized by the moderator on the site
goooddddddddd
Reply
0
0
wtf
wtf
This comment was minimized by the moderator on the site
This feature was brought to you by a dedicated Microsoft excel developer called Mr. Inconvenience
Reply
0
0
James
James
This comment was minimized by the moderator on the site
I'd like to echo the comments here. I have this problem but I cant use this solution without it stopping me doing very useful things. It should be a simple task to decouple these options so we could turn the individual function off, and it feels like only laziness is stopping MS from fixing it.
Reply
0
0
Ashley
Ashley
This comment was minimized by the moderator on the site
The only solution I know of is using F2 instead of double clicking.
Reply
0
0
MandyZhou
MandyZhou     Ashley
This comment was minimized by the moderator on the site
Hello Ashley,

Thanks for your comment. You are right. When you want to edit in an Excel cell, you can simply press the F2 to edit the cell. But for some users like me, we are used to double-click the cell to edit. Different habits, I guess. Have a nice day.

Sincerely,
Mandy
Reply
Report
0
0
BÁRBARA
BÁRBARA
This comment was minimized by the moderator on the site
MIL GRACIAS ME TENIA ENFERMA ESA PORQUERIA!!!
Reply
0
0
Jim Deveau
Jim Deveau
This comment was minimized by the moderator on the site
The description of the concern is exactly what I want to fix, but the solution they give fixes something else.
Reply
0
0
Congratulations
Congratulations
This comment was minimized by the moderator on the site
Hi Microsoft, It's 2021-11-20 and this problem still exists. To put these two different functions under the same tap is irresponsible. This is very basic things...
Reply
0
0
skyyang
skyyang     Congratulations
This comment was minimized by the moderator on the site
Hello,This is indeed inconvenient for most of users, if you have any other good solution, please comment and share here.Thank you!
Reply
Report
0
0
wtf is this
wtf is this
This comment was minimized by the moderator on the site
wtf is this? why? why do you have to couple a completely useless feature with a super useful one so you can only enable or disable them both at the same time?
Reply
0
0
skyyang
skyyang     wtf is this
This comment was minimized by the moderator on the site
Hello, Yes, as you said, this is very inconvenient for most of users. But, there seems to be no other good solution for dealing with this problem.Thanks for your comment.
Reply
Report
0
0
ben
ben
This comment was minimized by the moderator on the site
Could agree with the other comments, why Microsoft are making there programs worse and worse and worse consistently these days I have no idea. Windows and Office is the only MS software I use now but I think that is going to change very soon.
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations