Skip to main content

Conas cairt / pictiúr / cnaipe a chosc ó bhogadh in Excel?

In Excel, cuirimid roinnt rudaí isteach i gcónaí, mar shampla cairteacha, pictiúir nó cnaipí agus mar sin de chun an bhileog oibre a dhéanamh níos beoga agus níos soiléire. Ach, nuair a tharraingíonn tú na cealla faoi na rudaí seo, beidh na rudaí ar snámh ag bogadh nó ag athrú méid leis na cealla go huathoibríoch. Conas a d’fhéadfá na rudaí seo a chosc ó athrú méide nó bogadh in Excel?

Cosc a chur ar chairt / pictiúr / cnaipe ó bhogadh in Excel 2007/2010

Cosc a chur ar chairt / pictiúr / cnaipe ó bhogadh in Excel 2013

mboilgeog cheart gorm saighead Cosc a chur ar chairt / pictiúr / cnaipe ó bhogadh in Excel 2007/2010

Má tá Excel 2010/2007 agat, is féidir leat an post seo a réiteach leis na céimeanna seo a leanas:

1. Roghnaigh do réad sonrach ar mhaith leat é a chosc ó athrú méide nó bogadh, agus cliceáil déanta sa ribín, ansin cliceáil doc-stad-cairt-ag gluaiseacht2 cnaipe sa méid grúpa, féach ar an scáileán:

doc-stad-cairt-ag gluaiseacht1

2. Sa dialóg popped out:

(1.) In Excel 2010, roghnaigh Airíonna rogha ón bpána ar chlé, agus ansin seiceáil Ná bog ná déan méid le cealla, féach ar an scáileán:

doc-stad-cairt-ag gluaiseacht1

(2.) In Excel 2007, cliceáil Airíonna tab, agus roghnaigh Ná bog ná déan méid le cealla rogha.

doc-stad-cairt-ag gluaiseacht1

3. Ansin cliceáil Dún cnaipe, agus nuair a tharraingíonn tú na cealla an chéad uair eile, ní bheidh na rudaí ag bogadh ná ag athrú méid níos mó.

mboilgeog cheart gorm saigheadCosc a chur ar chairt / pictiúr / cnaipe ó bhogadh in Excel 2013

Tá beagán difríochtaí ann maidir leis na hairíonna a shocrú in Excel 2013 ó Excel 2007/2010, déan mar seo le do thoil:

1. Roghnaigh do réad sonrach ar mhaith leat é a chosc ó athrú méide nó bogadh, agus cliceáil déanta sa ribín, ansin cliceáil doc-stad-cairt-ag gluaiseacht2 cnaipe sa méid grúpa, féach ar an scáileán:

doc-stad-cairt-ag gluaiseacht1

2. Sa phána popped amach, cliceáil Méid & Airíonna deilbhín, agus seiceáil Ná bog ná déan méid le cealla rogha faoi PROPERTIES alt, féach an pictiúr:

doc-stad-cairt-ag gluaiseacht1

3. Tar éis duit an socrú a athrú, ansin dún an phána.

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

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á!
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