Excel Row Formatting: How to Format and Manage Rows

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, select a row by clicking its number at the left of the sheet, then use the Home tab to change its font, fill, borders, alignment, or number format. To change its height, choose Home > Cells > Format > Row Height or AutoFit Row Height. The key distinction is that selecting a row applies cell formatting across that entire worksheet row, while selecting only the cells in your data limits the change to that area.

What row formatting means in Excel

An Excel row is a horizontal set of cells identified by a row number. Formatting changes how its cells look or display values; it does not, by itself, change the underlying data. You can make a row bold, add a background color, draw borders, set text alignment, or apply a number format. Row height is also adjustable, though it is a property of the row rather than an individual cell.

For example, you might use bold text and a dark fill for a table’s heading row, apply a currency format to the sales cells in a row, or increase a row’s height so wrapped notes are readable. These operations are related, but they are not interchangeable: applying a currency format does not change the value, and changing the height does not make text wrap automatically.

Excel worksheets have 1,048,576 rows. A row’s number remains at the left as you scroll, unless the sheet is positioned so that the row header is out of view. Clicking that number selects the whole row, including cells well beyond the columns currently containing data.

Select a row or just the cells you need

Click a row number to select the full row. To select several adjacent rows, drag over their row numbers or click the first number and Shift-click the last. To select nonadjacent rows, hold Ctrl while clicking their numbers on Windows. On a Mac, use Command-click for nonadjacent selections. The same Home-tab formatting controls work after either selection.

If you only want to format part of a row, select the relevant cells instead. For example, select A1:F1 to style a six-column heading without formatting the rest of worksheet row 1. This is usually the more controlled choice for a data list: it avoids applying a fill or border to thousands of empty cells outside the table.

Useful Windows selection options include:

  • Click a row number to select one entire row.
  • Hold Shift and click another row number to select the continuous range between them.
  • Hold Ctrl and click additional row numbers to add separate rows to the selection.
  • Press Shift+Space while a cell in the target row is active to select that row.

In Excel for Mac, Shift+Space also selects the current row. Keyboard shortcuts can be affected by macOS settings or keyboard layouts, so clicking the row header is a reliable alternative.

Apply color, fonts, borders, and alignment

After selecting a row or range, use the controls on Home. The Font group contains bold, italic, font color, and Fill Color; the Alignment group controls horizontal and vertical alignment, text orientation, and wrapping; and the Number group offers formats such as General, Date, and Currency. The Borders menu in the Font group lets you choose which edges receive a line. A selection can contain several rows, so the chosen style is applied to all selected cells.

For a straightforward heading style, select the heading cells, choose Bold, set a fill color, and select a contrasting font color. Add a bottom border if you want a clear boundary between the headings and the records. A subtle fill and readable text are often more useful than applying a different bright color to every row.

Formatting affects the selected cells, not the row label itself. The number at the left is a worksheet heading and does not take on the cell fill or font color. If you want to change the appearance of the grid around data, use borders or the worksheet’s display settings rather than expecting a cell fill to recolor the row heading.

Number formats deserve particular care. If a row contains dates, select only the date cells and use a date format; applying a date format to an entire row may give unrelated values an inappropriate display. Excel stores numbers and dates as values, and formatting changes their presentation. It does not convert text that merely looks like a date into a real date value.

Change row height and make text visible

To enter a specific height, select the row or rows, then choose Home > Cells > Format > Row Height, type a value, and confirm. The measurement is in points. You can also place the pointer on the boundary below a row number and drag it to adjust the height by eye. Double-clicking that boundary applies AutoFit for the row, sizing it to the content Excel can display.

For text that should continue on a second line within the same cell, select the cells and choose Home > Alignment > Wrap Text. Then use Home > Cells > Format > AutoFit Row Height if the row does not expand enough. AutoFit can be less predictable with merged cells; a manually set height may be needed in that situation. If a row is too short, wrapped text may be cut off visually even though the cell’s contents remain there.

You can change several row heights together by selecting the corresponding row numbers before using Row Height or dragging a boundary. This is useful for making a report consistent. Be aware that forcing all rows to one tall height can waste space, while making them too short can hide wrapped content. A sensible height depends on the font, the amount of text, and whether wrapping is enabled.

Format a whole row automatically with conditional formatting

Ordinary formatting stays as you set it until you change it. Conditional formatting instead applies a style when a rule is true, which is useful for highlighting records based on a status, date, or threshold. To set it up, select the data range, choose Home > Conditional Formatting > New Rule, and select Use a formula to determine which cells to format. Enter a formula, choose the format, and confirm.

Assume the table has headers in row 1, records in rows 2 through 100, and a status in column D; select A2:F100. To highlight every row whose status is Overdue, use this formula:

=$D2="Overdue"

The dollar sign fixes the status column at D, while the row number is allowed to adjust as Excel evaluates each row in the selected range. If D7 contains Overdue, the rule evaluates as true for row 7 and applies the chosen formatting to A7:F7. If you instead select A2:F100 but refer to $D$2, every row would check only D2, which is usually not the intended row-by-row behavior.

Conditional formatting rules can overlap, so review the rules for a range if a color does not appear as expected. Choose Home > Conditional Formatting > Manage Rules to inspect or edit them. A rule may be present but not apply to the range you expect, or another rule may affect the same cells.

Use table styles for structured data

If your rows form a dataset with a header row, consider converting the range to an Excel table rather than manually formatting each record. Select a cell in the range and choose Insert > Table, check that the range is correct, and confirm whether the table has headers. You can then choose a style from the Table Design tab. Table styles can add banded rows, emphasize headers, and make a growing dataset easier to read.

Tables are useful because they organize a contiguous range as a data object and typically extend their formatting when you add rows directly beneath them. They also offer filter buttons in the header by default. A table style is not the same as a manual fill: changing a table’s style changes the coordinated appearance of the table, while manually coloring one cell or row can create a one-off override.

Tables are not necessary for every sheet. A title page, a small one-off layout, or a report with custom merged headings may be better handled with ordinary cell formatting. For records that need to grow, sort, or filter, a table often gives more consistent results than alternating manually formatted rows.

Copy, remove, and troubleshoot formatting

To reuse a style, select the formatted cells, choose Home > Clipboard > Format Painter, and then select the destination. Double-click Format Painter if you need to apply the same formatting to multiple areas; press Esc when finished. This copies formatting rather than the cell’s value. If you copy and paste cells normally, Excel may also paste formulas or values, so choose the paste option that matches what you intend.

To remove formatting without deleting cell contents, select the affected cells and choose Home > Editing > Clear > Clear Formats. This removes formatting such as font, fill, borders, and number formats, but it does not erase the underlying entries. Use Clear All only when you intend to remove both contents and formatting. If the appearance comes from a table style or conditional formatting, inspect that feature too; clearing ordinary cell formatting may not remove the rule or the table’s coordinated style.

Common problems often have simple causes:

  • Only part of a row changes: You may have selected cells rather than clicking the row number. Select the row header or expand the selection before formatting.
  • Text is hidden: Turn on Wrap Text and AutoFit the row, or increase its height manually.
  • A color returns after you change it: Check for conditional formatting rules or a table style that is controlling the display.
  • Numbers appear as dates or have unexpected decimals: Review the cells’ number format; the stored value may be intact even if its display is misleading.
  • The worksheet becomes awkward to navigate: Avoid styling full rows when the data occupies only a few columns. Formatting entire rows can extend Excel’s recorded used area, which may affect navigation or workbook size.

Choose a formatting approach that stays readable

Use direct formatting for a one-time visual adjustment, a table style for structured records, and conditional formatting when appearance should respond to data. These approaches can coexist, but keeping a clear purpose for each one makes later edits easier. For example, a table style might provide banded rows, while a conditional rule highlights overdue records in a contrasting color.

Before applying a style, consider what the reader needs to notice. Use consistent formatting for the same kind of information, preserve contrast between text and background, and avoid relying on color alone to communicate an important status. If a workbook will be printed, check the print preview as well: a fill that looks subtle on screen may print heavily, and rows that fit on a monitor may split across printed pages.

For a large worksheet, apply formatting to the actual data range instead of selecting every row. This keeps the workbook easier to manage and reduces the chance that formatting creates an unnecessarily large used area. If you do need to format whole rows, selecting their row numbers is the clearest way to ensure the operation applies across each one.

Frequently Asked Questions

How do I format an entire row in Excel?
Click the row number on the left to select the whole row, then choose the formatting controls you need on Home. For multiple rows, select several row numbers before applying the style.

How do I make all rows the same height?
Select the relevant row numbers, choose Home > Cells > Format > Row Height, and enter a height. This sets the selected rows to the same value; AutoFit instead sizes them according to their contents.

Can Excel highlight a row based on one cell?
Yes. Select the range to highlight, create a formula-based rule through Home > Conditional Formatting > New Rule, and use a relative row reference with the relevant column fixed, such as =$D2="Overdue" when the status is in column D.

Why does changing a row’s color not affect every cell?
Check whether the entire row was selected. Clicking a cell selects only that cell; clicking the row number selects the full row. If the selection is correct, a conditional formatting rule or table style may be overriding the display.

Does formatting a row change its data?
Usually, no. Font, fill, borders, alignment, and row height affect appearance. Number formats also change how values display, but they do not normally change the stored value. Editing, clearing, or replacing cell contents is a separate action.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.