Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete clip art from cell in spreadsheet
I have tried "cut" and I have tried to "delete" clip art I inserted in cells
in an EXCEL spreadsheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete clip art from cell in spreadsheet
Select it, them press the Delete key.
bamagirl wrote: I have tried "cut" and I have tried to "delete" clip art I inserted in cells in an EXCEL spreadsheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete clip art from cell in spreadsheet
Try this small macro:
Sub NoArt() For Each s In ActiveSheet.Shapes s.Delete Next End Sub Macros are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To remove the macro: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To use the macro from Excel: 1. ALT-F8 2. Select the macro 3. Touch RUN To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu201001 "bamagirl" wrote: I have tried "cut" and I have tried to "delete" clip art I inserted in cells in an EXCEL spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clip art in my Excel spreadsheet resizes itself after printing! | Excel Discussion (Misc queries) | |||
How to insert clip art into a cell and have it sortable | Excel Discussion (Misc queries) | |||
Clip Art/Spreadsheet | Excel Discussion (Misc queries) | |||
How do you assign clip art to a cell? | Excel Worksheet Functions | |||
Clip Art in spreadsheet | Excel Discussion (Misc queries) |