How to Insert Checkbox in Excel
In this step-by-step tutorial, learn how to add a checkbox to your worksheet in Microsoft Excel. Checkboxes are a great way to add interactivity and functionality to your Excel worksheets. In this video, I’ll show you how to insert checkboxes and how to link them to cells. By linking a checkbox to a cell, you can use the state of the checkbox (checked or unchecked) in functions, formulas, and conditional formatting. For example, you can create a dynamic to-do list that shows the progress of your tasks based on the checkboxes. Checkboxes are easy to use and can make your Excel work more fun and efficient.
📚 RESOURCES
- CTRL + D to fill checkbox down to multiple cells
- CTRL + 1 to launch format control
⌚ TIMESTAMPS
00:00 Introduction
00:17 Insert a checkbox
02:18 Insert multiple checkboxes
02:51 Link checkbox to cell
05:24 Use checkbox with countif function
07:09 Use checkbox with conditional formatting
08:02 Use checkbox with filter function
10:52 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel
Видео How to Insert Checkbox in Excel канала Kevin Stratvert
📚 RESOURCES
- CTRL + D to fill checkbox down to multiple cells
- CTRL + 1 to launch format control
⌚ TIMESTAMPS
00:00 Introduction
00:17 Insert a checkbox
02:18 Insert multiple checkboxes
02:51 Link checkbox to cell
05:24 Use checkbox with countif function
07:09 Use checkbox with conditional formatting
08:02 Use checkbox with filter function
10:52 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel
Видео How to Insert Checkbox in Excel канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![WordPress Tutorial for Beginners](https://i.ytimg.com/vi/UT3No6nswz8/default.jpg)
![5 Windows Tricks You Probably Didn't Know #windows11](https://i.ytimg.com/vi/s6icvlrKM6M/default.jpg)
![How to Make Pivot Chart in Excel](https://i.ytimg.com/vi/0WstANBX-Gk/default.jpg)
![How to Copy Text from Image using Snipping Tool](https://i.ytimg.com/vi/g3ttI9umzoo/default.jpg)
![How To Use Voice Typing in Word and Google Docs](https://i.ytimg.com/vi/cz2L-jQfOiA/default.jpg)
![The NEW OneDrive - Tutorial in 20 min](https://i.ytimg.com/vi/prA75mu3arc/default.jpg)
![PowerPoint Tutorial in 20 min](https://i.ytimg.com/vi/l5Ij7nUy9UQ/default.jpg)
![How to VLOOKUP in Excel in 1 min #excel](https://i.ytimg.com/vi/L92k_Mscu0s/default.jpg)
![How to Remove Background in Photo #windows](https://i.ytimg.com/vi/fAwVN9M4dm0/default.jpg)
![BEST PDF Editor - 2023](https://i.ytimg.com/vi/NfpAolo8tdw/default.jpg)
![Best Windows Shortcuts in under 1 min](https://i.ytimg.com/vi/E9rUzuGfpT0/default.jpg)
![Best Excel Shortcuts in under 1 min](https://i.ytimg.com/vi/mS_nbbwRmuc/default.jpg)
![How to Make Gantt Chart in Excel](https://i.ytimg.com/vi/zC22yPmc6Kw/default.jpg)
![5 Must Know YouTube Tricks](https://i.ytimg.com/vi/GCCmiIcwslM/default.jpg)
![How to Record PowerPoint Presentation as Video](https://i.ytimg.com/vi/8MwD3MQxTuk/default.jpg)
![How to Make Cartoon Character in PowerPoint](https://i.ytimg.com/vi/VbhfCerWDV4/default.jpg)
![How to Use Microsoft Designer](https://i.ytimg.com/vi/1rXSsRIxdVo/default.jpg)
![How to use Teleprompter in PowerPoint](https://i.ytimg.com/vi/dQF8oz49KQQ/default.jpg)
![How to Copy Text from Image](https://i.ytimg.com/vi/WOYkAVwm3u8/default.jpg)
![How to Use Cameo in PowerPoint](https://i.ytimg.com/vi/R83iUBWh4_0/default.jpg)
![Useful Windows feature no one knows 🤔](https://i.ytimg.com/vi/gJn7kPFet_w/default.jpg)