Skip to main content

How to Copy and Paste in Microsoft Excel like a Pro

As the use of computer devices around the globe has expanded exponentially, mastering Microsoft Office is a must if you want to grow in the field. Microsoft Excel is an integral part of the MS Office. The Paste tab and Special tools in Microsoft Excel allow you the control over how you want to copy and paste the content. Here is how you can learn to use these tools.

Copy Pasting content in Microsoft Excel can prove to be tricky. You may want to copy content from one cell to the other one, or you may want to select just a specific part of it. You may want to choose the complete cell, only the data, only the Formula, just the format or a combination of several items. Well, the good news is you can master the copy and paste option in Excel, just by mastering Paste options and Special Tools. By selecting the apt option, you will gain control over what you paste.

The article contains tips and tricks that can be applied to an older version of MS Excel too. So if you want to be caught up with the article, create a spreadsheet with some rows and columns. Add up the total of every column except the last column. Apply the special formatting to the bottom rows also.

Step One

Start with copying one of the total cells of any one column. Move the cursor toward the empty cell in the last column where the total must be appearing. Click right to open the popup tab. Move the cursor below the paste option tab in the menu. The first option is for Paste; this is the option you will select to paste everything.

Step Two

Delete the copied item and copy another one of total cells again. Again right-click on the empty cell and move the second item from the Paste Special Tools section. This option is for value, and it pastes the exact amount of number or texts from the cell you copied.

Step Three

Delete the copied item and copy one of the total cells again. Right-click on an empty cell and move the third item from Paste Special Cell. This item is for Formula and pastes a formula with relative cells without including the parent cell format.

Step Four

Delete the copied item and copy another cell. Right-click on an empty cell and move the fifth item from Paste Special Cell. It is to format copies and just the format of the source cell.

Step Five

Delete the copied item and copy another cell. Right-click on an empty cell and move the sixth and final item from Paste Special Cell. It is for Paste linking copies of the parent cell and to maintain a link to it.

John Hunt is a self-professed security expert; he has been making the people aware of the security threats. His passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. He writes for Norton security products at



Popular posts from this blog

What Is Digital Marketing?

 What Is Digital Marketing? Digital marketing is that the use of the social media, Internet, search engines, mobile devices, and other channels to succeed in consumers. Some consider digital marketing to be entirely new which needs a replacement way of understanding that how customers behave and new ways of approaching the purchasers compared to the normal marketing. Digital Marketing Channels 1. Website Marketing 2. Pay-Per-Click (PPC) Advertising 3.Content Marketing 4.Email Marketing 5.Social Media Marketing 6.Affiliate Marketing 7.Video Marketing 8.SMS Messaging Digital Marketing As A course and Career The Digital Marketing course will transform you into a complete digital marketer with expertise in the top eight digital marketing domains — search engine optimization, social media, pay-per-click, conversion optimization, digital analytics, content, mobile, and email marketing. Fast-track your career in digital marketing today with practical training you can appl
   5 Tips for Guiding Your Child Through an Escape Room   The most distinguishable characteristics of children are how immensely full of energy and curiosity they are! Compared to adults, they are far more willing to start thinking out of the box and be creative. These factors seemingly make them one of the best players to enjoy an escape room experience.    Taking your child to one of the escape rooms in Prescott this weekend can be a memorable experience for them. Visiting the escapades also undeniably offers you one of the best ways to spend quality time with your family. Furthermore, it also allows your child to test their creativity and problem-solving skills and even enhance their motor skills.    Now, while you take your kid to an escape room game anytime soon, here are 5 essential tips that you need to keep in your mind: 1.    Do your homework! It is always better to prepare yourself before entering the escape room game. So, instead of randomly choosing and

Why Science Labs are Important for Students in School?

Science is a subject which allows students to explore and discover new theories. From a small atom to large universe everything is conceptualize with help of science education. But only theoretical knowledge is not sufficient. Practical knowledge is important to increase engagement and knowledge. Science lab is a place for student which functions to magnify deep understanding of theoretical concepts taught in classrooms. By this effective teaching method, students can gain numerous benefits. Ideal Education Point (New Choudhary public school) believes that ‘Child learn in class but understand in laboratories. Laboratories provide a great experience and high degree of knowledge in developing necessary skills for study and research. Science is a little difficult subject than any other therefore it is must for any school to have a science lab. Know the importance of science labs - • Understand difficult aspects One cannot just read the hefty science books and understand all the meaning