If your Excel spreadsheet freezes when copying and pasting, Uncheck Show cut, copy and paste options, Disable the Live Preview option, etc.

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.

Automate Copy & Pasting in Excel With This Simple Solution Watch this video on YouTube. Find more information on Excel Data Automation by browsing our extensive range of articles, guides and ...