How To Strikethrough in Google Sheets
Learn how to use strikethrough formatting in Google Sheets, including how to automate it with checkboxes and conditional formatting for better task management.
Here's how to strike through in Google Sheets. Want to click status and strike through some things, so we can go up to this menu and click strike through. We can even do command Y to do that again and again and again. But what if we wanted to do that automatically? There's a way to do that. Let's uns strike through all of these and go format . Conditional formatting . We're going to select B. B the entire range there. We're gonna change the format cells to custom formula is equals A one, and then we put a dollar sign in front of the A and equal to true. Now we can do none in the fill color, and we can select strip through here in the formatting style. Ultimate Checklist in Google Sheets The Simplest Bestest Checklist in Google Sheets Sheet Styles Conditional Formatting With Checkboxes in Google Sheets
And now every time we click a checkbox , we strike through the task name. Isn't that cool? If you're looking to get more out of your Google sheets, maybe add some cool automations like this. Subscribe today here on YouTube to better sheets. Uncheck Every Checkbox in Google Sheets Automate Google Sheets without Apps Script, without Zapier Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet SheetOps