Clearing Formats in the Spreadsheet Block
Learn how to reset cell formatting in the Spreadsheet Block. This guide shows you how to clear formatting from a single cell, multiple selected cells, and how to use the Clear Format icon in the spreadsheet toolbar to quickly remove styling and return cells to their default appearance.
Steps to clear cell formatting
Select the target cells
Click on a single cell or click and drag across a range of cells to highlight them. You can also hold the Shift key while selecting individual cells to choose multiple specific areas.Locate the Spreadsheet toolbar
The formatting tools are located in the toolbar directly above the spreadsheet grid.Click the Clear Format icon
Find and click the Clear Format icon. This will immediately strip away any bolding, colors, background highlights, or custom borders from the selected cells.Verify the reset
Your data will remain in the cells, but the appearance will return to the system default, allowing for a clean slate to re-format as needed.
FAQs
What does the Clear Format action do in the Spreadsheet Block?
The Clear Format action removes all visual styling from cells in the Spreadsheet Block and returns them to the spreadsheet's default appearance. It strips formatting such as fonts, colors, borders, number formats, and text styles while leaving cell contents and formulas unchanged.
How do I clear formatting from a single cell?
Select the single cell you want to reset, then click the Clear Format icon in the Spreadsheet Block toolbar. The selected cell's styling will be removed and it will revert to the spreadsheet's default look without affecting its value or any formulas.
How do I clear formatting from multiple selected cells at once?
Select the range, group, or multiple cells you want to reset, then click the Clear Format icon in the Spreadsheet Block toolbar. All selected cells will have their styling removed and revert to the default format in one action — a fast way to normalize appearance across a block of cells.
Will clearing formats remove my cell values or formulas?
No. Clearing formats only removes visual styling and formatting. Cell values, text entries, and formulas remain intact. Use Clear Format when you want to restore the default appearance without losing data or calculations.
Where is the Clear Format icon located?
The Clear Format icon is located in the Spreadsheet Block toolbar. Use that toolbar control while a cell or a range is active to quickly remove styling and return the selected cells to the spreadsheet's default appearance.
Can I use Clear Format to quickly reset styling across many cells or an entire sheet?
Yes. Select the range of cells you want to normalize — or select all cells on a sheet — and then click the Clear Format icon in the Spreadsheet Block toolbar. This provides a fast way to remove inconsistent styling across large areas without affecting your data or formulas.
How do I undo a Clear Format action if I change my mind?
Use the app's Undo command immediately after clearing formats to restore the previous styling. Most editors also support a keyboard undo (e.g., Ctrl+Z / Cmd+Z) or an Undo button in the toolbar to revert the action.
Why might I clear formats when preparing sales quotes or proposals in sales quoting software or sales proposal software?
Clearing formats helps maintain a consistent, professional appearance across your documents. When building quotes or proposals with quote software or proposal software, removing ad-hoc styles prevents visual inconsistencies, ensures templates render correctly, and simplifies branding — all without altering pricing, formulas, or content.