Automatically translated.View original post

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! ✨

7/30 Edited to

... Read moreExcelでチェックボックスを一瞬で作成し、出欠表や持ち物リストを効率的に管理できる技を知ってから、仕事の時短がぐっと進みました。Altキーから始まるショートカット(Alt → N → C → B)を使えば、わざわざ挿入タブで探す手間が省けてスムーズ。私は特に範囲選択した複数セルにまとめてスペースキーを押してチェックのON/OFFを切り替えられる機能が便利で、手作業の丸付け時間を大幅に短縮できました。 隣のセルに設定する\=IF(チェックボックスのセル,"出席","欠席")という関数も重宝しています。これを使うと、チェックの状態と連動して自動で「出席」や「欠席」が表示されるので、あとでデータをまとめる際に文字入力の手間を省け一目で状況が分かるのも魅力です。私のオフィスでは出欠管理に紙と手書きを使っていたのですが、このExcelテクニックを伝えてからペーパーレス化が進み、ミスも減り、集計作業も内部ネットワークで共有しやすくなりました。 一点注意点としては、チェックボックス挿入機能はMicrosoft 365の最新バージョン以降で利用可能なので、古いExcelユーザーはバージョンを確認しましょう。私も初めて試したとき、バージョン違いで見つからず焦りました。もし使えない場合は、代替でセルに"〇"や"×"の入力を工夫するなどのテクニックもあります。 この方法は覚えると仕事の進みが早く、イベント準備や会議の出欠管理、持ち物チェックリストなどでも役立ちます。操作も直感的で、気軽に試せるので、Excel初心者や業務効率化を目指す方におすすめです。今後もこうした便利な裏技を見つけて投稿していきたいと思いますので、是非コメントやDMでリクエストを送ってくださいね!

Related posts

A Google Sheet displaying an assignment tracker with columns for Class, Assignment, Date Due, and Done. Rows are color-coded by class, and some assignments have checked boxes in the 'Done' column, indicating completion.
A Google Sheet showing a list of Accounting assignments with due dates and checkboxes. An overlay text reads, 'Add all of your classes and assignments!', illustrating the initial setup of the assignment tracker.
A Google Sheet screenshot with the 'Insert' menu open, highlighting the 'Checkbox' option. An overlay text states, 'Add checkboxes to help you get things done!', demonstrating how to add checkboxes for tracking progress.
How I organize my assignments!
Hey there! I'm currently a junior studying at the University of South Florida. I totally get how overwhelming school assignments can be, but I've found a system that works for me! My friends have even commented on how helpful my assignment checklist is, so I thought I'd share it with yo
Mykenzie Hager

Mykenzie Hager

2106 likes

A Google Sheets dashboard titled 'Cost Splitter Dashboard' with financial summaries for multiple individuals. Large text overlay reads 'GOOGLE SHEETS HOW TO ADD IMAGES'.
A Google Sheets screenshot showing the 'Insert' menu with 'Image' highlighted, demonstrating the first step to add images. The text overlay says '1. INSERT > IMAGES'.
A Google Sheets screenshot showing the 'Image' submenu with 'Insert image in cell' and 'Insert image over cells' highlighted. The text overlay says '2. INSERT IMAGE IN CELL OR INSERT IMAGE OVER CELLS'.
👇🏻How I add images in Google Sheets
First Method: 💻 1. Copy and Paste OR Second Method: 🖥️ 1. Go to Insert > Images 🖼️ 2. Insert images ✅ 3. Upload and browse for image from computer These are the steps on a laptop and steps for the Google Sheets App are slightly different but I’ll bring sharing more tips on using
TheHappyPlanner

TheHappyPlanner

287 likes

A desk setup features a monitor displaying the Leiga website with various AI tools and a diagram, and a laptop below it, against an autumn forest background. Text overlay highlights creating to-do lists and diagrams in seconds.
The Leiga website interface showcases free AI tools like SMART Goal Generator, To Do List Creator, and Project Report Creator, alongside a diagram generation example. Text emphasizes getting tasks done faster with AI tools for work and projects.
The Leiga website displays its DiagramGPT feature, showing examples of a flow chart for registration and a state diagram for an order shipping system. Text promotes Leiga's free AI tools for brainstorming, planning, and creating without signup.
Website to create to-do lists, & diagrams in secon
Why stress when AI can do the boring stuff for you?  🤯 Leiga has free tools that handle the hard part - set goals, make to-do lists, create reports, and even turn text into diagrams in seconds.  My fave? DiagramGPT just type, and boom, instant diagrams! No sign-ups, no fees, just AI doing the
Reverelia

Reverelia

84 likes

How to create multiple sizes in Canva
Canva’s New Feature Just Made My Life Easier 😭 Now you can create different sizes in ONE Canva file! No need to start over for every product. I used it to make back-to-school templates in minutes. These are editable Canva templates—instant download, no physical product will be shipped. Wan
CraftedbyTrice

CraftedbyTrice

506 likes

✿˖° how to create a form on Notion
‧°𐐪♡𐑂°‧₊ ☁️ If you’re still using Google forms or other form creators, you might want to check this out instead! Notion recently came out with new features including forms, where you can create and send out forms, surveys, quizzes and more straight from your workspace! This is a mini tutorial
peachiesuga ♡

peachiesuga ♡

65 likes

A pink-themed desk setup featuring a computer monitor displaying a Notion wishlist with columns for item, priority, category, cost, and links. The screen shows items like 'dream experience' and 'nice to have' with prices. The text overlay reads 'How to create a Wishlist in Notion SWIPE TO VIEW'.
A step-by-step guide on creating a new table view database in Notion. It shows typing '/table' to add a basic table block, then selecting 'Table view' from the database options, and finally creating a new blank table.
Instructions on adding columns to the Notion wishlist. It shows how to edit property names like 'item' and add new columns by clicking '+'. It also illustrates selecting different property types such as Text, Number, Select, Multi-select, Date, and Checkbox.
how to create a Wishlist on notion! 🍰
°𐐪♡𐑂°‧₊ 🍵 Here’s a step-by-step tutorial on how I’ve set up my simple notion Wishlist to track things I want to do/buy! I put everything into a table-view database, with columns for what the item is, the price, a link to it, with optional fields such as priority, why you want it, the item categor
peachiesuga ♡

peachiesuga ♡

184 likes

How to Track Habits Using Notion
Tracking Habits in your day to day Life is difficult. Tracking Habits is necessary though as it can improve consistency by a TON. The good news is Notion allows you to do this very easily! Here’s how to Track your Habits Using Notion (🏷️) Tags #notion #notiontemplate #notioninspo #pr
clearconcept

clearconcept

41 likes

A hand holds a smartphone displaying the title slide for a tutorial: "Notion for Caregivers: A Step-by-Step Tutorial." The text "Life of Caregiver" is at the top left, and a "SWIPE" arrow is at the bottom right, indicating more content.
Three Notion mobile screens show the initial steps of a caregiver tutorial. The first covers getting started and creating a dashboard. The second details setting up a Medication & Health Tracker. The third explains setting up reminders and a Doctor Appointments & Medical Notes page.
Three Notion mobile screens continue the caregiver tutorial. The first shows details for Doctor Appointments & Medical Notes. The second outlines setting up a Daily Care Schedule using a Kanban board. The third demonstrates creating an Emergency Contacts & Important Information table.
Notion for Caregivers: A Step-by-Step Tutorial
Caring for a loved one can be overwhelming, with medications, appointments, daily routines, and emotional well-being all needing attention. Notion, a powerful and flexible organization app, can help caregivers manage responsibilities, track health updates, and stay organized. This tutorial will
GrievingGracefully | 💎4life

GrievingGracefully | 💎4life

18 likes

A Notion logo above the title 'How to Progress in Life Using Notion' on a light green background, with Notion interface snippets at the bottom.
Instructions for creating a Notion Habit Tracker: typing '/calendar' to create a calendar database and clicking 'New Template' within the calendar view.
Steps to customize a Notion Habit Tracker template: clicking 'Add a property' and selecting 'Text' as the property type within the template editor.
How to Progress in Life Using Notion
Using Notion to effectively improve your life is very difficult due to hard learning curves. Let me help you Organize and Progress in Life Using Notion! (🏷️) Tags #notion #notiontemplate #notioninspo #notiontips #notionsetup #productivity #productivitytips #productivityh
clearconcept

clearconcept

233 likes

[ How I make calendar databases in Notion]
✨Beginner Friendly!!! 🌸These instructions are for iPad but steps are the same on the desktop version 🌸You can also see assignments you’ve added to this database on the notion calendar app #notion #notionplanning #notionstudent #university #notionideas #notionforstudents #notionplann
IridiumMango

IridiumMango

23 likes

How To Make A Simple Content Planner on Your iPad
Here’s an easy way to make a content planner on your iPad to help you organize your content. This will be a simple, generic tutorial (you can customize it further). 📅 You will need to download Google Sheets from the App Store for this planner. 📅 Once you have Google Sheets installed, your fir
🌻ChromaGlitch

🌻ChromaGlitch

238 likes

How to win Charge backs with Digital Products
Here are a few tips and tricks to help you win chargebacks with your digital product business. #digitalproducttips #digitalproductcreator #digitalproducthacks #digitalproducts #chargebackprotection #winchargebacks #lachelledenise #digitalmarkeringforbeginners #digitalmarkering
Lachelle Denise

Lachelle Denise

11 likes

A Google Sheets bingo card template titled 'MY 2024 BINGO' with a 5x5 grid, checkboxes, and a color dropdown set to 'Coral'. Overlay text explains 'How to make A bingo card In google sheets'.
A laptop screen displaying Google Sheets, illustrating steps to create a bingo card. It shows merging 4 rows (C15 to C18) and adding a checkbox from the 'Insert' menu, with instructions to repeat for a 5x5 grid.
A laptop screen showing Google Sheets, demonstrating how to add a dropdown in cell G2 and populate it with various color names like Aqua, Coral, Green, and Teal for customization.
✨ Use Google Sheets like a Pro - goals bingo card
This is how you can create an interactive Goals Bingo Card in Google Sheets: 1. Merge 4 rows 2. Add a dropdown below it 3. Outline all 5 rows (outer edges only) 4. Add a dropdown for changing color 5. In one of the boxes, add conditioning formatting using this custom formula: =AND(G2=&#3
TheHappyPlanner

TheHappyPlanner

39 likes

Things I learned at the Canva Create Event in L.A.
The canva create event was buzzing with creativity! It was super fun and we came home with so much fun Swag but best of all... KNOWLEDGE 🙌🏼 I love canva for all it's capabilities but going to this event made me realize how I was using #C anva for the most basic stuff when it's so much
Mimi

Mimi

25 likes

Make templates in Goodnotes
Here is a short step by step on how i created my grocery planner template in the Goodnotes app. If you have let me know. #goodnotes #template #plannerideas #tutorial #dailyplanner #grocerylistideas
Kathryn 🌹

Kathryn 🌹

145 likes

A graphic titled '3 BASIC TIPS FOR POSTING ON LEMON8' features a yellow Lemon8 character holding a smartphone displaying the Lemon8 app feed with various posts, including fashion, spring outfits, and food.
A graphic titled 'POST IDEAS' presents six categories: Fashion, Beauty, Food, Home, Travel, and ' & SO MUCH MORE!', each listing several content ideas for Lemon8 posts.
A graphic titled 'READY TO POST' outlines two steps: 'STEP 1: CHOOSE YOUR CONTENT TOPIC' showing a phone screen editing a cover photo, and 'STEP 2: TELL YOUR STORY IN THE CAPTION' showing a phone screen with caption ideas and options to add details.
How to create your first post? ✍️
Ready to post on Lemon8? Here's a quick guide to creating your first post🍋 💛 Use Lemon8 as your personal diary! You'll find an array of topics on the app: fashion, food, beauty, travel, home & more. Check out slide two for more topic inspo ✨ 💛 Once you choose your post topic, make
Lemon8 US

Lemon8 US

1939 likes

This is true inclusion 🤍 The goal isn’t just to make space for someone — it’s to create belonging. The kind where their presence matters so deeply that when they’re missing, the whole group feels off. That’s when inclusion stops being a checkbox and becomes community. Seen. Known. Needed. Lov
Julia Erman

Julia Erman

16 likes

A desk setup featuring a MacBook displaying a Notion page titled 'finances' with a pink aesthetic. The screen shows various Notion elements, and the image has a text overlay 'SWIPE TO VIEW new Notion features'.
A Notion interface demonstrating the new Forms feature, showing a quiz titled 'The Ultimate Army Quiz' with various question types like text, multiple choice, and date, for creating surveys directly in Notion.
A Notion database page showing the 'Customize Layout' feature, allowing users to organize database properties like destination, dates, and trip duration for improved viewing and management.
new Notion features you need to know ✨
‧°𐐪♡𐑂°‧₊ 🍵 Notion recently announced new launches so here’s a breakdown of some of the new features! The first is that you can create your own forms on Notion - particularly useful if you use Notion as a personal/public website for yourself or a business! Another is that you can use “customize la
peachiesuga ♡

peachiesuga ♡

109 likes

🌸 New Notion features you need to know pt 2
‧°𐐪♡𐑂°‧₊ 💭 Some more new/upcoming features Notion announced! Notion is going to be introducing “Notion mail” soon ~ their own mailing service! I’m curious on how this would look and if I’d be intrigued to try it out, especially if it means it’ll be minimalistic and simple to use! 💌 Another is tha
peachiesuga ♡

peachiesuga ♡

480 likes

A Notion logo is displayed above the title 'How to Get Things Done using Notion' on a brown background, with a Notion calendar view partially visible at the bottom.
An image contrasting pen and paper task management (crossed out) with Notion. It shows an illustration of Notion and instructions to type '/table view' to start organizing tasks.
This image illustrates creating a new table in Notion by clicking '+ New table' and then shows a 'Task Manager' table with example tasks listed: 'Task #1', 'Task #2', 'Task #3'.
How to Get Things Done using Notion
You may know what Notion is, but actually learning it so you can use it in your life is a difficult task. 😓 But no need to worry. Here’s how you can actually get things done in your life using Notion 🎯 (🏷️) Tags #notion #notiontemplate #notioninspo #notiontips #notionsetup #pr
clearconcept

clearconcept

43 likes

A person relaxes in a hammock with a laptop, overlaid with the title 'Managing stress' and categories for instant, short term, and long term tips.
A person walks a small dog on a path, with text listing instant stress relief tips: breathing exercises, scrolling Lemon8, and grabbing a treat.
A person takes a mirror selfie, displaying short-term stress management tips: working out, writing thoughts, and gratitude meditation.
instant, short term & long term stress tips!!
what comes from so many different areas in our life so I think the response to stress also has to vary depending on what is needed in that moment sometimes we require a instant reaction or tip to help us with our stress so that is why we have our instant help stress ideas additionally when st
Belle Grubb

Belle Grubb

24 likes

A person's feet in white sneakers on a dark tiled floor, with the text "how to achieve Your goals in 2025 ft. xTiles.app" overlayed, introducing the topic of goal setting.
A laptop screen displays a digital planner showing a "2025 GOALS" page with sections for accomplishments, gratitude, and improvements, illustrating the reflection step for goal setting.
A laptop screen shows a "Wheel of Life" template within a digital planner, with categories for assessing life aspects and setting goals, demonstrating the next step in goal planning.
how to achieve your goals in 2025
How to set goals for 2025 ft. xTiles Set & achieve your goals for 2025 with ease using the xTiles app! Happy 2025! 🥂 Ready to crush your goals this year? Here’s a quick guide featuring the xTiles app - a simple, intuitive tool with many free templates to jumpstart your goal-setting journe
rêves de ju

rêves de ju

10 likes

How to Live a Productive Life using Notion
Living a Productive Life 📓 can be so difficult due to many Distractions 🫨 in Life and Unexpected Events taking time out of a Productive Day. Notion is a great tool though to be able to manage and control your day due to the diverse tools. Here’s how you can Use Notion to Live a Productive Life. 🚀
clearconcept

clearconcept

63 likes

A collage showcasing five Google Sheets dashboards: Content Calendar, Savings Dashboard, Tax Refund Dashboard, Bucket List Bingo, and Net Worth Dashboard, with the title '5 Ways to use Google Sheets'.
A Google Sheets '2024 Content Calendar' dashboard displaying monthly calendars for January and February, including planned and published content, platform goals, and a breakdown of published posts.
A Google Sheets 'Savings Dashboard' titled 'My Cats and Savings', featuring multiple 'Sinking Fund' sections with cartoon cats, savings progress, and a 'Food Shop' tracker.
5 Ways to Use Google Sheets (besides Budgeting)
🗓️ 1. Content Calendar 💰 2. Savings Dashboard 💸 3. Tax Refund Dashboard 🪣 4. Bucket List Bingo 📈 5. Networth Dashboard #googlesheets > #excel #personalfinance #finance #springreset #planner #dayinmylife #personalfinance #savingmoney #budgettemplate
TheHappyPlanner

TheHappyPlanner

512 likes

how to get an instant natural face lift
a good gua sha routine is great for giving yourself a natural lifted look. consistency is key! ✍🏻 tips before starting: - keep your gua sha in the fridge or dip in iced water prior to use for an extra cooling and de-puffing effect - massage your lymph nodes (around your neck, collar bones, nos
sharon ★

sharon ★

17 likes

A woman in athletic wear poses in a gym, with text overlays indicating she won over $100 from Lemon8 by posting her fitness journey. Another person is on a treadmill in the background.
A message congratulating 'jerricaj' for participating in a creator program, mentioning being in the top 50 for fitness and wellness content creators, alongside a list of fitness-related content titles.
A screenshot showing a successful $50 gift card application, resulting in a new balance of $127.79. Below, a section displays various products from a browsing history, including protein drinks.
How I won over $100 from Lemon8
All I do is post my fitness journey 😁😁
Jerrica J

Jerrica J

32 likes

See more