The copy and paste functions in Excel save time and effort, since there’s no need to retype information that already exists.\u00a0 In\u00a0 this post,\u00a0 I will cover and explain the different copy and paste operations that Excel offers.<\/p>\n
There are a million reasons under the sun to copy and paste in Excel.\u00a0 You may want to duplicate information in one column, another sheet or even another workbook.\u00a0 Perhaps you are copying and pasting data from another source, such as MS Access, your web browser, or a PDF document.\u00a0 Maybe you are moving data around within a worksheet or workbook.<\/p>\n
Copy vs. Cut in Excel<\/strong><\/p>\n When you select copy<\/strong> within Excel, you are telling the program that you would like to duplicate the information<\/strong>.<\/p>\n When you choose cut<\/strong> in Excel, you remove the data from where it currently exists<\/strong>, and place it elsewhere.<\/p>\n How to Copy<\/strong><\/p>\n To begin, you must select the data that you would like to copy.\u00a0 This will move the source data to the clipboard, which is a temporary holding place in the background.<\/p>\n Highlight the data.\u00a0 To copy using the mouse, right click, and select the copy option.\u00a0\u00a0 You may also use the keyboard shortcut – Ctrl + c.\u00a0 Click in the destination cell.<\/p>\n Paste Options Explained <\/p>\n Save<\/span><\/p>\n Save<\/span><\/p>\n Save<\/span><\/p>\n Save<\/span><\/p>\n Save<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" Top 5 Copy Paste Functions in Excel – A Detailed Guide The copy and paste functions in Excel save time and effort, since there’s no need to retype information that already exists.\u00a0 In\u00a0 this post,\u00a0 I will cover and explain the different copy and paste operations that Excel offers. There are a million reasons under […]<\/p>\n","protected":false},"author":1,"featured_media":242,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21,51],"tags":[23,37],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/accounting-1928237_1280.png?fit=1280%2C959&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-V","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/57"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":14,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":240,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/57\/revisions\/240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/242"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/strong><\/p>\n![\"Copy](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/xlCopyfull.jpg?resize=291%2C300&ssl=1\")
![\"Paste\"](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/paste1.jpg?resize=29%2C28&ssl=1\")
Paste<\/strong> – If you would like to paste your data as is, with no changes, right click and select this icon.<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/PValues.jpg?resize=28%2C26&ssl=1\")
Paste Values<\/strong> – If you’re copying a formula, but only want to paste the results, select this icon, with the numbers.<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/pFormulas.jpg?resize=23%2C24&ssl=1\")
Paste Formula<\/strong> – Say you wanted to paste just a formula or set of formulas, you would choose the option with the “fx” in the icon.\u00a0 Note that depending on what the formula is doing, the result may be different from the original.<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/pTranspose.jpg?resize=27%2C26&ssl=1\")
Paste and Transpose<\/strong> – The transpose option allows you to change the orientation of your data.\u00a0 Let’s say you had four items listed vertically.\u00a0 Using the transpose option would allow you to paste the items horizontally, or vice versa.<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/pFormatting.jpg?resize=24%2C26&ssl=1\")
Paste Formatting<\/strong> – Excel gives you the option of pasting the formatting only.\u00a0 If you had some nice shading, or conditional formatting and wanted to copy that, but not modify the formula or data of the target cell or range, then paste formatting would be the option to choose.<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2016\/09\/pLink.jpg?resize=23%2C26&ssl=1\")
Paste Link<\/strong> – You can simply paste a link to, or reference to the source as a formula or formulas if you are copying multiple cells.\u00a0 Hint: If you are copying only one cell, by default, the reference will be absolute.\u00a0 This means that you can move the formula around, but the cell(s) it is pointing to will not change.\u00a0 When copying multiple cells, the result will be relative references.<\/p>\n