Office Compatibility Issues

Excel for the Web: Format Painter Double-Click Not Working

John WilsonJohn Wilson Nov 13, 2026 869 views

Question details

The user wants to keep Format Painter active by double-clicking it in Excel for the web, as they can in desktop Excel.

Excel for the Web: Format Painter Double-Click Not Working
Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
Copying cell formatting to multiple separate ranges in a workbook opened online, including a workbook stored on OneDrive.
Observed behavior
A single click on Format Painter works, but double-clicking does not keep it active. The same behavior occurs in Google Chrome, Microsoft Edge, and Firefox.
Before you start

Check whether the workbook is open in a browser or in the Excel desktop application. To use persistent Format Painter mode, you need access to an installed and licensed desktop version of Excel.

Solution 1Recommended

Open the workbook in desktop Excel to keep Format Painter active

Use desktop Excel when you need to apply the same formatting to multiple separate cells or ranges.

Excel for the web supports a single use of Format Painter, not the persistent mode activated by double-clicking in desktop Excel. Storing the workbook on OneDrive does not change this limitation.

1
Open the desktop application

In Excel for the web, open the editing-mode menu and choose Open in Desktop App. If that option is unavailable, open Excel on your computer and use File > Open to locate the workbook on OneDrive.

2
Select the source formatting

In desktop Excel, select the cell or range whose formatting you want to copy.

3
Activate persistent Format Painter

Go to Home > Clipboard and double-click Format Painter.

4
Apply formatting and exit

Click or drag across each destination range to apply the formatting. Press Esc when you finish, then save the workbook.

Open the workbook in desktop Excel to keep Format Painter active
A desktop feature, not a browser fix: Switching browsers does not enable persistent Format Painter mode in Excel for the web. Opening the workbook in desktop Excel provides the required feature.
Free Microsoft Office alternative

Use WPS Spreadsheet for desktop workbook formatting

WPS Office is a free, lightweight alternative for editing and formatting spreadsheets on the desktop. Its familiar ribbon interface and support for Excel files make migration straightforward, but it does not change Format Painter behavior in Excel for the web.

Copy cell formatting with Format Painter in WPS Spreadsheet.Open and save Microsoft Excel .xlsx and .xls files.Use a familiar spreadsheet interface with common formatting controls.Move everyday workbook editing to a lightweight, free desktop Office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Format Painter work once but not stay active when I double-click it?

Excel for the web supports single-use Format Painter only. Select your source cells, click Home > Format Painter, and apply the formatting once. For persistent mode, open the workbook in desktop Excel and double-click Home > Clipboard > Format Painter.

Will switching from Chrome to Edge or Firefox fix this?

No. This is a feature limitation in Excel for the web, not a browser-specific issue. The reported behavior is the same in Chrome, Edge, and Firefox.

Does saving the workbook on OneDrive enable double-click Format Painter?

No. OneDrive is the storage location; the application opening the workbook determines which features are available. Use Open in Desktop App to access desktop Excel's persistent Format Painter mode.

How do I turn off Format Painter after double-clicking it in desktop Excel?

Press Esc after formatting your destination ranges. You can also click Home > Clipboard > Format Painter again to deactivate it.

Can I ask Microsoft to add persistent Format Painter to Excel for the web?

Yes. In Excel for the web, look for Help > Feedback, or use Microsoft's feedback portal to submit a feature request. Explain that you want double-click Format Painter to remain active across multiple destination ranges.