跳到主要內容

如何防止圖表/圖片/按鈕在Excel中移動?

在Excel中,我們總是插入一些對象,例如圖表,圖片或按鈕等,以使工作表更生動,更清晰。 但是,當您將單元格拖動到這些對像下方時,浮動對象將自動隨單元格移動或調整大小。 如何防止這些對像在Excel中調整大小或移動?

防止圖表/圖片/按鈕在Excel 2007/2010中移動

防止圖表/圖片/按鈕在Excel 2013中移動


箭頭藍色右氣泡 防止圖表/圖片/按鈕在Excel 2007/2010中移動

如果您擁有Excel 2010/2007,則可以通過以下步驟解決此任務:

1。 選擇要防止調整大小或移動的特定對象,然後單擊 格式 在功能區中,然後單擊 文檔停止圖表移動2 按鈕在 尺寸 組,請參見屏幕截圖:

文檔停止圖表移動1

2。 在彈出的對話框中:

(1.)在Excel 2010中,選擇 氟化鈉性能 從左窗格中選擇,然後檢查 不要移動或調整單元格的大小,請參見屏幕截圖:

文檔停止圖表移動1

(2.)在Excel 2007中,單擊 氟化鈉性能 選項卡,然後選擇 不要移動或調整單元格的大小 選項。

文檔停止圖表移動1

3。 然後點擊 關閉 按鈕,當您下次拖動單元格時,對象將不再移動或調整大小。


箭頭藍色右氣泡防止圖表/圖片/按鈕在Excel 2013中移動

與Excel 2013/2007相比,在Excel 2010中設置屬性存在一些差異,請執行以下操作:

1。 選擇要防止調整大小或移動的特定對象,然後單擊 格式 在功能區中,然後單擊 文檔停止圖表移動2 按鈕在 尺寸 組,請參見屏幕截圖:

文檔停止圖表移動1

2。 在彈出的窗格中,單擊 大小和屬性 圖標,然後檢查 不要移動或調整單元格的大小 選項下 性能 部分,請參見屏幕截圖:

文檔停止圖表移動1

3。 更改設置後,然後關閉窗格。

最佳辦公生產力工具

熱門特色: 尋找、突出顯示或識別重複項   |  刪除空白行   |  合併列或儲存格而不遺失數據   |   沒有公式的回合 ...
超級查詢: 多條件VLookup    多值VLookup  |   跨多個工作表的 VLookup   |   模糊查詢 ....
高級下拉列表: 快速建立下拉列表   |  依賴下拉列表   |  多選下拉列表 ....
欄目經理: 新增特定數量的列  |  移動列  |  切換隱藏列的可見性狀態  |  比較範圍和列 ...
特色功能: 網格焦點   |  設計圖   |   大方程式酒吧    工作簿和工作表管理器   |  資源庫 (自動文字)   |  日期選擇器   |  合併工作表   |  加密/解密單元格    按清單發送電子郵件   |  超級濾鏡   |   特殊過濾器 (過濾粗體/斜體/刪除線...)...
前 15 個工具集12 文本 工具 (添加文本, 刪除字符,...)   |   50+ 圖表 類型 (甘特圖,...)   |   40+ 實用 公式 (根據生日計算年齡,...)   |   19 插入 工具 (插入二維碼, 從路徑插入圖片,...)   |   12 轉化 工具 (數字到單詞, 貨幣兌換,...)   |   7 合併與拆分 工具 (高級合併行, 分裂細胞,...)   |   ... 和更多

使用 Kutools for Excel 增強您的 Excel 技能,體驗前所未有的效率。 Kutools for Excel 提供了 300 多種進階功能來提高生產力並節省時間。  點擊此處獲取您最需要的功能...

kte選項卡201905


Office選項卡為Office帶來了選項卡式界面,使您的工作更加輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,發布者,Access,Visio和Project。
  • 在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
  • 將您的工作效率提高 50%,每天為您減少數百次鼠標點擊!
Comments (13)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
How to prevent the object from getting dragged, while still allowing to activate?
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).
This comment was minimized by the moderator on the site
Done and Thanks...
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.
This comment was minimized by the moderator on the site
you're a genius! thanks!!
This comment was minimized by the moderator on the site
The "solution" does not work.
This comment was minimized by the moderator on the site
Any way to do this with a Pivot table?
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.
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.
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
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.
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.
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.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations