Looking for a better sales proposal solution? Learn More
Log in
Help & Support
QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Clearing Formats in the Spreadsheet Block - illustration 06a6cdda-2e0c-4345-a3de-6be30f5393ad
  • Logo
  • Why QuoteCloud?
    • Product Overview
    • AI Co-Worker
    • Proposal Software
    • Quoting Software
    • Enhanced Travel Itinerary Software
    • TravelDocs Mobile App
    • CPQ Software
    • Document Generation Software
    • Electronic Signatures
    • Collaboration
  • Solutions
    • Telecommunications and Hosted Services

      Automate telco service contracts with fast product bundling, automatic attachment of critical information summaries and more...

    • Sales Quotes for IT Services

      Take your IT business to a new level with interactive smart sales proposals

    • Travel

      Plan, sell, and manage travel bookings more efficiently, create beautiful enhanced itineraries direct from your GDS or Mid-office system

    • Trade Services

      Create estimates, quotes, work orders, and invoices for your customers

    • Web Developers

      Improve your process, streamline your business development. Create beautiful proposals, estimate work faster than ever before

    • Recruitment Services

      Pitch the big corporates to provide your recruitment services, accelerate your chance to seal the deal

    • Construction

      Speed up the sale quotation process and stay on top of project management with built-in integration to project management tools

    • Architects and Engineers

      Deliver engaging documents for better project planning and management

    • Marketing Services

      Streamline the quote process and keep projects flowing in

    • Real Estate Industry

      Create beautiful campaign documents, streamline your real estate transactions with forms and e-sign

    • Education Services

      Streamline the way you create, deliver and e-sign documents. Give yourself the tools to excel in your industry

    • Accounting

      Grow your accounting practice with ease

    • Events

      Create beautiful proposals that provide a greater customer experience. Seal the deal with contracts and forms for a perfect workflow

    • HVAC

      Align your sales, operations, marketing and legal departments with standardised documents

    • See all industries »
  • Templates
  • Integrations
    • MOST POPULAR
    • Accounting
      • Xero Accounting
      • QuickBooks Online
      • Freshbooks Accounting
    • CRM
      • Salesforce
      • Pipedrive
      • HubSpot
      • Zoho
      • Monday
      • Zendesk Sell
    • Travel
      • Tres CCTE (CrossCheck)
      • Sabre GDS
      • Tramada
    • Job Management
      • ServiceM8
      • SimPro
    • Customer Service Software
      • Zendesk
    • Payments
      • Stripe
      • PayPal
    • Google
      • Google Sheets
      • Google Calendar
    • Microsoft
      • Microsoft Excel
      • OneDrive
      • Microsoft Dynamics CRM
    • Collaboration
      • Slack
      • Microsoft Teams
    • All Integrations »
  • User Guide
  • Pricing
  • Start a free trial

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.

Frequently Asked Questions

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 entire sheets?

Yes. Use Clear Format on a large selection, a grouped range, or across multiple cells to reset styling in one action. This makes it easy to normalize appearance across big areas of a sheet or multiple spreadsheet blocks.

Does Clear Format affect conditional formatting, comments, or data validation?

Clear Format explicitly removes visual styling such as fonts, colors, borders and number formats and does not remove cell values or formulas.

For items not specifically listed (for example conditional formatting rules, cell comments/notes, or data validation), behavior can vary by spreadsheet implementation. If you rely on those features, test Clear Format on a copy of your document or consult QuoteCloud support to confirm how those items are handled.

How does clearing formats help when building quotes and proposals in QuoteCloud?

Using Clear Format helps keep spreadsheet blocks inside your quotes and proposals clean, consistent, and on-brand. Removing stray fonts, colors, or borders from pasted data ensures your documents match templates and look professional.

That makes it easier to produce polished documents with QuoteCloud — a sales quoting software and proposal software platform — whether you're using quote software features, interactive pricing tables, or embedding spreadsheets inside proposals.

For your industry

Sales Quotes for Telco
Sales Quotes for Trade Services
Sales Quotes for Travel
Sales Quotes for Marketing Services
Sales Quotes for Accounting
Sales Quotes for Construction Companies
Sales Quotes for Web Developers
Sales Quotes for Education Services
Sales Quotes for Events
Sales Quotes for Recruitment & Staffing
Sales Quotes for Architects & Engineers
Sales Quotes for Real Estate
Sales Quotes for IT Services
See all industries

Information

User Guide (Edge Edition)
Pricing
Change Log

Try It For Free
Login To Your Account

Templates

Accounting and Tax
Cleaning Services
Construction & Engineering
Events
Consulting
Construction & Engineering
IT & Technology
Recruitment
Trade Services
Travel Agencies
Solar Installers
Quote & Proposal Templates
Education
Service Proposals
See all templates

Getting Started

Try QuoteCloud for Free
Request a Demo
View Templates for a Quick Start
Already have an account? Sign-in Here

Idea Icon Getting Started video

QuoteCloud 2013-2022 Copyright all rights reserved

Capterra QuoteCloud score link Software Advice QuoteCloud score link
Privacy Policy - Terms of Use