1. Home
  2. Knowledge Base
  3. Troubleshooting
  4. Trouble with Copy/Paste when Using Resources

Trouble with Copy/Paste when Using Resources

If you copy/paste data into an Amalgam resource, you may notice certain issues due to the way Excel handles the copy/paste feature.

The magic of Paste Special

Most likely, when you copy something into an Amalgam sheet, you probably just want the value. However, excel brings all sorts of other stuff along for the ride by default. Almost everything in excel is relative to the values of the other cells around it, so you might copy one thing and have it appear as completely another by the time it reaches the destination.

This is where paste special comes in handy. You can access it with either alt + e, s in both Excel and Google Sheets, or with platform-specific shortcuts of ctrl + alt + v in Excel or ctrl + shift + v in google sheets.

The option you probably want – paste values – is right there. However, the other options, such as paste formatting only, may be helpful to you in other situations.

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support