How to Strikethrough in Microsoft Excel

The strikethrough option in Microsoft Excel is a great way to mark tasks as completed or show edits you’ve made. We’ll show you how to strikethrough in Microsoft Excel — it’s easy to do and can make a real difference to your productivity. We’ve got plenty of other great tips and tricks to help you get the most out of Excel, too.

How to Create a Strikethrough in Excel

If you’re wondering how to strikethrough text in Excel, it’s pretty easy to do.

  1. Launch the Excel desktop application on your PC.
  2. Open the worksheet you want to edit.
  3. Select the cells containing data you want to strikethrough.
  4. Click Format Cells (or the keyboard shortcut Ctrl + 5).
  5. Under Effects, click Strikethrough.
  6. You should now see a line through the text in your selected cells.
  7. Save your worksheet to ensure the changes are applied.

How to Strikethrough in Excel Online

If you’re using the online version of Excel, you might be wondering how to strikethrough in Microsoft Excel. Unfortunately, this feature isn’t available for Excel Online. If you want to use the strikethrough feature for edits or to tick off completed tasks, you’ll need to purchase the desktop version of Excel.

How to Get a Free Trial of Microsoft Excel

You can always sign up for a one-month free trial of Microsoft 365 and enjoy access to Excel, Word, PowerPoint, Outlook, and other Microsoft apps for one month, completely free. After that, you can purchase a subscription to Microsoft 365 or buy Microsoft Office as a desktop application, if you’re enjoying using the fully featured version of the program.

Now you know how to strikethrough text in Microsoft Excel. It’s a feature that’s sure to come in handy, especially if you often work with task lists and want to keep on top of how things are progressing. Before you go, why not check out how to share an Excel file for easy collaboration, or what to do if you can’t type in Microsoft Excel?



Source : How to Strikethrough in Microsoft Excel

Comments

Post a Comment

Popular posts from this blog

How to Add or Remove a Secondary Axis in Microsoft Excel Charts

Image
When you have a chart with mixed data types or a dataset that varies broadly between series, consider using a secondary axis in Microsoft Excel. With it, you can display the data you need without overwhelming or confusing your viewers. When to Use a Secondary Axis As mentioned, if you have different data types or your series amounts widely vary, these are good times to use a secondary axis. For instance, you can see that the column chart below doesn’t accurately depict the visitors and sales in our dataset. There’s a large variance in the sales amounts, making it hard to get a decent picture of the number of visitors per month. Plus, the sales are in dollar amounts, whereas the visitors are basic number values . If your chart would benefit from a secondary axis like this one, here’s how to add one as well as remove a secondary axis later if you change your mind or your data. How to Add a Secondary Axis in Excel To add a secondary axis to your Excel chart, you’ll use the combo ...
Read more

How to Use and Customise the Status Bar in Microsoft Excel

Image
Excel’s status bar is one of the hidden gems (and an unsung hero) that makes it the default spreadsheet software you turn to. It quietly resides at the bottom of the Excel window, often overlooked but brimming with valuable information and customization options. In this article, we will look at it and show you how to take advantage of it. Excel Status Bar Default Options Even before you customize the Excel status bar, it’ll display some helpful information and give you access to some useful functionalities. The common Excel options you can find as default on the status bar are: Cell Mode Macro Recording Tool Accessibility Check Page Number Statistics/Mathematical Options Worksheet Views Zoom Options Let’s see what each of them does and how you can use them. Cell Mode At the leftmost side of the Excel status bar, you’ll find the cell mode indicator. It’ll inform you about the status of the currently selected cell. There are four different status modes: Ready . It ...
Read more

What Is Windows AI-Powered Copilot?

Image
Microsoft has released its brand-new artificial intelligence (AI) companion, Microsoft Copilot. Previously known as Bing Chat, Copilot has a series of new abilities that can help you get more done in less time. In this article, we’ll provide a brief description of each of Microsoft’s new AI copilots, then we’ll focus on the Windows 11 copilot and what it can do to boost your productivity. What Is Microsoft Copilot? Microsoft Copilot is an artificial intelligence chatbot you can ask to perform different tasks, including generating text and images and answering general questions. Microsoft’s plan is to have a Copilot in each of its apps to provide assistance and improve user experience across the Microsoft ecosystem. Here are the different Copilots that are currently available or slated for future release: Windows 11 Copilot: Available for free as a preview in North America, Asia, and South America, Windows 11 Copilot lets you perform tasks, get answers, and create AI-generate...
Read more