


#How to underline in excel without text code
Right-click on the worksheet tab and select View Code (or use the keyboard shortcut ALT + F11).Here is another way of filtering cells with text in bold font format by using VBA. I could not find any help article on GET.CELL() by Microsoft. Note: Since this is a macro function, you need to save this file with a. In the column where you have TRUE/FALSE, select the filter drop-down and select TRUE.Īll the cells with text in bold font format have now been filtered.Now select the entire data set, go to the Data tab and click on the Filter icon.It will return a TRUE if the cell has bold formatting and FALSE if it does not. Copy this formula for all the cell in the column.Go to cell B2 (or any cell in the same row as that of the first cell of the dataset) and type =FilterBoldCell.In the New Name dialog box, use the following details:.
#How to underline in excel without text how to
Now let me show you how to filter cells with text in a bold font format using this formula: Reference is the cell reference that you want to analyze.Type_num is the argument to specify the information that you want to get for the referenced cell (for example, if you enter 20 as the type_num, it would return TRUE if the cell has a bold font format, and FALSE if not).Here is the syntax of the GET.CELL formula =GET.CELL(type_num, reference) If the cell is locked or not, and so on.GET.CELL function gives you the information about the cell. This is an old function which does not work in the worksheet as regular functions, but it still works in named ranges. It’s an Excel 4 macro function – GET.CELL(). This will automatically filter all those cells that have bold font formatting in it. In the drop-down, go to the ‘Filter by Color’ option and select the color you applied to cells with text in bold font format.For the column that you want to filter, click on the filter icon (the downward pointing arrow in the cell).Click on the Filter icon (Key Board Shortcut: Control + Shift + L).

Now to filter these cells, here are the steps: In the above steps, we have converted the bold text format into a format that is recognized as a filter criterion by Excel. This will color all the cells that have the text with bold font formatting.

In the Replace Format dialog box, select the Fill Tab and select any color and click OK (make sure it’s a color that is not there already in your worksheet cells).In the ‘Replace with:’ section, go to Format drop-down and click on ‘Choose Format From Cell’ option.Select any cell which has the text in bold font format.In the Find what section, go to the Format drop-down and select ‘Choose Format From Cell’.In the Find and Replace dialog box, click on the Options button.In the Editing group, click on the Find and Select drop down.Here are the steps filter cells with bold text format: The idea is to find the bold font formatting in the worksheet and convert it into something that can be easily filtered (Hint: Cell color can be used as a filter). Method 1 – Filter Bold Cells Using Find and Replaceįind and Replace can be used to find specific text in the worksheet, as well as a specific format (such as cell color, font color, bold font, font color). Method 1 – Filter Bold Cells Using Find and Replace.
