Friday, November 29, 2013

How to paste unformatted contents by copy from formatted cells

How to paste unformatted contents by copy from formatted cells:


See the above picture, different types of formatting in B2 to C13 cells. If your need, you can copy the data and paste to another cells without any formatting. Following the below steps:

1. Select B2 to C13 cells
2. Copy those cells from Home tab, in the Clipboard group
3. Set the cursor to E2 blank cell for data pasting
4. On the Home tab, in the Clipboard group, click the down arrow in bottom side of Paste icon
5. Select Paste Values



Post a Comment