How to Create a Checklist in Excel | How to Create a To-Do List in Excel

How to Create a Checklist in Excel | How to Create a To-Do List in Excel

63,327 Просмотров

In this video, we’ll be showing you how to create a checklist in Excel.

Checklists are handy tools to keep track of completed items. If you want to make a checklist in Excel, we’ll show you how to do it! Let’s create a checklist in this spreadsheet.

1. We’ll first need the Developer tab. Right-click anywhere on the top ribbon and click Customize Ribbon.
2. Click the checkbox next to Developer and then OK.
3. Go to the Developer tab and click Insert - Check Box.
4. Click and drag to create the checkbox.
5. You can delete the text by clicking in the box and pressing Escape when done.
6. To fill our list with checkboxes, select the cell with the checkbox. If you cannot select the cell, click next to the cell and then use the arrow keys on the keyboard to move to the correct cell.
7. Hover the cursor over the bottom right of the selection and click and drag to autofill.
8. To delete the checkboxes, hold Ctrl and click each box and then press Delete or Backspace on the keyboard.

You can now make checklists in Excel!

❓💬 What other handy tools do you want to learn to keep track of tasks? Let us know in the comments below.

#HowTech #Excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Facebook https://www.facebook.com/howtechtv
✅ Instagram https://www.instagram.com/howtechprojects
✅ Twitter https://twitter.com/howtechprojects

Тэги:

#howtech #create_checklist_in_excel #insert_a_checkbox_in_excel #add_a_list_of_items_in_excel #add_check_boxes_for_list_items #format_your_checkboxes_in_excel #create_interactive_lists_in_excel #custom_checklist_in_excel #to_do_list_in_excel #drag_cells_with_checkbox #fill_cells_with_checkbox #copy_checkbox_to_other_cells #delete_checkboxes_in_excel #developer_tab_in_excel #insert_a_check_mark_symbol #easy_excel #excel_basics #excel_for_beginners #excel_settings #excel_features
Ссылки и html тэги не поддерживаются


Комментарии:

Naveen Devaraj
Naveen Devaraj - 09.01.2023 06:50

Thanks for the quick tip :)

Ответить
BigArnieGames
BigArnieGames - 03.06.2022 17:19

Thank you for this quick and easy guide. You have earned a like from me!

Ответить
Enrique
Enrique - 30.06.2021 00:48

Hi! I have an equation (a formula) in excel and I want to modify it to get a different variable. It is to calculate the price of a call option (stocks) , but i already have the price, I want to get the formula for finding the volatility. It is quite complex. Would you be able to help me out ? any chance I could send you the excel and you could review?

Ответить
Eat you cereal
Eat you cereal - 22.06.2021 16:31

Does the checkbox give a true/false output you Can detect in other cells?

Ответить