punknsa.blogg.se - Excel how to make check boxes linked to cell

The one pitfall that I could not seem to get around is that fact that after entering in your search text, you need to click outside of the textbox before you can click on the Search button. You can use the alignment tools to make everything look professional with even spacing.

Your mouse should now look like cross hairs and you will just want to click somewhere on your spreadsheet to draw the Option ButtonĪfter you draw a couple of Option Buttons, you can drag them into place so that they are relatively close to your search box.

Select the Option Button Form Control (first row, last icon).

Click the Insert drop down button in the Controls group.

Navigate to your Developer Tab in the Ribbon.

To insert the Option Buttons you will need to

Instead of only allowing your users to filter on a single column, why not let them search through a few? By integrating Option Buttons with your search box you can have your users specify which column they want to search in.