How to Create a Checklist in Microsoft Excel

---

• How to Create a Checklist in Microsoft Excel
• How to Quickly Turn Off App Notifications on Mac
• How to Deregister your Phone number from Google’s RCS Chat

How to Create a Checklist in Microsoft Excel Posted: 07 Dec 2020 07:59 AM PST If you're building a spreadsheet to share with others or simply one for your own tracking, using a checklist can make data entry a breeze in Microsoft Excel. Here's how to create a checklist in your spreadsheet and make it look like your own. Why a checklist? You might use a checklist for tracking items to pack for a trip, products for your company, a holiday gift list, monthly bills, or keeping track of tasks. With a simple check box form control, you can create a checklist for anything you like in Excel. Access the Developer Tab Before you can use the check box form control in Microsoft Excel, you need to make sure that you have access to the Developer tab. If you don't see this tab at the top of Excel, it takes only a minute to add it. Right-click anywhere on your Excel ribbon and select "Customize the Ribbon" from the drop-down list. Alternatively, you can click File > Options > Customize Ribbon from the menu. On the right side of the window, under "Customize the Ribbon," make sure "Main Tabs" is selected. Then in the list below it, check the box next to the "Developer" option. Click "OK" and then close the Excel Options window. RELATED: How to Add the Developer Tab to the Microsoft Office Ribbon Add Your List of Items in Excel The best way to begin your checklist is to add the list items. Even though you can always add or remove items later, this gives you the start you need to add your checkboxes. And you can, of course, add any row or column headers that you need. Add Check Boxes for Your List Items The action part of a checklist is the checkbox. And this is where the Developer tab comes into the mix, so be sure to select that tab. Go to an item on your list and click the cell next to it where you want a checkbox. In the ""Controls" section of the ribbon, click the "Insert" button. Pick the "Checkbox" option in the "Form Controls" area. You'll then see your cursor change to crosshairs (like a plus sign). Drag a corner, and when you see your checkbox display, release. By default, the checkbox will have a label attached to it which you will not need for a basic checklist. Select that text and hit your "Backspace" or "Delete" key. You can then select the checkbox control and drag a corner to resize it if needed. Format Your Checkboxes Once you insert a checkbox, you can make changes to its appearance if you like. Right-click the checkbox control. Make sure that you right-click the actual control and not the cell containing it. Select "Format Control" in the shortcut menu. You'll see tabs for "Colors and Lines" and "Size," which give you easy ways to color the lines, add a fill color, scale the checkbox, and lock the aspect ratio. Be sure to click "OK" after making your changes. Checkbox Values and Cell Links The other tab you may want to work with is the "Control" tab. This one lets you set the value, add a cell link if necessary, and apply 3D shading. Checkbox Values By default, a checkbox is unchecked when you insert it. Depending on the type of checklist you create, you might want the boxes checked by default instead. This forces the user to uncheck items they don't want. To do this, mark "Checked" under "Value" in the Control tab and click "OK." Cell Links If you plan to use your checklist in conjunction with Microsoft Excel formulas, you'll likely use "Cell Link" on the "Control" tab. When you enter a cell into this box, it will display a True or False value based on the box being checked or unchecked. Here's an example. Say your checklist has 25 items and you plan to use the COUNTIF function to see how many of the items are checked. You can base your formula off of the True and False values associated with the checked and unchecked boxes. To use the "Cell Link," simply type the cell reference into the box or click the cell in your spreadsheet to populate it automatically. Add the Remaining Checkboxes Follow the above steps to add checkboxes to your remaining list items. Or for a quicker way, use AutoFill to copy the checkboxes through the cells of your other items. To use AutoFill, put your cursor on the bottom-right corner of the cell containing the checkbox. When you see the Fill Handle (plus sign), drag to fill the additional cells and release. For marking off a list of to-dos, making a gift list and checking it twice, or tracking bills you pay each month, creating a checklist in Excel is a great way to go! And if you like the list idea, how about adding a drop-down list in Microsoft Exce,l too? See details

How to Quickly Turn Off App Notifications on Mac Posted: 07 Dec 2020 06:41 AM PST Khamosh Pathak It's very easy to get distracted when an app starts sending you annoying notifications. Right after you get an app notification, use the Notification Center on Mac to disable notifications for each app. Quickly Turn off App Notifications from the Notification Center You can disable an app's notification from the notification itself. This works when you see a notification banner or alert in the top-right corner of the screen. When you see a notification, right-click it and choose the "Turn Off" option. Your Mac will instantly stop notifications from the app. Alternatively, you can use the Notification Center to do this. Click the Date and Time from the menu bar to show the Notification Center. You can also swipe in from the right edge of the trackpad with two fingers. Here, you'll see notifications from installed apps. The notifications will be grouped based on apps. Right-click a notification and choose the "Turn Off" option to disable the notifications for the app. Enable App Notifications from System Preferences If you change your mind, you can enable notifications for an app from System Preferences. Click the Apple icon from the menu bar and choose the "System Preferences" option. Here, go to the "Notifications" section. From the sidebar, choose the app for which you want to enable notifications. Then, click the toggle next to "Allow Notifications" to enable notifications for the app. Finding the transparent menus in macOS distracting? Reduce Transparency feature will help you focus better. RELATED: How to Disable Transparent Menus on Mac See details

How to Deregister your Phone number from Google’s RCS Chat Posted: 06 Dec 2020 11:26 PM PST A few days ago, we shared an article on how to check if your phone supports Google's RCS Messaging. For those who don't know, RCS is a massive upgrade over SMS. It's a protocol between mobile operators and phones. Just like every other instant messaging apps, RCS relies on internet connectivity to exchange text messages. However, the only difference is that the RCS protocol is designed to replace the SMS and MMS. With RCS, you can send high-resolution photos & videos, GIFs, etc. Also, unlike SMS that allows you to send messages of up to 160 characters, RCS has no character limits. It also enables lots of instant messaging features like sending read receipts, show typing indications, etc. Well, RCS is indeed a massive upgrade over SMS, but it does have some drawbacks. For instance, when you switch from a device supporting RCS chat services to one that doesn't, you may experience issues like messages not being sent or delivered. How to Deregister your Phone number from Google's RCS Chat To avoid such issues, Google recommends users to disable the RCS chat messaging services on their supported phones before switching. However, if you have already switched to a new smartphone and experiencing messaging issues, then you need to follow some of the simple methods given below. Disable RCS Chat Features If you have the device with you in which you have enabled the RCS messaging, you can turn off the messaging features quickly. Follow some of the simple steps given below. Step 1. First of all, open Google Messages app on your Android. Step 2. Now tap on the three-dot menu icon and select 'Settings' Step 3. On the Settings page, select 'Chat features' Step 4. Now toggle the switch off for 'Enable Chat Features' Step 5. Now you will get a confirmation message. Simply tap on the 'Turn off' option. That's it! You are done. This is how you can disconnect your phone number from RCS on Android. Deregister your phone to disable RCS chat Well, if you don't have the old phone with you, you can still deregister your phone number from RCS messaging. Google has made an online form for Android users to deregister/disable RCS chat on their phone number. Step 1. First of all, open this link from your web browser. Step 2. Now you will see a screen like below. Step 3. Now enter your phone number and click on the 'Send Code' button. Step 4. Your phone number will receive a six-digit verification code. Just copy the code, and paste it into the second field. After that, click on the 'Verify' button. That's it! You are done. You will get a confirmation message 'Chat Features Have Been Turned Off'. So, this article is all about how to disconnect your phone number from RCS messaging on Android. I hope this article helped you! Please share it with your friends also. If you have any doubts related to this, let us know in the comment box below. See details

You are subscribed to email updates from My Blog. To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google, 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States