Google Sheets is a powerful tool for organizing data, creating reports, and collaborating in real-time. While most users are familiar with its basic functionalities, there are many hidden features that can enhance productivity. One such feature is the ability to strikethrough text. This can be particularly useful for tracking tasks, highlighting completed items, or indicating changes. In this tutorial, we'll show you how to strikethrough on Google Sheets in several easy ways.

Method 1: Using the Format Menu

The most straightforward method to apply strikethrough in Google Sheets is through the Format menu. Here's how:

1. Select the Cell or Text: Highlight the cell or the specific text within a cell that you want to strikethrough.
   
   

2. Navigate to the Format Menu: Click on the "Format" menu at the top of the screen.
   
   

3. Choose Strikethrough: From the dropdown menu, select "Strikethrough."
   
   

The text will be strikethroughed.

This method is simple and quick, making it a favorite for many users. However, it can be time-consuming if you need to apply strikethrough to multiple cells.

Method 2: Keyboard Shortcut

For those who prefer a faster approach, using a keyboard shortcut is ideal. To strikethrough text using a shortcut, follow these steps:

1. Select the text or cells you want to strikethrough.
   
   

2. Use the Shortcut: Press Alt + Shift + 5 on your keyboard.
   
   

This method is highly efficient, especially when working with large datasets or multiple instances requiring strikethrough formatting.

Integrating Superjoin for Real-Time Data

And don’t forget, you can import real-time business data from your company systems into Google Sheets with Superjoin. It connects your favorite SaaS tools to Google Sheets automatically, helping you build reports that update in real-time without the hassle of manual data exports.

How to Remove Strikethrough in Google Sheets

Removing strikethrough in Google Sheets is just as simple as applying it. Here’s how:

1. Select the Strikethrough Text: Highlight the text or cells with strikethrough formatting.
   
   

2. Use the Shortcut Again: Press Alt + Shift + 5 or go to the "Format" menu and uncheck "Strikethrough."
   
   
   

This will remove the strikethrough formatting and return the text to its normal state.

Benefits of Using Strikethrough

Using strikethrough in Google Sheets can offer several benefits:

• Task Management: Easily track completed tasks or items that need attention.
  
  

• Data Review: Highlight changes or indicate outdated information.
  
  

• Visual Clarity: Improve the readability of your data by visually distinguishing different statuses.

Conclusion

Knowing how to strikethrough on Google Sheets is a valuable skill that can enhance your data management and presentation. Whether you use the Format menu, a keyboard shortcut, or conditional formatting, strikethrough is a versatile tool. Explore these methods and integrate them into your workflow to stay organized and efficient.

Remember, mastering Google Sheets' features can significantly improve your productivity and data handling capabilities. 

Happy strikethrough-ing!

Say Goodbye to Tedious Data Exports! 🚀

Are you tired of spending hours manually exporting CSVs from different tools and importing them into Google Sheets?

Superjoin is a data connector for Google Sheets that connects your favorite SaaS tools to Google Sheets automatically. You can get data from these platforms into Google Sheets automatically to build reports that update automatically.

Bid farewell to tedious exports and repetitive tasks. With Superjoin, you can add one additional day to your week. Try Superjoin out for free or schedule a demo.