Paste Special - What does it do?

August 04, 2017

0 comments

Copy and Paste   Copy and Paste shortcut   excel   excel for mac   excelskin   paste   paste special   special paste  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

The Paste Special shortcut can be used for a plethora of reasons.  I find myself using it most often when copying and pasting between two windows that do not share the same formatting.  

I can copy data in one format, and then paste into another document by using the Paste Special – Values Only option, which will only bring the values over and automatically match the format of my second sheet.  

Step 1: Copy data.  To do this execute the Copy shortcut, Command + C (⌘C).  

Step 2: Now that we have our cell copied, scroll to where you want to Paste this data and execute the Paste Special shortcut.

⌃⌘V

Step 3: A pop up will appear asking you what sort of Special Paste you wish to execute:

I am most familiar with the Values option as this only brings over raw values and nothing else, but as you can see there are many other options provided.  For this example I will stick with my favorite, Paste Special – Values:

Hit Enter or click OK and your data will Paste!

Since I chose Values only the data Copy Me was pasted.  The font formatting was not transferred at all.  

This is a great tool when dealing with multiple spreadsheets or documents that have different formatting.  It ensures the data you are pasting matches the data already in your spreadsheet.  

X

Leave a comment

Comments will be approved before showing up.