How To Google Sheets Underline

by

Google Sheets, being a very powerful and versatile tool, provides a myriad of functionalities. One such simple yet essential feature is underlining text. Today, we will walk you through the steps on how to underline text in Google Sheets.

Why Underline Text?

Underlining text can be helpful in several ways. It can be used to highlight important information, denote titles, or even make specific text stand out. This feature is particularly handy when you’re dealing with spreadsheets that contain a huge amount of data.

Steps to Underline Text in Google Sheets

Here are the steps you need to follow to underline text in Google Sheets:

  1. Firstly, open your Google Sheets document.
  2. Select the cell or range of cells that contain the text you want to underline.
  3. Click on the “Format” option in the menu bar.
  4. Hover over the “Text” option which will open up another dropdown menu.
  5. Click on “Underline”.
  6. The selected text will now be underlined.

You can also use the shortcut CTRL + U (for Windows) or CMD + U (for Mac) to underline text.

It’s worth mentioning that you can also apply the underline style using Google Sheets API. Here is an example of how you can do that:

{
  "requests": [
    {
      "repeatCell": {
        "range": {
          "sheetId": sheetId,
          "startRowIndex": 0,
          "endRowIndex": 1
        },
        "cell": {
          "userEnteredFormat": {
            "underline": true
          }
        },
        "fields": "userEnteredFormat.underline"
      }
    }
  ]
}

The above code will underline the text in the first row of the specified sheet.

Conclusion

Underlining text in Google Sheets is a quite simple process, whether you do it manually or programmatically. By following these steps, you can easily highlight important information in your spreadsheet. Have fun underlining!