Скачать или смотреть Add a checkbox in excel and make it control your workbook

In this beginners excel tutorial we take a look at how to add a checkbox or tickbox into excel. It also shows you how you can make these perform an action in your workbook depending on whether the box is ticked or now. In this example we show how to strikethrough text when a task is ticked as complete. Creating dynamic workbooks with checkboxes in excel is quick and easy! Take your spreadsheet knowledge to the next level with this easy tutorial.

0:00 Introduction
0:21 Enabling the developer tab
0:40 Adding a checkbox
1:46 Copying and aligning your checkboxes
2:14 Linking your checkbox to a cell
3:14 Adding conditional formatting based on checkbox
3:58 Copying linked textboxes - caution
4:45 Close

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Want to learn some more advanced sort and other excel tricks? Check out our dynamic arrays and functions playlist:    • Dynamic Arrays and Functions  

Or here are some other videos on conditional formating; check them out!
CONDITIONAL FORMATTING - an introduction tutorial:    • Excel for beginners: CONDITIONAL FORMATTIN...  
Conditional formatting a row:    • Excel for beginners: Conditional formattin...  
Excel icon sets, custom icon sets and conditional formatting in excel (and excel CHAR function):    • Excel icon sets, custom icon sets and cond...