Tuesday Tip: Excel Paste Special

by Tony Rushin

[spacer height=”5px”]

Have you ever done a copy/paste and ended up with unwanted formulas or formatting? Paste Special is a way to get around that. If you’ve never used Paste Special, here’s a short video (less than 2 minutes long) that can quickly orient you.

Paste Special is found at the bottom of the drop down window that opens when you click on the Paste tab

 

 

 

 

 

 

 

 

 

 

 

[spacer height=”2px”]

Here are the options you have when you open it:

 

 

 

 

 

 

 

 

 

[spacer height=”5px”]

For those of you who use shortcut keys, you can open Paste Special with Ctrl+Alt+V or Alt+E+S.

Many times, when I export information out of a cloud-based application, the numbers come over as text fields: Paste Special can fix this in a jiffy. In other cases, I want to copy the formula – or the value – but don’t want to mess with the formatting: Paste Special saves me from having to reformat after I paste. Those are my two biggest reasons for using Paste Special. For more advanced uses of Paste Special, here’s a great video I found that shows several Paste Special tricks… and the guy has a cool British accent.

 

Tony Rushin: In his role as VP of sales & marketing, he is responsible for hiring, managing and coaching the sales team and always staying on top of (and meeting) the needs of clients. Under his leadership, the company has steadily grown each year.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts