Formatting Issues

How to Make Inserted Excel Cells Inherit Formatting from the Cell Above

Ayan Masood Oct 23, 2026 868 views

Question details

The user needs newly inserted spreadsheet cells to automatically inherit the visual formatting (such as font, color, and borders) of the cell immediately above them.

How to Make Inserted Excel Cells Use Formatting from the Cell Above

Product: Microsoft Excel
Device & OS: not provided
Scenario: Inserting a new blank cell into an existing data column that has specific formatting applied to certain rows.
Observed behavior: Excel lacks a universal, fully automatic setting for this behavior. When a cell is inserted, Excel sometimes unpredictably copies formatting from an adjacent horizontal cell or defaults to no formatting instead of perfectly matching the cell directly above.

Before you start

Check whether your current dataset is organized as a standard cell range or a formatted Excel Table, as official Tables handle automatic row formatting differently than normal ranges.

Solution 1Recommended

Use the Format Painter Tool

Manually copy the exact formatting from the cell above and apply it to the newly inserted cell.

Since Excel does not have an overarching setting to always pull formatting from the cell above automatically, the most reliable manual method is using the Format Painter. This tool copies all visual styles—including background colors, font styles, and number formats—without altering the cell's underlying data or formulas.

Select the source cell

Click on the cell directly above your newly inserted cell that contains the formatting you want to copy.

Activate Format Painter

Go to the 'Home' tab on the ribbon and click the 'Format Painter' icon (it looks like a small paintbrush).

Apply to the new cell

Click on your newly inserted blank cell. The formatting from the cell above will be instantly applied.

Double-Click for Multiple Cells: If you need to apply this formatting to multiple non-adjacent inserted cells, double-click the Format Painter icon to keep it active until you press the Esc key.

Solution 2

Convert the Range to an Excel Table

Use Excel's official Table feature to ensure consistent, automatic formatting across all new rows.

Solution 3

Use the Fill Down Shortcut (Ctrl+D)

Quickly copy both the content and formatting from the cell directly above.

Easily Maintain Spreadsheet Formatting with WPS Office

WPS Spreadsheet provides a highly intuitive interface to manage cell formatting with precision. Using built-in tools like the Format Painter, intuitive Table styling, and smart fill shortcuts, you can perfectly format inserted cells in seconds.

1. Open your spreadsheet in WPS Office: Launch WPS Spreadsheet and open the file where you need to adjust cell formatting.
2. Select the correctly formatted cell: Click on the cell directly above your newly inserted cell.
3. Click the Format Painter: Navigate to the Home tab and click the 'Format Painter' brush icon.
4. Paint the new cell: Click on your blank inserted cell to instantly transfer the exact visual styling from the cell above.

Seamlessly copy cell colors, borders, and text styles with a single click using the Format Painter.Fully compatible with Microsoft Excel formats (.xls, .xlsx, .xlsm), ensuring your formatting looks identical on any platform.Lightweight and completely free to use for everyday office tasks.Built-in smart tables automatically inherit formatting when expanding rows.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use a formula like `=A1` to copy formatting?

No. Formulas in Excel and other spreadsheet programs only return values or text strings. They cannot pull background colors, font bolding, borders, or other visual formatting. You must use the Format Painter or copy-paste special formats.

Why does Excel show an 'Insert Options' brush when I add a cell?

When you insert a new row or cell, a small floating paintbrush icon called 'Insert Options' temporarily appears next to it. You can click this icon and choose 'Format Same As Above', 'Format Same As Below', or 'Clear Formatting'.

How do I make my cell formatting apply to the whole column permanently?

Instead of formatting individual cells, you can click the column letter at the top of the sheet to select the entire column, then apply your formatting. Any new cells inserted into that column will automatically adopt the column's default formatting.

Document & File Issues