Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default delete group of check box all at once

Hi,
I am Trying to delete lots of check boxes already created in excel. The only
way I know how to do it is by selecting cell by cell by pressing the CRTL key
and then delete. I would like to know if there is a quicker way by just
selecting all cells at once and then delete or something like that

Many thanks for your help

Regards,
Marta
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default delete group of check box all at once

If these are the only objects on the sheet, then try pressing F5 Special
Check "Objects" OK. This will select all the checkboxes at one go for the
deletion.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Marta" wrote in message
...
Hi,
I am Trying to delete lots of check boxes already created in excel. The
only
way I know how to do it is by selecting cell by cell by pressing the CRTL
key
and then delete. I would like to know if there is a quicker way by just
selecting all cells at once and then delete or something like that

Many thanks for your help

Regards,
Marta



  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default delete group of check box all at once

If these are the only objects on the sheet, then try pressing F5 Special
Check "Objects" OK. This will select all the checkboxes at one go for the
deletion.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Marta" wrote:
Hi,
I am Trying to delete lots of check boxes already created in excel. The only
way I know how to do it is by selecting cell by cell by pressing the CRTL key
and then delete. I would like to know if there is a quicker way by just
selecting all cells at once and then delete or something like that

Many thanks for your help

Regards,
Marta

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get plus/minus box of data group at top, not bottom of grp JMSprout Excel Discussion (Misc queries) 0 June 15th 06 06:23 PM
How to get plus/minus box of data group at top, not bottom of grp Ron Coderre Excel Discussion (Misc queries) 0 June 15th 06 06:22 PM
If you delete the contents of a cell in a worksheet in a group, w jmfadg5 Excel Discussion (Misc queries) 1 May 29th 06 06:32 AM
Pivot table to calc by group xlcharlie Excel Discussion (Misc queries) 0 January 24th 06 10:40 PM
Macros to delete check boxes GWB Direct Excel Discussion (Misc queries) 23 June 3rd 05 09:56 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"