Attendence managing or other works are mostly done on excel but most oof the times typing yes/no becomes really tiring and requires a long time. so here you are going to know about a checkbox management trick. Step 1: Creating the Worksheet As usual, Create a workbook with a worksheet and enter the details there. Step 2: Add Developer Tab Go to the developer tab Beside review tab. If developer Tab is not present, Follow step 3. If it is Present, Jump to Step 4. Step 3: Customize The ribbon Right-Click on ribbon and Click on "Customize The Ribbon" Option. A Dialog Box will open. Check-Mark the Developer Option on the Left Pane and Click Ok. Step 4: Go to Insert Go to Developers tab and click on insert option in controls group. A drop-down will appear. Click on Checkbox option. Step 5: Start Marking Insert the Checkbox in the respective cells. Remove the Text and start marking. Hope This Trick helped you. Be tuned to receive more Tricks, Tips and Information.
An Adda For 360° Digital Ideas
It was really a nice blogππ
ReplyDeleteππ»ππ»
ReplyDeleteGood Infoππ»
ReplyDelete