ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   delete group of check box all at once (https://www.excelbanter.com/excel-discussion-misc-queries/106824-delete-group-check-box-all-once.html)

Marta

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

Max

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




Max

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



All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com