Remove Objects from Worksheets in Microsoft Excel
There could be any number of reasons you want to do this:
- You've copied your eBay auctions list and all the silly little rating
stars came over with the data and got pasted into your worksheet
- You want to copy the data from a worksheet somebody else created, and it
had all kinds of fancy macro buttons on it
- You received a workbook that's 10 MB, but the data is only 30 Columns by
10 Rows, so you want to check for "junk" (Yes, I've actually received
workbooks where someone used the Drawing Tools to create borders.)
Try one of three methods.
The easiest to delete them all is EditàGo ToàSpecial,
choose Objects and hit OK. Hit your Delete key.
A way to choose just one or a few is to make sure you're viewing the
Drawing Toolbar (see
this article), and use the Selector tool to select the object(s), then hit
your Delete key.
If neither of the above methods work, it may be a control. Hit ViewàToolbars
and choose Control Toolbox. Turn on Design Mode by clicking the top-left
button. Select the object(s) and hit Delete. Turn Design Mode off when you're
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved