In this tutorial, you will learn how to underline in Google Sheets.
When you’re working in Google Sheets, you may find you need to call attention to specific text, either to provide emphasis or to designate that text as a section header or label. Fortunately, Google Sheets has a lot of text styling options, similar to the text editors you may be familiar with. One such text styling option in Google Sheets is underlines, which are quick and easy to add to a cell or a portion of text within a cell.
Read on to learn how.
Underline all Text in a Cell
The quickest way to underline text is to apply the underline formatting to an entire cell
Here’s how:
Step 1
Select the cell or cells containing the text you want to underline
Step 2
Open the Format menu and choose the Underline option
Step 3
All text in the selected cell or cells will be underlined
Underline Specific Text
You may find you want to underline only certain portions of the text within a cell. Fortunately, Google Sheets makes this easy too
Here’s how:
Step 1
Double click on the cell you want to underline text in to enter edit mode
Step 2
Select the text you want to underline. For a single word, you can double click the word to select it. For other selections, click and drag to select the text
Step 3
Use the Underline keyboard shortcut to apply an underline to the selection. The shortcut is Ctrl + U on Windows and Cmd + U on Mac
Step 4
The underline will immediately appear. If you want to add underlines to more portions of the text, you can repeat Steps 2-3 as many times as you want while still editing the cell
Step 5
Hit enter when you’re done to save the changes
Summary
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to underline in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to design in Google Sheets:
- Add Borders
- Add A Line
- Add A Tab
- Change Default Font
- Highlight
- Change Cell Color
- Alternate Colors
- Color Code
- Make Cells Bigger
- Make A Button
- Get Rid Of Lines
- Autofit
- Remove Borders
- Bold Lines
- Strikethrough
- Make Paragraph
- Set Margins
- Make A Header
- Make Categories
- Make A Template
- Shift Cells Down
- How Many Sheets Can You Have?
- Create A Header
- Content Calendar
- Dashboards
- Schedule
- Reports
- Make All Cells The Same Size
- Outline Cells
- Remove Cell Lines
- Tables
- Calendars
- Budgets
- Timelines
- Timesheets
- X Out A Cell
- Group Cells
- Format Cells
- Add Serial Number