Skip to main content

This Excel Trick will Make your management More easy


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.

Labels:

Comments

Post a Comment

Popular posts from this blog

Digital age: Human and Technology

  The digital age – a world awash in smartphones, social media, and ever-evolving gadgets. It's a time of incredible progress, but also one that raises questions about the human-technology relationship. Are we becoming slaves to our screens, or can technology empower us? There's no denying the convenience technology brings. Imagine researching a project before the internet – a library odyssey compared to today's instant information access. Communication has been revolutionized, allowing us to connect with loved ones across continents with a tap. Technology even enhances creativity, with digital tools for artists, musicians, and writers. However, the line between helpful tool and harmful distraction can easily blur. Social media feeds, designed to be endlessly engaging, can steal hours meant for real-world connection. Information overload can overwhelm, and the pressure to maintain a flawless online persona takes a toll on mental well-being. The key lies in striking a ...
3 comments
Read more

Google Bard is now Google Gemini

  Google bard was an AI model which was developed by google. It can reason across text, image, audio, video and code. But it has been changed to Google Gemini, A more capable AI Model. With this, A new Gemini advanced has been introduced to it. By the recent updates made, Gemini is now capable of interacting in in languages like Japanese, Korean, Spanish, Portuguese, and more. Math problems of all grades are also supported by Gemini. You can now access real-time info from Google apps and services like YouTube, Maps, Flights, and Hotels in over 40 new languages where Gemini is available, including German, Portuguese, Spanish, and more. With the Gmail, Docs, and Drive Extensions, you can even easily find, summarize and get answers even from your personal content.  A preview of Gemini Window You can use Gemini Code Assist in your IDE (such as VS Code, IntelliJ, Cloud Workstations, or Cloud Shell Editor) for AI-powered coding assistance.  Gemini Code Assist can offer ass...
3 comments
Read more