Скачать или смотреть How to Filter Cells with Bold Text In Excel

How to Filter Cells with Bold Text in Excel
Filtering cells with bold text in Excel is not a straightforward process as it seems. But it could help you quickly identify and analyze specific parts of your data. While Excel doesn't offer a direct filter option for text formatting like bold, you can easily achieve this by following a few simple steps. In this intermediate excel tutorial you’ll learn filtering cells with bold text.
Step-by-Step Guide:
1. Open Your Excel Worksheet:
Opening the Excel file that contains the data you want to filter.
2. Open the Find and Replace Dialog:
Press Ctrl + F on the keyboard and open the Find and Replace dialog box.
3. Access Advanced Find Options:
Go to the Options button and expand the search within the Find and Replace search box.
4. Set the Format to Bold:
Click on the Format button at the right of the dialog box to open the Find Format dialog box.
Navigate to the Font tab within the Find Format dialog box.
Under *Font style*, select *Bold*.
Click OK and close the Find Format dialog box. The Find and Replace dialog box will now show that it is set to search for bold text.
5. Find All Bold Cells:
Ensure the Find what field is empty to search based on formatting only.
Click *Find All*. Excel will list all cells containing bold text in the search results at the bottom of the dialog box.
6. Select All Bold Cells:
Without clicking anywhere else, press Ctrl + A to select all the cells listed in the search results. All the cells with bold text are now highlighted in your worksheet.
7. Change the Fill Color of Selected Cells:
With the bold cells still selected, go to the Home tab on the ribbon.
In the Font group, click on the Fill Color icon (paint bucket).
Apply a distinct fill color (e.g., yellow) to all selected cells. This visual distinction will help in the filtering process.
8. Add Filters to Your Data:
Press Ctrl + Shift + L to add filter to your data range. If you have a header row, the filter arrows will appear there; otherwise, it will be placed at the top row.
9. Filter by Color:
Click on the filter to open the filter dropdown in the column where you applied the fill color.
In the filter menu, hover over *Filter by Color*.
Select the fill color you applied to the bold cells (e.g., yellow). Excel will filter the data to show only the rows that contain the selected fill color.

Pro Tips:
Clear Filters: To clear the filter and view all data again, click the filter arrow and select *Clear Filter from [Column Name]*.
Remove Fill Color: If you wish to remove the fill color after filtering, select the cells and set the fill color to No Fill from the Fill Color menu.
While Excel may not directly support filtering by text formatting, the method of changing the fill color of bold cells and filtering by color is a powerful workaround. By following these steps, you can effortlessly filter and analyze cells with bold text, enhancing your data management and interpretation skills. This approach harnesses Excel's robust find and filter functionalities, enabling you to work more efficiently and precisely. Start using this method today and see the difference it makes in your data analysis!

#Filter #BoldText #ExcelTips

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:

Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Intermediate Excel Tutorial: https://tinyurl.com/59a837py
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial