How to Format Cells in Google Sheets | Scribe

    How to Format Cells in Google Sheets

    • Alai Umerez |
    • 20 steps |
    • 37 seconds

      How to Format Cells Using Tools from the Toolbar Menu

      1
      Click on a single cell or drag your cursor over multiple cells to select them
      2
      In the toolbar at the top, you’ll find various formatting tools. Key options include: **Font Style**: Change the font type from the dropdown menu
      3
      **Font Size**: Adjust the size of the text
      4
      **Bold, Italics, Underline**: Use these buttons to emphasize text
      5
      **Text Color**: Change the font color by clicking the “Text color” (A) icon
      6
      **Fill Color**: Change the background color of the selected cell(s) using the paint bucket icon
      7
      **Alignment**: Align text to the left, center, or right using the alignment tools

      How to Format Cells Using the “Format” Setting

      8
      Highlight the cell(s) you want to format
      9
      Click on “Format” in the top menu bar
      10
      **Choose a Formatting Option:** - **Number Formatting**: Select options like Number, Currency, Date, or Custom Number Format to format numerical and date values - **Text Formatting**: Apply Bold, Italics, Strikethrough, or Underline styles - **Text Wrapping**: Control how text is displayed in the cell by selecting Wrap, Clip, or Overflow - **Borders and Shading**: Add borders or change the background color of the cell - **Clear Formatting**: Reset the cell to its default format by selecting this option

      How to Format Cells Using Conditional Formatting

      11
      Highlight the range of cells where you want to apply conditional formatting
      12
      Go to the “Format” menu located at the top bar
      13
      From the drop-down menu, click on “Conditional formatting”
      14
      In the conditional formatting panel on the right, set the rules that will trigger the formatting: **Apply to Range:** Verify the range of cells to which the rule will apply
      15
      **Format Rules:** Choose a condition (e.g., “Text contains,” “Greater than,” or “Is empty”) and input the criteria
      16
      For this example we'll chose "Text contains"
      17
      And in the value box we'll type the criteria. In this case, we typed "Wilson" as we want to highlight any cells containing this word