Skip i'r prif gynnwys

Sut i atal siart / llun / botwm rhag symud yn Excel?

Yn Excel, rydyn ni bob amser yn mewnosod rhai gwrthrychau, fel siartiau, lluniau neu fotymau ac ati i wneud y daflen waith yn fwy bywiog ac eglur. Ond, pan fyddwch chi'n llusgo'r celloedd o dan y gwrthrychau hyn, bydd y gwrthrychau arnofio yn symud neu'n newid maint gyda'r celloedd yn awtomatig. Sut allech chi atal y gwrthrychau hyn rhag newid maint neu symud yn Excel?

Atal siart / llun / botwm rhag symud yn Excel 2007/2010

Atal siart / llun / botwm rhag symud yn Excel 2013

swigen dde glas saeth Atal siart / llun / botwm rhag symud yn Excel 2007/2010

Os oes gennych Excel 2010/2007, gallwch ddatrys y swydd hon gyda'r camau canlynol:

1. Dewiswch eich gwrthrych penodol yr ydych am ei atal rhag newid maint neu symud, a chlicio fformat yn y rhuban, yna cliciwch doc-stop-siart-symud2 botwm yn y Maint grŵp, gweler y screenshot:

doc-stop-siart-symud1

2. Yn y dialog popped allan:

(1.) Yn Excel 2010, dewiswch Eiddo opsiwn o'r cwarel chwith, ac yna gwirio Peidiwch â symud na maint gyda chelloedd, gweler y screenshot:

doc-stop-siart-symud1

(2.) Yn Excel 2007, cliciwch Eiddo tab, a dewis Peidiwch â symud na maint gyda chelloedd opsiwn.

doc-stop-siart-symud1

3. Yna cliciwch Cau botwm, a phan lusgwch y celloedd y tro nesaf, ni fydd y gwrthrychau yn symud nac yn newid maint mwy.

swigen dde glas saethAtal siart / llun / botwm rhag symud yn Excel 2013

Mae ychydig o wahaniaethau o ran gosod yr eiddo yn Excel 2013 o Excel 2007/2010, gwnewch fel hyn:

1. Dewiswch eich gwrthrych penodol yr ydych am ei atal rhag newid maint neu symud, a chlicio fformat yn y rhuban, yna cliciwch doc-stop-siart-symud2 botwm yn y Maint grŵp, gweler y screenshot:

doc-stop-siart-symud1

2. Yn y cwarel popped allan, cliciwch Maint a Phriodweddau eicon, a gwirio Peidiwch â symud na maint gyda chelloedd opsiwn o dan EIDDO adran, gweler y screenshot:

doc-stop-siart-symud1

3. Ar ôl newid y gosodiad, yna caewch y cwarel.

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 (13)
No ratings yet. Be the first to rate!
John
John
This comment was minimized by the moderator on the site
How to prevent the object from getting dragged, while still allowing to activate?
Reply
0
0
John
John
This comment was minimized by the moderator on the site
"Don't move or size with cells" DOESN'T prevent user from dragging the object around. It only prevents the object from moving if rows or columns are resized, or if cells are moved around. The only way to prevent the object from getting dragged is to lock it, and then protect the worksheet (but then you can't activate the object).
Reply
0
0
Ashan D.
Ashan D.
This comment was minimized by the moderator on the site
Done and Thanks...
Reply
0
0
elvis99317
elvis99317
This comment was minimized by the moderator on the site
if you are using office 365, make sure you save it as the new excel format. .xslx

i was using an existing form from the company which was saved using format 97-2003 .xls

once i save into the new format it stop resizing my pictures. hope this helps.
Reply
0
0
Annie
Annie     elvis99317
This comment was minimized by the moderator on the site
you're a genius! thanks!!
Reply
0
0
Rocket
Rocket
This comment was minimized by the moderator on the site
The "solution" does not work.
Reply
0
0
Kayla
Kayla
This comment was minimized by the moderator on the site
Any way to do this with a Pivot table?
Reply
0
0
Bill
Bill
This comment was minimized by the moderator on the site
This worked in Office 2010, but I am now using Office 365. Excel is totally disregarding the "Don't move or resize ..." selection. When a spreadsheet is opened, graphics are stretching to what appears to be random aspect ratios no matter that "Don't move or resize ..." AND "Lock aspect ratio" are BOTH checked. I am using the latest version of Windows 10 and the latest version of Office 365 as of August 2016. This bug is killing me. I am going to be forced back to Office 2007.
Reply
1
0
Jenny
Jenny     Bill
This comment was minimized by the moderator on the site
Has this been solved? Am trying to move graphics as I sort the data. graphics are well within the cell size. move and don't resize checked.
Reply
0
0
sadasivam73@gmail.com
    Bill
This comment was minimized by the moderator on the site
Yes. This is exactly an issue only in Office 365. The only work around that i have noticed is to copy the entire printable content page by page into Word file and from that i have printed as PDF and it worked but really tedious if we have to work with multiple pages. Microsoft should fix this bug at the earliest.
Thanks Sada Sivam Manickavasagam
Reply
Report
0
0
Lilly
Lilly     Bill
This comment was minimized by the moderator on the site
I use Office 365 and my excel has the same problem. Hope someone can fix this bug sooner.
Reply
0
0
Barry
Barry     Bill
This comment was minimized by the moderator on the site
I am having this same issue, and it's a real pain, as I need a tree map for a daily report and don't want to constantly readjust each day before publishing.
Reply
0
0
zoom38
zoom38
This comment was minimized by the moderator on the site
Regardless of the settings, once you use print preview, the objects constantly move and resize on the worksheet in Excel 2010.
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