{"id":2599,"date":"2014-02-06T16:00:19","date_gmt":"2014-02-06T15:00:19","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2599"},"modified":"2020-09-04T09:43:23","modified_gmt":"2020-09-04T07:43:23","slug":"moznosti-nabidky-vlozit-jinak-paste-special","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/moznosti-nabidky-vlozit-jinak-paste-special\/","title":{"rendered":"Excel Paste special options"},"content":{"rendered":"

<\/p>\n

When you copy cells in Excel, the user can choose how the\u00a0copy inserts. I often encounter questions as how\u00a0copying only the result value, not to change the column width, to transfer only the formatting etc. And all these problems are solved by a single choice – Paste special<\/strong>. Check out the article on the most common methods of insertion. If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

Paste special<\/h2>\n

Firstly, we copy a cell or range of cells by a command, for example CTRL + C. Most often we put the copy into the cell by Ctrl + V, but it puts everything into destination – formulas\u00a0\/ value, formatting, data validation, and other properties of the original\u00a0source. So if you want to only insert something, you must select the correct option of\u00a0the Paste spacial option.<\/p>\n