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.I encourage you to play around with the styling until you find a style that suits you. Note: Accompanying Excel has Unformatted and Formatted sheets so you can see the difference between the 2. What I could do here is create a few new styles from my table so that I can re-use the formatting on future tables. You can also add styles by clicking the New Cell Style button. Once youve found a style you like, just click it and your selection will be formatted to that style. You click the dropdown arrow to expand the styles selection. ![]() ![]() The end result is a much better looking table which is easier to read:Īn alternative way to adjust all these styling options at once is to use Styles (only Excel versions 2007 and later). I have also added a border to my table (by clicking the window like symbol in the middle. I have decided to make my column headers dark blue with white text and then the rest of the table alternates between white and light blue for each row. Note: For Excel versions prior to 2007 the cell color options are located on the Fill tab of the Format Cells window. You select your color from here then click the button to apply to your current selection. The down arrow beside each button brings up the color picker. The button with a bucket on it changes the cell color and the button with a capital A on it changes the text color. The last formatting changes I make to my table are adjusting the cell and text colors. The buttons for these are just beside the Bold button. (Ctrl + B is the keyboard shortcut)Īlternatively I could have made the column headings italic ( I button) and/or underlined ( U button). This is done by clicking the Bold button which is symbolized by a bold B. I am also going to make my text for the column headings bold. Note: The two buttons beside this dropdown also allow you to increase/decrease the size. I have decided to increase the size of my text to 14. This allows you to select the size of the font. For this example I am changing my column headings to have the Arial font type. The dropdown shows the various font names and how they look. The text dropdown on the left selects the text type. (For versions of Excel prior to 2007 the Font options are accessed from the Font tab of the Format Cells pop up window) I then go to the Font settings on the Home tab. To demonstrate the various formatting options I am going to edit this basic table of sales orders:įirst I am going to edit the column headings of my table. The Formatting tools are located on the Home tab/ribbon (for versions prior to 2007 formatting is accessed by right clicking and selecting Format Cells): In this tutorial I will cover how to use the various formatting tools in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |