Why Is There an Underline in My Google Sheets Cell?
You’re finalizing a report, formatting a budget, or cleaning up a data import, and you notice it: a stubborn line sitting at the bottom of a cell in your Google Sheets spreadsheet. It wasn’t part of your design, and now it’s throwing off the clean, professional look you’re going for.
This underline isn’t a mistake; it’s almost always a deliberate formatting choice, either yours or the software’s. The challenge is that in Google Sheets, an “underline” can mean a few different things. It could be the standard text decoration applied to font, similar to what you’d use in a word processor. More commonly, especially when it stretches across the entire cell, it’s actually a cell border.
Understanding which type of underline you’re dealing with is the first and most crucial step to removing it. This guide will walk you through identifying the culprit and using the correct, simple tools within Google Sheets to eliminate it for good.
Identifying Your Underline: Text vs. Border
Before you start clicking, take a close look at the line. Its behavior will tell you everything.
Is the line attached to the text itself? If you type more characters, does the line extend only under the text? If you delete the text, does the line disappear? If yes, you’re dealing with text underlining.
Is the line fixed to the cell’s edges? Does it sit at the bottom of the cell, stretching from the left border to the right border, regardless of how much text is inside? If you clear the cell’s content, does the line remain? If yes, you’re dealing with a cell border.
This distinction is key because Google Sheets handles these two features in completely different menus. Using the wrong tool will leave you frustrated and the underline still visible.
Removing Text Underlining
Text underlining is a font format. It’s the same feature you use to emphasize a word or denote a hyperlink. Removing it is a one-click process.
First, select the cell or highlight the specific text within a cell that has the underline. You can click a single cell or drag your mouse to select a range of cells.
Look at the toolbar at the top of your Sheets window. Find the “Underline” button. Its icon is a capital ‘U’ with a line under it. If the text in your selected cell is currently underlined, this button will appear highlighted or “pressed in.”
Simply click this “Underline” button once. The highlight will disappear, and the underline will be removed from your selected text instantly. You can also use the keyboard shortcut Ctrl+U (or Cmd+U on a Mac) to toggle underlining on and off.
This method is perfect for removing emphasis from headings, cleaning up pasted text, or fixing cells where underlining was applied by accident.
Removing a Cell Border (The Common Culprit)
Most of the time, that persistent line is a bottom cell border. Borders are used to create grids, separate sections, or highlight totals. They are independent of the cell’s content.
To remove a border, you need the dedicated border tool. Start by selecting the cell or range of cells containing the unwanted line.
In the toolbar, click the “Borders” button. It looks like a square divided into a grid. Clicking it opens a dropdown menu with various border options.
The menu shows a diagram of a cell. The bottom edge of that diagram will be highlighted if your selected cell has a bottom border. To remove it, you need to select the border style that represents “no border.”
In the Borders menu, look for the option in the top-left corner. It is typically an icon showing a dotted square or a square with no lines at all, often labeled “Clear borders” or represented by a white square. Click this option.
Immediately, all borders—including the bottom underline—will be removed from your selected cells. If the line is still there, you may have selected the wrong cells. Ensure your selection covers every cell where the border appears.
Advanced Border Removal and Troubleshooting
Sometimes, the issue is a bit trickier. Perhaps the border was applied to an entire row or column, or different cells have different border styles. Here’s how to handle those situations.
Clearing Borders from Large Ranges or Entire Sheets
If your sheet has sporadic underlines or a messy grid, clearing borders from the entire sheet might be fastest. Click the gray rectangle in the top-left corner of the sheet, between the column ‘A’ header and row ‘1’ header. This selects every single cell.
Now, open the Borders menu from the toolbar and select the “Clear borders” option (the white/no-border icon). This will wipe every border from the entire worksheet, giving you a completely clean slate. You can then re-add only the borders you actually want.
For a large, contiguous block of cells, click and drag to select the entire range before using the “Clear borders” command.
What If the Underline Won’t Go Away?
You’ve clicked “Clear borders,” but the line remains. This rare but frustrating issue usually has one of two causes.
First, check for conditional formatting. Conditional formatting can apply borders based on rules. Go to the menu: Format > Conditional formatting. A sidebar will open. See if any rules apply to your cell range that might be setting a bottom border. If you find one, you can edit the rule to remove the border formatting or delete the rule entirely.
Second, the cell might be part of a merged cell. If you have several cells merged into one, the border could be on one of the original, underlying cells. Try unmerging the cells first. Select the merged cell, go to Format > Merge cells > Unmerge. Then, clear the borders from the now-individual cells before re-merging them if needed.
Preventing Unwanted Underlines in the Future
Now that your sheet is clean, let’s keep it that way. Unwanted formatting often comes from pasting data from other sources.
When you copy data from a website, another spreadsheet, or a document, you often copy the formatting along with it. To avoid this, use the “Paste special” feature in Google Sheets.
After copying your text, right-click on the cell where you want to paste. In the context menu, hover over “Paste special.” Then, select “Paste values only.” This will insert the raw text and numbers without any fonts, colors, or borders from the source.
You can also find these options under the Edit menu. Making “Paste values only” your default habit is the best way to keep your sheets free of imported formatting surprises.
Using Formatting Consistency
For projects where you do want borders, establish consistency. Instead of manually drawing lines, consider using the “Format as table” approach. While Google Sheets doesn’t have a direct “Format as Table” button like some software, you can create your own.
Set up your header row with a specific fill color. Apply a thick bottom border only to the header cells. For the data body, apply a light, consistent border grid. Save this styled range as a template or simply copy its formatting to new data sections using the Paint Format tool (the paint roller icon in the toolbar). This controlled approach prevents random, stray underlines.
Actionable Next Steps for a Clean Sheet
Start by identifying the underline type in your current sheet. Select the cell and look at the toolbar—is the “U” button highlighted? If so, click it. If not, use the Borders menu to clear it.
For a wholesale cleanup, select your entire data range and use “Clear borders” from the Borders menu. This removes all gridlines and separators, allowing you to deliberately re-add only the borders that improve readability.
Finally, adopt the “Paste values only” technique for all future data imports. This single habit will eliminate the vast majority of unwanted formatting issues, keeping your Google Sheets documents looking professional and intentional.
By understanding the tools—the simple Underline toggle for text and the powerful Borders menu for cell lines—you have full control over your spreadsheet’s appearance. No underline is too stubborn to remove.
