قالب وردپرس درنا توس
Home / Tips and Tricks / How to insert a check box in Excel

How to insert a check box in Excel



There are numerous ways to track tasks in Excel. Maybe you put an X at the end of a row or something similar. However, if you have a sheet that you or others need to check off repeatedly, a check box is easier and more professional. Here's how to insert a check box in Excel.

The check box function is actually on the Developer tab, which you need to activate. We'll start with a few quick steps to do that.

Enabling the Developer tab

1. Right click anywhere on the ribbon tab at the top of your screen and select Customize the ribbon .

  checkbox excel 1 [19659002] You can also go through the menu with File> Options> Customize Ribbon to do the same.

2. Select the Main Tabs option from the menu. It will probably be selected by default, but check this again. Now add a check in the box next to the option Developer .

  checkbox excel 2

Now you should be ready to add check boxes and other features on the Developer tab.

How to insert a check box in Excel

For our example, we use a list of contacts. We are going to add a column at the end that indicates a response has been received.

1. Go to the newly added Developer tab and find the option that says Checkbox . It should be in the Form Controls section of the menu.

  checkbox excel 3

2. Click in the cell where you want to place the check box. In our case it is cell E2 because we have four columns of information and the row of headers.

3. The check box appears where you click. To correctly place the box in the cell, hover your mouse over the checkbox until you see a four-pointed arrow. Then drag the box to your cell.

  checkbox excel 4

4. You will notice that the checkbox has a label called Checkbox 1. We don't want that in this case, so right click and select Edit text . Now delete the text.

  checkbox excel 5

5. To copy the check box to the rest of your cells, select the cell (E1) and move your cursor to the corner until you see a thin black cross.

6. Click and drag to the bottom of the row to copy the check box.

  checkbox excel 6

Now you can release your cursor and you should see the row of check boxes that look something like this:

  check box excel 7

Now you know how to insert a check box in Excel, but that's just the beginning of you

Can I do more with Excel?

You can always learn more in Excel, especially since you now have the Developer tab. If you really want to take your skills to the next level, you may want to check out a little in-depth training. Fortunately, we have a technical deals learning pack that contains everything you need to get started.

It's called the Complete Excel Pro Tips Certification Bundle and it contains six unique modules to improve your skills. You can work on practical skills such as pivot tables and formatting that you can easily apply to almost any role. You can also practice some productivity skills in case you want to use Excel to improve your output.

  excel pro tips cert

The complete Excel Pro tips Certification Bundle has a retail value of $ 294, but you can start learning for just $ 19 More than 1,500 other people have already signed up and you can join them for the best price ever.

Find out what's included in the widget below.

$ 19 .00

The Complete Excel Pro Tips Certification Bundle

Save $ 275 .00

Buy Now [19659046] The Complete Excel Pro Tips Certification Bundle Buy Now

Save [19659043] $ 275 .00 $ 19 .00


Source link