Another Way to Use the Quick Analysis Tool in Excel

=================================================================

In addition to its primary function of quickly analyzing data within a range of cells, Microsoft's popular spreadsheet software, Excel, offers several other features and tools through which users can enhance their overall experience. One such feature is the built-in keyboard shortcut for strikethrough text or values.

Why Use Strikethough in Excel?

------------------------------

Strikethrough allows you to cross out or create a line through cells or parts of cells within an Excel worksheet, making it particularly useful when:

1. Highlighting incorrect data

2. Indicating that certain information is no longer relevant

In this article, we will explore how to apply strikething using three common methods: keyboard shortcut, Font dialog box, and adding a command to the Quick Access Toolbar.

Method 1: Using Keyboard Shortcut for Strikethrough in Excel

------------------------------------------------------

To quickly apply strikethough without having to navigate through various menus or toolbars:

1. Select the cell(s) where you want to apply the formatting.

2. Press 'Ctrl + Shift ~' on Windows or 'Cmd + Shift \~' on Mac.

Alternatively, if your keyboard layout doesn't have these keys readily available, you can also use:

- Alt+Shift+B for strikethrough

Method 2: Applying Strikethough Using the Font Dialog Box

------------------------------------------------

If using a keyboard shortcut is not convenient:

1. Select the cell(s) where you want to apply the formatting.

2. Go to 'Home' > 'Font' in the ribbon (or press Ctrl+Shift+F on Windows or Cmd+Shift+F on Mac).

3. In the Font dialog box, click on the strikethrough button.

Method 3: Adding Strikethough Command to Quick Access Toolbar

-------------------------------------------------------------

If you frequently use this feature and want quick access without having to navigate through multiple menus:

1. Right-click anywhere within a blank area in the ribbon.

2. Click 'Customize Ribbon' (or press Ctrl+Shift+F or Cmd+Shift+, on Mac).

3. In the right-hand side of the Excel Options dialog box, click on 'Commands Not in the Ribbon.'

4. Scroll down to find 'Strikethrough,' and double-click it.

-------

In conclusion, applying strikethough is a simple yet effective way to quickly highlight or hide data within your Excel worksheets using either built-in keyboard shortcuts, Font dialog boxes, or even adding this feature directly to the Quick Access Toolbar for faster access. Whether you're working with large datasets and want to easily spot incorrect entries or simply need an aesthetic touch for presentations, strikethough is a versatile tool that every Excel user should know how to use.

To learn more about other advanced features in Excel 2016, including using the Quick Analysis Tool for enhanced data analysis capabilities, be sure to check out our comprehensive guide on 'using Excel 2016 like a pro'(https://www.example.com/excel-2016-tutorial).

Another way to use the quick analysis tool in excel