MS Excel
The Paste Special command lets you copy and paste:

Formatting options
Cell comments
The resulting values of a formula instead of the actual formula
Multiply the selection by a copied value

ANSWER DOWNLOAD EXAMIANS APP

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

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
Click on Remove Formatting tool on Standard Toolbar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To view a cell comment

Click the display comment command on the window menu
Position the mouse pointer over the cell
Click the comment command on the view menu
Click the edit comment command on the insert menu

ANSWER DOWNLOAD EXAMIANS APP