How to quickly delete all html objects in Excel?

How to quickly delete all html objects in Excel?

Delete all objects in worksheet with Go To Special command

With this Go To Special command, you can select all of the objects either the html objects or Excel objects first, and then with the Delete key to remove them.

1. Click Home > Find & Select > Go To Special, see screenshot:

 

 2. In the Go To Special dialog box, click Objects, and then click OK.

 

 3. And all of the objects have been selected, then press Delete key on the keyboard. The selected objects have been removed. see screenshots:

 

作者:Chuck Lu    GitHub
posted @   ChuckLu  阅读(61)  评论(0)  编辑  收藏  举报
编辑推荐：
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识（上）
· 浏览器原生「磁吸」效果！Anchor Positioning 锚点定位神器解析
· 没有源码，如何修改代码逻辑？
阅读排行：
· 全程不用写代码，我用AI程序员写了一个飞机大战
· DeepSeek 开源周回顾「GitHub 热点速览」
· MongoDB 8.0这个新功能碉堡了，比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15：你的「微服务管家」又秀新绝活了
历史上的今天：
2019-02-03 Understanding and Creating OWIN Middlewares - Part 1
2019-02-03 What is OWIN? A Beginners Guide
2015-02-03 如何从List<T>中筛选符合条件的数据的集合或个数
点击右上角即可分享
微信分享提示