How to delete multiple checkboxes in excel

Go To command can select many types of control including the checkboxes, if your worksheet has only checkboxes control object, the method can help you select the multiple checkboxes and delete them at once.
1. Click Home > Find & Select > Go To Special, and a Go To Special dialog box will appear. See screenshot:

2. Then choose the Objects option from the Select. Click OK.
3. And all of the checkboxes have been selected, and then press Delete key on the keyboard.
4. All of the checkboxes will be deleted.
Note: If there are other objects in the same worksheet, this method will delete them as well.

Again, you can delete multiple checkboxes with VBA code
The following short VBA code also can remove the multiple checkboxes. Please do as the following steps:
1. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module:

Sub RemoveCheckboxes()
On Error Resume Next
ActiveSheet.CheckBoxes.Delete
Selection.FormatConditions.Delete
End Sub

2. Then click button to execute the code. And all of the checkboxes have been deleted.

Resource: http://www.extendoffice.com/documents/excel/877-excel-delete-multiple-checkboxes.html

Insert diameter into line tage number

 

Basic formular:

 

Most convinient formular:
=SUBSTITUTE(A1,"-","-"&B1&"-",3)

How to search content in excel files (without open the files)

Sometimes, we do need to know if we have submitted the particular issue (some word, or numbers) in whole bunches of files. but we can not open the files one by one.
Through Google, a gentleman share his great idea.
I organized by my understanding, and wrote the follow steps:

1) open a file folder

2) click "tool"

 

3) click "folder option"

 

4) click "search", then "always search file names and contents".

5) click "ok".

Now, go to windows explor, click "start", then type the drawing number you're searching for.
See what's happen.