Table of Contents
This tip is about the how to Make a Checklist in MS Excel. So read this free guide, How to Make a Checklist in MS Excel step by step. If you have query related to same article you may contact us.
How to Make a Checklist in MS Excel – Guide
Creating a checklist will help you keep track of many everyday things. For example, a checklist can help you remember what to take with you when traveling or what ingredients are available when making a recipe. However, not everyone is familiar with spreadsheets and may find it difficult to create a checklist in Excel. This post explains how to create a checklist in excel and some tips on how to integrate with others. Checklists are a great tool for optimizing efficiency and improving productivity. They’re especially good at making sure you don’t forget an important task or valuable item. Essentially, all you need to create a checklist is a piece of paper and a pen. but knowing how to creating one using other media can be a pretty cool skill.
Creating a checklist via Microsoft Excel requires using the checkbox control. Checkboxes are often used when creating forms, but in this case they can also be used to create a checklist. Microsoft Excel is a software program manufactured by Microsoft that allows users to organize, format, and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite. Like other Microsoft Office products, Microsoft Excel can now be purchased through the cloud via subscription through Office 365.
How to Make a checklist in MS Excel
Activate the Developer tab
To create a checklist, you must enable the Developer tab on the ribbon. To do this, right-click on the ribbon and select Customize Ribbon. In the list of main tabs on the right side of the Excel Options dialog box, check the Developer box and click OK.
Insert checklist items into your worksheet
Type your to-do list, one item per cell. In our example, we have a cell with Total Items and another with total Packaged Items, or how many items are checked in our list. After checking all items, the Am I ready to go? cell turns green and reads YES. Click on the Developer tab. Then click Insert in the Controls section and click the Checkbox (Form Control).
Add the checkboxes
Click in the cell where you want to insert the checkbox. You will see that there is text to the right of the selection box. We only want the text box, not the text. While the checkbox control is selected, highlight the text next to the checkbox and delete it. The checkbox control does not automatically resize after you delete the text in it. If you want to resize it, right-click the cell to select the checkbox, then left-click the checkbox (to make the context menu disappear).
Drag one of the circles on the right towards the selection box to resize the outline to just the size of the selection box. Then you can move the selection box to the center of the cell with the four-pointed cursor. Now we want to copy this checkbox to the rest of our to-do list items. To select the cell that contains the check box, select any cell around it without a check box. Then use one of the keyboard arrow keys to move to the cell with the checkbox.
To copy the checkbox to the other cells, move the cursor over the lower right corner of the cell selected with the checkbox until it changes to a plus sign. Make sure the cursor is NOT a hand. This will check the box. Drag the plus sign down over the cells where you want to copy the checkbox and release the mouse button. The checkbox is copied to all these cells.
Final note
I hope you like the guide How to Make a Checklist in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.