Excel for the Web: Format Painter Double-Click Not Working
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.

- 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.
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.
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.
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.
In desktop Excel, select the cell or range whose formatting you want to copy.
Go to Home > Clipboard and double-click Format Painter.
Click or drag across each destination range to apply the formatting. Press Esc when you finish, then save the workbook.

Reapply Format Painter for each destination in Excel for the web
Use this workaround when you need to stay in the browser and only have a few ranges to format.
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.

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.




