HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Clear All Formatting From a Range of Cells

Excel 2007: Clear All Formatting From a Range of Cells

If you have a spreadsheet that contains the data you desire, but the formatting isn’t to your liking, Excel can clear the formatting from a cell, range of cells, columns, rows or the entire spreadsheet.


1. Open the Excel spreadsheet containing the formatted data.

2. Select the range of cells that are to have the formatting removed by using either click and drag to select adjacent cells or by using ctrl+click and drag to select rows or columns or individual cells.

3. Go to the Ribbon, under the Home tab, and go to the Editing section.

4. Click the downward pointing arrow next to the Clear button and select Clear Formats.

The selected cells will have the formatting removed.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

3 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android