How Excel sets the Add Selection box button

How Excel sets the Add Selection box button

How Excel sets the Add Selection box button to see the effect in the diagram, is already added the selection button Excel table, then how to make, please look down.

The button is in the Developer tab of the Excel table, the default installed Excel, this option is not selected, the small set out before an "Excel Add development tool to the toolbar" You can take a look, add the following "Development tools" tab.

After adding the Developer tab, locate the Insert option inside. Here are the selection buttons to add.

Click on the "Insert" option, pop-up Drop-down window, here to find a circle with a small point icon, when the mouse is placed above will show the description.

After clicking, the Excel cursor becomes the shape of the cross, then we find that the selection box has appeared when we select an area in the Excel edit box.

Rename the newly created selection box, and then click on the Excel blank area for the change to take effect.

At this time will make the selection box to the correct location, and the previous production of the selection box alignment, we choose, OK no problem.

Precautions:

Select a box to select only one, check box can be selected.

        more knowledge please focus on triple excel tutorials   columns