How to Create a Checkbox in an Instant

How was this post? 💡

If you think "This is convenient!," please save it so that you can look back later 📌

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

I didn't know 🔥

I knew 👍

I made it ✨

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

[Attendance table display changes in a moment in the check ✅]

They go out of their way to print and circle by hand for attendance and check their belongings...

It can be completed in Excel 😊

Moreover, you do not need to input "attendance / absence" by yourself ✨

Here is a technique that you can use once 👇

① Select the cell you want to put the check box

↓

② Press Alt → N → C → B in order

This completes the check box

↓

③ Switch to half-width and space key

✔ ON / OFF is switched (if you select a range, ✔ together for a moment)

↓

"④ In the next cell = IF (check box cell," "Attendance," "" "Absence" ")"

✔ "Attendance" and "Absence" switch automatically

↓

⑤ Select and Delete when you want to delete

You can delete all at once

⚠️ checkbox is a feature of Microsoft 365 (latest Excel). If you can't find it in the Insert tab, please check the version 🙏

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

[🎁 Please let me hear your voice!]

Do you have petit stress such as "I want to make it easier here..." or "I'm worried about this" in your usual work?

If you let me know in the comments or DM, I will do my best to make a solution in a future post!

Please feel free! ✨