MS Excel
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
From Edit menu choose Clear and then Formats
From Edit menu choose Delete

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To center worksheet titles across a range of cells, you must

Select the cells containing the title text plus the range over which the title text is to be centered
Format the cells with the comma style
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered

ANSWER DOWNLOAD EXAMIANS APP