Clear formatting by clicking the Clear All Formatting button in the Font section on the Home tab or pressing Ctrl + Spacebar on your keyboard. How to clear formatting in boxes, headers, and footers.

Pick Format from the navigation menu and select "Clear formatting." Click the italicized "T" icon with a diagonal strike through it from the toolbar.

(That's the space bar, in case it's not abundantly clear.) Presto: No more funky formatting, just plain old text. I have to say, I find this even more useful than the hyperlink shortcut, ...

The first step in making a spreadsheet readable is to tidy up the cell formatting. By smartly using cell borders, shading, data validation, and other formatting techniques, you can improve the ...