Take You To Know 6 Excel Paste Tips

Date:2022-1-2 Author:Sandra

We usually copy and paste something into Excel. But just Ctrl +C and Ctrl + V. In fact, there are many other paste categories as well. So in our today’s tutorial, the author would like to share all of them with you.

No.1 Adds The Same Number To A Region

If we need to add 100 to each of the cells in column A, instead of creating a helper column or using a formula, just copy the data and select add in select Paste. 

We need to copy 100 first and select the area, then go to Paste tab to choose Paste Special.

Check Add and hit OK.

Excel Paste Tips
Take You To Know 6 Excel Paste Tips

No.2 Keep Source Column Widths

Press Ctrl and C to copy the are first, then select any cell to decide where to paste. Then go to the Paste tab and choose Keep Source Column Widths.

Take You To Know 6 Excel Paste Tips
Take You To Know 6 Excel Paste Tips

No.3 Transpose

Take You To Know 6 Excel Paste Tips
Take You To Know 6 Excel Paste Tips

No.4  Copies The Same Content To Multiple Cells

Sometimes we need to copy the same content into more than one cell, and this can be done by selecting the target cells for replication.

Take You To Know 6 Excel Paste Tips
Take You To Know 6 Excel Paste Tips

No.5 Linked Picture

Sometimes cell contents are updated, but cannot be viewed in real-time.  In this case, you can paste it as a linked image, and when the cell content is updated, it will be synchronized in this image for easy viewing. 

Take You To Know 6 Excel Paste Tips
Take You To Know 6 Excel Paste Tips

No.6 Apply The Format In The New Area

The format of the cells in the original area is different from the format of the cells in the new area pasted into.  If you need to apply the format in the new area, you can choose to paste as a value instead of pasting the format of the meta-area together.

Take You To Know 6 Excel Paste Tips
Take You To Know 6 Excel Paste Tips

That’s all for today’s tips about paste.  If you want to learn more about Excel, just save our website into your bookmarks, let’s learn and progress together. 

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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