提示:其他語言是Google翻譯的。 你可以訪問 English 版本。
登入
x
or
x
x
註冊
x

or

如何輕鬆刪除Excel中的所有圖片或其他對象?

如果要從Microsoft Excel中刪除所有照片,選擇每張照片並逐個刪除照片可能會非常耗時。 以下技巧可能會減輕您的工作,刪除所有圖片:

使用“轉到”命令刪除活動工作表中的所有圖片

使用VBA刪除活動工作表中的所有圖片

使用Kutools for Excel刪除活動工作表/整個工作簿中的所有圖片或其他對象


在列中插入基於單元格值的多個圖片:

Kutools for Excel匹配導入圖片 實用程序,您可以快速輕鬆地插入基於單元格值的匹配圖像。

doc用圖像12替換文本

Kutools for Excel:比200方便的Excel加載項,可以在60天免費試用。 下載並免費試用現在!


箭頭藍色右泡 使用“轉到”命令刪除活動工作表中的所有圖片


運用 轉到 命令可以選擇活動工作表中的所有圖片。 如果我們可以在刪除它們之前選擇所有的圖片,那麼工作變得容易

1。 按 F5 鍵打開 轉到 Excel中的對話框。

2。 點擊 特別 按鈕,並進入 去特別 對話框,然後檢查 對象 選項。 看截圖:

3。 然後點擊 OK 按鈕,在活動工作表中選擇所有照片,按 刪除 鍵刪除所有這些。

筆記:

1。 此方法將選擇活動工作表中的所有對象,如圖片,圖表,形狀等。如果您不想刪除其他對象,則必須在按Delete鍵之前取消選擇其他對象。

2。 此方法只會刪除活動工作表中的圖片。


箭頭藍色右泡 使用VBA刪除活動工作表中的所有圖片

使用VBA宏將幫助您快速刪除活動工作表中的所有圖片。

1。 按住 ALT + F11 在Excel中的鍵,它打開 Microsoft Visual Basic for Applications 窗口。

2。 點擊 插入 > 模塊,並將下面的宏粘貼到模塊窗口中。

Sub DeleteAllPics()
Dim Pic As Object
For Each Pic In ActiveSheet.Pictures
Pic.Delete
Next Pic
End Sub

3。 按 F5 鍵來運行這個宏。 一次刪除活動工作表中的所有圖片。


箭頭藍色右泡 使用Kutools for Excel刪除活動工作表或整個工作簿中的所有圖片

Kutools for Excel's 刪除插圖和對象 無論是在活動工作表還是在整個工作簿中,都可以立即刪除所有圖片。

Kutools for Excel : 與超過300方便的Excel加載項,在60天免費試用沒有限制.

1。 點擊 Kutools > 刪除>刪除插圖和對象 。 看截圖:

2。 在 刪除插圖和對象 對話框:

(1。)檢查 圖片 或其他對象選項中 刪除 部分。

(2。)刪除整個工作簿中的所有圖片,檢查 所有表格 選項 在看 部分; 如果刪除活動表格中的所有圖片,請檢查 活動工作表 選項; 如果刪除特定頁面中的所有圖片,請檢查 選定的工作表 選項。 看截圖:

免費下載Kutools for Excel現在!

3。 點擊 確定。 根據需要,所有照片都已從活動工作表,選定工作表和整個工作簿中刪除。

Kutools for Excel's 刪除插圖和對象 可以幫助我們刪除所有 圖表,線條,圖片,自動形狀,智能藝術,文本框,鏈接的OLE對象 - 嵌入的OLE對象 在活動工作表中,選定的工作表或當前工作簿的所有工作表。
點擊了解更多...

免費下載Kutools for Excel現在!


箭頭藍色右泡 演示:使用Kutools for Excel刪除活動工作表或整個工作簿中的所有圖片

Kutools for Excel:比200方便的Excel加載項,可以在60天免費試用。 下載並免費試用現在!


相關文章:


Kutools for Excel解決了您的大多數問題,並使您的生產率提高了80%

  • 重用: 快速插入 複雜的公式,圖表 以及你以前用過的任何東西; 加密單元格 密碼; 創建郵件列表 並發送電子郵件...
  • 超級方程式酒吧 (輕鬆編輯多行文字和公式); 閱讀佈局 (輕鬆讀取和編輯大量單元格); 粘貼到過濾範圍...
  • 合併單元格/行/列 不丟失數據; 分裂細胞含量; 組合重複的行/列...防止重複的細胞; 比較範圍...
  • 選擇複製或唯一 行; 選擇空行 (所有細胞都是空的); 超級查找和模糊查找 在許多工作簿中; 隨機選擇......
  • 精確複製 多個單元格而不更改公式參考; 自動創建參考 多張表; 插入項目符號,複選框等等......
  • 提取文本,添加文本,按位置刪除, 刪除空間; 創建和打印分頁小計; 在單元格內容和註釋之間轉換...
  • 超級過濾器 (將過濾方案保存並應用到其他工作表); 高級排序 按月/週/日,頻率等; 特殊過濾器 用粗體,斜體......
  • 結合工作簿和工作表; 根據鍵列合併表; 將數據拆分為多個表格; 批量轉換xls,xlsx和PDF...
  • 超過300強大的功能。 支持Office / Excel 2007-2019和365。 支持所有語言。 在您的企業或組織中輕鬆部署。 全功能30天免費試用。
kte tab 201905

Office選項卡為Office提供選項卡式界面,使您的工作更輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,Publisher,Access,Visio和Project。
  • 在同一窗口的新選項卡中打開並創建多個文檔,而不是在新窗口中。
  • 通過50%提高您的工作效率,每天為您減少數百次鼠標點擊!
官方底部
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Sri · 1 months ago
    Thank you for providing this information
  • To post as a guest, your comment is unpublished.
    Edna · 4 months ago
    Thank you so much! You saved my life! ;-)
  • To post as a guest, your comment is unpublished.
    oscar · 7 months ago
    Thank you so very much. Very helpful tool.
  • To post as a guest, your comment is unpublished.
    Oscar Tirado Olmos · 9 months ago
    Gracias eliminé todos los gráficos de la hoja
  • To post as a guest, your comment is unpublished.
    nur · 10 months ago
    terimakasih
  • To post as a guest, your comment is unpublished.
    Keith · 10 months ago
    Brilliant. I was unable to delete an embedded object and lived with it for months before stumbling onto this post. Well done.
  • To post as a guest, your comment is unpublished.
    Juan · 11 months ago
    wow... thanks and thanks.. with the Kutools it was done very easy..
  • To post as a guest, your comment is unpublished.
    Rac amr · 1 years ago
    IT WORKED THANKS!!!! That was the last thing I tried, after so many different test. I have no clue how so many objects came to only one of 7 Worksheet...As someone said previously, you saved my sanity..
  • To post as a guest, your comment is unpublished.
    Enid · 1 years ago
    It worked! Thanks a lot!
  • To post as a guest, your comment is unpublished.
    Guga · 1 years ago
    I was shocked when it worked. Excellent job!
  • To post as a guest, your comment is unpublished.
    Nimmi Kukreti · 1 years ago
    Wow Thank you very much sir/mam. really very easy to delete many logo from my excel work sheet. (go to F5 option is very best) I am very HAPPY...
  • To post as a guest, your comment is unpublished.
    Lyne Sidawi · 1 years ago
    i want to delete pictures from multiple rows, but not all! is there anyway to select which rows i want and delete in one shot ?
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hi, Lyne,
      To delete the pictures only in a selected range, the following code may help you:

      Sub DeletePic()
      Dim xPicRg As Range
      Dim xPic As Picture
      Dim xRg As Range
      Application.ScreenUpdating = False
      Set xRg = Range("A5:B8")
      For Each xPic In ActiveSheet.Pictures
      Set xPicRg = Range(xPic.TopLeftCell.Address & ":" & xPic.BottomRightCell.Address)
      If Not Intersect(xRg, xPicRg) Is Nothing Then xPic.Delete
      Next
      Application.ScreenUpdating = True
      End Sub

      Please change the cell reference to your need.
      Hope it can help you, thank you!
  • To post as a guest, your comment is unpublished.
    kyle · 2 years ago
    Thank you so much for this. Helped me when trying to work with Excel on a Mac and trying to delete multiple objects.
  • To post as a guest, your comment is unpublished.
    fdf · 2 years ago
    Thanks buddy
  • To post as a guest, your comment is unpublished.
    bharath · 2 years ago
    thank you so much


    --thanks
  • To post as a guest, your comment is unpublished.
    Dipak · 2 years ago
    Wow,
    My file was giving me waiting of about 100 seconds in particular commands due to scraps. But now it makes it within a second as original file again.
    Also saved ~20% of the file size to original slim one. TYSM.
  • To post as a guest, your comment is unpublished.
    Musafir · 3 years ago
    GO TO Command helped a lot.
  • To post as a guest, your comment is unpublished.
    Kate · 3 years ago
    Thank you SO MUCH. You have saved my sanity.
  • To post as a guest, your comment is unpublished.
    Shah · 3 years ago
    Thanks a lot.... I am reducing file size from 4MB to 857KB..
  • To post as a guest, your comment is unpublished.
    TX Griff · 3 years ago
    Thank you VERY much... the GO TO solution worked perfectly.

    Oh, one minor glitch... F5 didn't call up the GO TO screen for me, so I GOOGLE'd it and found ctrl-G pulls up the GO TO screen just fine. You might want to put this as an alternative in the instructions.
  • To post as a guest, your comment is unpublished.
    Brasuka · 3 years ago
    this is cool man, thank you!
  • To post as a guest, your comment is unpublished.
    Aloke Ganguli · 3 years ago
    Clearing object element from excel suggestion worked fine. Thanks
  • To post as a guest, your comment is unpublished.
    mike · 3 years ago
    thanks alot awesome very helpful
  • To post as a guest, your comment is unpublished.
    curt · 3 years ago
    not helpful, too bad
  • To post as a guest, your comment is unpublished.
    Sushant Kadam · 3 years ago
    Thanks A Lot ......... :-)
  • To post as a guest, your comment is unpublished.
    Claus · 4 years ago
    Wow - thanks a lot for this handy feature !!
  • To post as a guest, your comment is unpublished.
    Ashenafi · 4 years ago
    If I had known this easy magic 2 days ago, it would saved me 5 hours of work last night; and I wouldn't be as tired as I am right now. Many many thanks!!!
  • To post as a guest, your comment is unpublished.
    Trump · 4 years ago
    thanks dude. You just saved me loads of time.

    if you were close, i'd give you a glass of origin :P
  • To post as a guest, your comment is unpublished.
    misbips · 4 years ago
    I found in Office 2013 that if you have a worksheet open if you have any drawn items and graphics on the worksheet, you can select one graphic, hold down CTRL + A and it will select them all. Then you can delete them.
  • To post as a guest, your comment is unpublished.
    Junaid Khan · 4 years ago
    [b]THANX ALOTTTTTT...[/b]
  • To post as a guest, your comment is unpublished.
    Mahendra Singh · 5 years ago
    HI,

    i am unable to remove the picture from excel 2003,
  • To post as a guest, your comment is unpublished.
    Alex1234 · 5 years ago
    thank you very much, it saved me a lot of time and nerves
  • To post as a guest, your comment is unpublished.
    # Kami · 5 years ago
    It was driving me crazy. Thanks for useful information. It saved me a lot of time.
  • To post as a guest, your comment is unpublished.
    Damir · 5 years ago
    Thanks man,

    You gotta drink when you come in Zagreb!
  • To post as a guest, your comment is unpublished.
    mari athens greece · 5 years ago
    Thank you! Thank you! Thank you! 1st choise...easy and so time saving
  • To post as a guest, your comment is unpublished.
    Ramesh Koli · 5 years ago
    F5 shortcut and macro are really useful. Thanks for sharing such useful information.
    Regards
  • To post as a guest, your comment is unpublished.
    MOHD NASEEM · 5 years ago
    Thanks for help. :-)
  • To post as a guest, your comment is unpublished.
    Awsomesause · 5 years ago
    The was freaking awesome!!!!
  • To post as a guest, your comment is unpublished.
    Dean · 5 years ago
    Thank you so much, this was driving me mad!
  • To post as a guest, your comment is unpublished.
    Mina Roque · 5 years ago
    H. DO you know how can I delete pictures in the whole workbook except for the pictures in first tab?
  • To post as a guest, your comment is unpublished.
    F.Rehman · 5 years ago
    Thanks alot, save precious time
  • To post as a guest, your comment is unpublished.
    Dede_ · 5 years ago
    Super easy and quick, that's how I like my solutions!

    Thanks a bunch!
  • To post as a guest, your comment is unpublished.
    sao · 5 years ago
    thx buddy, really helps me. 8)
  • To post as a guest, your comment is unpublished.
    Shruthi · 5 years ago
    It helps me alot thank q so much :-)
  • To post as a guest, your comment is unpublished.
    thadson · 5 years ago
    Right on! Easy and effective! You are tha man... :-)
  • To post as a guest, your comment is unpublished.
    jelaoufi · 5 years ago
    Thanks a lot ... ur the best !!!!
  • To post as a guest, your comment is unpublished.
    j8mie · 5 years ago
    Thanks for posting up this tip. You have saved me so much time.
  • To post as a guest, your comment is unpublished.
    PHANINDRA SHARMA · 5 years ago
    Thanks..........................................
  • To post as a guest, your comment is unpublished.
    Prakash · 5 years ago
    Thanks a Lot Saved my time.
  • To post as a guest, your comment is unpublished.
    yogesh bhatia · 5 years ago
    Excellent ! Helped a lot in office work.