Copying & Pasting Cell Content Along with Formatting and Without Formatting

To Copy and Paste cell content along with formatting Excel has the Paste Special option. This option is used to paste the specific cell contents or features such as formats, formula or comments.

When we prepare any data sets / Reports a format play key role to represent the data.

Let’s take an example to understand that how we can copy and paste cell content along with formatting.

We have working hour’s calculator sheet. In which we are having formulas, formatting, and comments.
 
img1
 
To learn about that how we can copy and paste the formatting from a cell or range to another cell or range.

Follow below mentioned steps:-

  • Select the cell from where you want to copy and paste the formatting from one cell to another cell or range.
  • Press the key Ctrl+C on your keyboard.

 
img2
 

  • Select the range where you want to paste the only formatting.
  • Right click with the mouse, the popup will appear.
  • Click on Paste Special.

 
img3
 

  • Paste Special dialog box will appear.
  • Click on Formats and then click on ok

 
img4
 

  • Format will be paste at selected area.

 
img5
 
Another option we have Format Painter. We can use this option to copy the formatting of one cell and paste into other cell or range.

Follow below mention steps:-

  • Select the cell from where you want to copy and paste the Cell content.
  • In the Home tab click on Format painter in the Clipboard group.

 
img6
 

  • The cursor will become a paint brush.
  • Then drag the cursor to your desired cell which will be selected and when we release the mouse, the entire format will be pasted.

 
img7
 
img8
 

  • We can also use the keyboard shortcuts and press Alt+H+FP. The format painter option will be selected and then we can carry out formatting our cell accordingly.

Note: We can copy and paste the formatting from one cell to the range but we cannot copy and paste the cell content from one cell to range.

To copy and paste the cell content without formatting follow below mentioned steps:-

  • Select the cell from where you want to copy and paste the Cell content.
  • Press the key Ctrl+C on your keyboard.
  • Select the cell where you want to paste the content.
  • Right click with the mouse, the popup will appear.

Click on Paste Special.
 
img9
 

  • Paste Special dialog box will appear.
  • Click on Values and then click on ok.

 
img10
 
img11
 
This is all about that how we can copy and paste the cell content with formatting and without formatting in Microsoft Excel 2010 and 2013.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube