NEW Check Box in Excel (it's Awesome)✅

Рет қаралды 7,590

Күн бұрын

Excel has released a new checkbox feature, and it's incredible.
In this video, I will show you how to insert a checkbox in Excel and use it to create interactive lists and charts.
I will also cover how to use formulas with checkboxes to extract information about cells and use them with functions such as FILTER.
00:00 Intro
00:28 Insert Check Box in Excel + Interactive List
03:12 Using Conditional Formatting with Checkboxes in Excel
06:14 Using Checkboxes in Formulas
08:42 Creating Interactive Chart with Checkbox in Excel
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 52

@trumpexcel 6 ай бұрын

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@AmeDatman 6 ай бұрын

Good job as usual. I have a spreadsheet with dates and data reference in adjoining columns. Could check boxes be used to only display whatever date is checked?

@rajeevgosavi4514 5 ай бұрын

Sumitji, I have still not received this new checkbox version in my Office 365 yet. Please guide me how would I go about making interactive Chart with Company A,B & C. Thanks in advance for your response.

@IvanCortinas_ES 6 ай бұрын

Absolutely powerful and essential for the company. Thanks for sharing. Great explanation, Sumit.

@trumpexcel 6 ай бұрын

Thansk Ivan. I have been a huge fan of these in-cell checkboxes in Google Sheets, and so happy they are now in Excel. They are so much better than the Form and ActiveX control Check Box that were already in Excel

@jonminer9891 6 ай бұрын

hello. I liked and am already subscribed. Thanks for your diligence. Thanks for sharing! Stay Healthy!

@trumpexcel 6 ай бұрын

Thanks for being a subscriber :)... Glad you found the video useful!

@joycenaicker6251 6 ай бұрын

Thank you for sharing. It is very helpful.

@trumpexcel 6 ай бұрын

Thanks for commenting... Glad you found the video useful :)

@mcbasak 6 ай бұрын

Thanks Sumit. Very simply and nicely explained the use of check box in excel.

@jagilliland 5 ай бұрын

Nice examples well explained.

@bertvantol9669 6 ай бұрын

GREAT !!! Thanks !!

@trumpexcel 6 ай бұрын

Glad you found the video useful :)

@rajeevgosavi4514 5 ай бұрын

Great , nicely explained

@Blade7248 4 ай бұрын

THANK YOU

@ersureshnarain9770 6 ай бұрын

Good one Sumit! This is going to be useful to me.

@trumpexcel 6 ай бұрын

Thanks for commenting Suresh... I am also going to use checkbox a lot more as they are now easy to insert and remain in the cell

@SyedMuzammilMahasanShahi 6 ай бұрын

Thanks for the share.

@trumpexcel 6 ай бұрын

Glad you found the video useful :)

@Teamchevy001 6 ай бұрын

Thanks for sharing Sumit! Nice little trick! Dave

@trumpexcel 6 ай бұрын

Thanks for commenting... Glad you found the video useful :)

@ATNEB 6 ай бұрын

Thanks for the share

@vickysharma5423 6 ай бұрын

Very helpful dear

@almajdco1203 6 ай бұрын

thanks

@floppyfeet426 6 ай бұрын

Hey man thank you for your videos. If I'm sure you get this all the time. But they have helped me so much. God bless for your content. Is a question if you have time. I was wondering if you have a video on full screen mode ? I'm trying to make an excel dashboard, but i'm trying to make it mimic like a real application. I was wondering if there was any way to make it auto full screen ? Only for that template, so it looks like a real application rather than an excel spreadsheet. Like on startup. So you start the application. It's full screen mode, then you end the application and that full screen mode. No longer affects anything else. Like if you opened a different work book it wouldn't be in full screen still. If you have any advice I would be very appreciative.

@trumpexcel 6 ай бұрын

Thank you so much for the kind words 😊 Regarding your question, try adding this VBA code in the ThisWorkbook object. So open VB Editor and double click on the ThisWorkbook object in the Project Explorer. If you don't see Project Explorer, click on View and then click on the Project Explorer option. Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application .DisplayFullScreen = False .DisplayFormulaBar = True .DisplayStatusBar = True End With With ActiveWindow .WindowState = xlMaximized End With End Sub Private Sub Workbook_Open() With Application .DisplayFullScreen = True .DisplayFormulaBar = False .DisplayStatusBar = False End With With ActiveWindow .WindowState = xlMaximized End With End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application .DisplayFullScreen = False .DisplayFormulaBar = True .DisplayStatusBar = True End With With ActiveWindow .WindowState = xlMaximized End With End Sub Private Sub Workbook_Open() With Application .DisplayFullScreen = True .DisplayFormulaBar = False .DisplayStatusBar = False End With With ActiveWindow .WindowState = xlMaximized End With End Sub Hope this works!!

@floppyfeet426 6 ай бұрын

@@trumpexcel Thanks a bunch !!

@subhabratade93 6 ай бұрын

Most youubers do not reply in comments...you are totally amazing in that section..🎉🎉 But 2013 main kaise isko laye?? Iske upor kuch madat ho sakta hain Sunitji??

@pandharinathjoshi6565 6 ай бұрын

Nice sir

@sravankumar4860 6 ай бұрын

Hello Sir. Can you please do the videos on Powerbi and more videos on power query.

@trumpexcel 6 ай бұрын

I did a whole course on Power Query. You can find it here - kzfaq.info/sun/PLm8I8moAHiH1_n4Y1wE0seb-htscpN9o6 Will make some Power BI videos soon

@younimoon9567 5 ай бұрын

hi, thanks for your video is so helpful, but on my computer i can't find this option i can inset numbers of check boxes, even i am using the 365, thanks

@shirazhassen1108 Ай бұрын

I have still not received this new checkbox version in my Office 365 yet. Please guide me how to get it

@meniporat3527 5 ай бұрын

A simple trick: If you inserted a checkbox in, say A2, and you want cells A3:A20 to have checkboxes too, you don't need to repeat the process: Insert-> Cell Controls-> Checkbox. All you have to do is select cells A2:A20 and press: CTRL+D. That's all

@juhanikolehmainen6324 6 ай бұрын

How to enable a check box in Excel 365 desktop version.

@kumbi8368 5 ай бұрын

I was using the new checkboxes fine, but now they have been disabled. I don't know if there is a setting which I messed with which I wasn't supposed to, or I don't know if Microsoft is doing something in the background. But the checkbox feature is greyed out, and all the checkboxes I placed on my worksheet are replaced with true or false values.

@orhanersoy456 5 ай бұрын

I am using 365 and latest updates are done (2401) But this option is not avalible on my excel. You know why?

@michaelallen7172 4 ай бұрын

Same, I'm even using the business premium license. It's still not in mine too

@meniporat3527 5 ай бұрын

A much simpler formula to count the number of TRUE values in a range of checkboxes: instead of =COUNTIF(B2:B12,TRUE) Simply write: =SUM(--B2:B12)

@trumpexcel 5 ай бұрын

Yeah, this is easier when you want to count the number of YES. I showed the COUNTIF function as I also wanted to show how to count the Unchecked boxes, where FALSE equates to 0.

@meniporat3527 5 ай бұрын

@@trumpexcel In order to count the FALSE you can use the following formula: =SUM(--NOT(B2:B12))

@shadulmd4338 6 ай бұрын

Hello sir your god 🙏❤

@michaelallen7172 4 ай бұрын

hi is this already available?

@trumpexcel 4 ай бұрын

It's available for most users of Microsoft 365. Should be available for all M365 users soon (if not already)

@michaelallen7172 4 ай бұрын

it's not yet available in mine and i'm using the business premium 365 in excel, it's the highest license supposedly. i keep updating to the latest verson but this isn't available yet. Do they have a tentative date for all users to have access to this?

@trumpexcel 3 ай бұрын

I am not sure if they have a date. They do roll out these new features to personal-level subscription before rolling it out for enterprise-level subscriptions

@mathsindeep107 6 ай бұрын

In my excel this option is not available. Why?

@trumpexcel 6 ай бұрын

Are you using Excel with Microsoft 365? It's only available with M365 subscription

@mathsindeep107 6 ай бұрын

Yes.@@trumpexcel

@mathsindeep107 6 ай бұрын

I have M365 Family plan. for 6 users.@@trumpexcel

@gabrielmanjarrez60 2 ай бұрын

@@trumpexcel I have the M365 and I don't have that check box. How can I update it?

@hennasohail 6 ай бұрын

Hi Sumit, Is there a way you get in touch with you and get one on one training with you? Let me know an email or contact please. I have a serious interest in improving my excel skills based on my work requirements, hence would like one on one training. Thanks