But if your spreadsheet is very large and you want to clear the data from all of the cells, as well as any formatting that has been applied to those cells, then it becomes a little more difficult. Fortunately there are some tools in Microsoft Excel Online that make it easy for you to not only quickly select an entire spreadsheet, but also clear all of the data and formatting from those selected cells.  

How to Clear All Data and Formatting in Excel Online

The steps in this article were performed in the desktop version of Google Chrome, but will also work in other desktop browsers like Firefox and Edge. Note that completing the steps in this guide will delete all of the data and formatting in all of the cells in the current worksheet. This won’t affect any of the data in other worksheets in this workbook. Step 1: Navigate to Excel Online at https://office.live.com/start/Excel.aspx and sign into the Microsoft Account containing the spreadsheet that you wish to clear.   Step 2: Open the file from which you wish to delete all of the data and formatting.

    Step 3: Click the button above the row 1 heading and to the left of the Column A heading to select the entire sheet.

    Step 4: Click the Home tab at the top of the window.

    Step 5: Click the Clear button in the Editing section of the ribbon, then choose the Clear All option.

    Are you finding it difficult to locate a spreadsheet that you need? Find out how to rename an Excel Online document and make it a little easier to find the files that you need. He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices. Read his full bio here.

How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online - 47How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online - 83How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online - 51How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online - 84How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online - 97