A blog about Excel and its users
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.
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