Home > Skills > Data Entry > Objects Excel Worksheet ObjectsHow to add objects, such as shapes and images, to a worksheet. If you copy data from a website, objects might also be copied. See how to list the objects on a sheet, or select and delete them. |
If you copy data from a website, and paste it into Excel, a few objects from the website might also be copied to your Excel sheet. In the screen shot below, there is a "Top of Page" icon -- one of several that was copied along with the data.
This tutorial explains how to find the objects, select them, and quickly delete them.
Watch this video to see how to show a list of objects, and select and delete the objects. Written instructions are below the video.
To see a list of the objects that are on a worksheet, you can open the Selection Pane:
The Selection pane opens, and there is a list of all the objects on the worksheet. Click on an object name, and it will be selected on the worksheet.
To quickly select all the objects on a worksheet, you can use the Go To Special command.
After you select all the objects on a worksheet, or select a single object, you can delete it.
You can insert a shape, such as a rounded rectangle, on a worksheet, to use as button, to run a macro.
To make the shape look more like a button, you can add a Shape Style:
If you plan to make several shapes in the workbook, and want them all to have a bevelled effect, you can change one of the Theme settings.
Now, when you look at the Style Gallery, the bottom row shapes will have a bevelled effect, like the styles had in Excel 2007 and 2010.
To make it clear what the button does, add some text. In this example, the button will run a macro that toggles the column headings, from numbers, to letters, or letters to numbers.
To add text:
To make the macro run a macro that has been stored in the workbook:
NOTE: To select a shape after a macro has been assigned, right-click on the shape.
Get the sample file for the Macro Button tutorial. The zipped file is in xlsm format, and contains macros.
Last updated: January 22, 2023 3:27 PM