Fortunately Google Sheets provides you with the ability to simply clear all of the formatting from a selection at once instead. This “Clear formatting” option can be very helpful when you need it, so continue reading below to see how to use it in Google Sheets. You can use a similar option for documents, too. Our article on how to clear formatting in Google Docs will show you the steps in that application.

How to Remove All of the Formatting in a Cell in Google Sheets

The steps in this article were performed in the Web browser version of Google Sheets. Completing the actions in this guide will remove all of the formatting from the cells that you select. Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet containing the cells that you would like to clear of formatting. Step 2: Select the cells from which you would like to remove the formatting. Step 3: Click the Format tab at the top of the window. Step 4: Click the Clear formatting option at the bottom of the menu. Do you often work in Microsoft Excel and finding yourself in situations where you would like to clear formatting in that program as well? Find out how to clear formatting in Excel 2010 to get rid of formatting options that are difficult or time-consuming to remove individually.

See also

How to merge cells in Google SheetsHow to wrap text in Google SheetsHow to alphabetize in Google SheetsHow to subtract in Google SheetsHow to change row height in Google Sheets

After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.

You may opt out at any time. Read our Privacy Policy

How to Clear Formatting in Google Sheets - 2How to Clear Formatting in Google Sheets - 22How to Clear Formatting in Google Sheets - 51How to Clear Formatting in Google Sheets - 84