{"id":367,"date":"2022-12-01T15:10:22","date_gmt":"2022-12-01T15:10:22","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=367"},"modified":"2024-01-29T20:38:39","modified_gmt":"2024-01-29T20:38:39","slug":"how-to-paste-special-shortcuts-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-paste-special-shortcuts-in-excel\/","title":{"rendered":"How to Paste Special Shortcuts in Excel"},"content":{"rendered":"<p>Paste Special Shortcuts in Excel are your secret weapons for precision and efficiency in data manipulation. These keyboard shortcuts put the power of data formatting and transformation right at your fingertips, allowing you to seamlessly tailor your Excel worksheets to meet your exact needs. With &#8216;Paste Special Shortcuts in Excel,&#8217; you&#8217;re not just pasting data; you&#8217;re performing intricate operations, applying formatting, and transposing data effortlessly. Embrace the simplicity and impact of these shortcuts to make your Excel experience smoother and more productive. Whether it&#8217;s pasting values, formats, or performing complex operations, &#8216;Paste Special Shortcuts in Excel&#8217; are the go-to tools for Excel users who value precision and efficiency in their data handling.<\/p>\n<p>The following screenshot shows each Paste Special option that is offered<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-368 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-1.png\" alt=\"Paste Special Shortcuts in Excel\" width=\"612\" height=\"473\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-1.png 612w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-1-300x232.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/p>\n<p class=\"Default\"><span lang=\"EN-US\" style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">All of the Paste Special commands work within the same worksheet as well as across different sheets and workbooks.<\/span><\/p>\n<h2><strong>How to use past special in Excel?<\/strong><\/h2>\n<p class=\"Default\"><strong>Step-1: <\/strong>Prepare a data table with information outlined below<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-369 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-2.png\" alt=\"Paste Special Shortcuts in Excel\" width=\"646\" height=\"377\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-2.png 646w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-2-300x175.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Copy Cell D2 (Select Cell D2 and press Ctrl+C)<\/p>\n<p><strong>Step-2: <\/strong>Select Home, select the clipboard icon (Paste) and pick the specific paste option you want, outlined below<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-370 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-3.png\" alt=\"Paste Special Shortcuts in Excel\" width=\"253\" height=\"327\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-3.png 253w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-3-232x300.png 232w\" sizes=\"(max-width: 253px) 100vw, 253px\" \/><\/p>\n<p>Alternatively, you can right-click a cell where you want to paste the copied data, and then click Paste Special in the context menu., outlined below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-371\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-4.png\" alt=\"Paste special\" width=\"352\" height=\"341\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-4.png 352w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-4-300x291.png 300w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/p>\n<p>Or you can use shortcut key for Paste Special: <strong>Ctrl+Alt+V. <\/strong>Paste Special dialog box will appear, outlined below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-372\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-5.png\" alt=\"Paste special\" width=\"666\" height=\"520\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-5.png 666w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-5-300x234.png 300w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/p>\n<p><strong>Step-2: <\/strong>Now select the required option from the Paste Special dialog box. See the below mentioned Excel <strong>Paste Special<\/strong> <strong>Shortcut Keys, Operation, and Description<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-373\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-6.png\" alt=\"Paste Special\" width=\"702\" height=\"702\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-6.png 702w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-6-300x300.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-6-150x150.png 150w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/p>\n<h2><strong>Example-1<\/strong> <strong>Shortcut to Paste Formulas<\/strong><\/h2>\n<ul>\n<li>Copy Cell D2 outline in Step 1<\/li>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<li>Select only Formula from Paste Special dialog box, outlined below<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-374\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-7.png\" alt=\"paste Special\" width=\"798\" height=\"442\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-7.png 798w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-7-300x166.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-7-768x425.png 768w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/p>\n<p>Click Ok, Result outlined below (only formula paste in cell D3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-375\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-8.png\" alt=\"Paste special\" width=\"540\" height=\"428\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-8.png 540w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-8-300x238.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/p>\n<h2><strong>Example-2<\/strong> <strong>Shortcut to Paste Values<\/strong><\/h2>\n<ul>\n<li>Copy Cell D2 outline in Step 1<\/li>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<li>Select only <strong>Values<\/strong> from Paste Special dialog box, outlined below<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-376\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-9.png\" alt=\"Paste special\" width=\"758\" height=\"433\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-9.png 758w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-9-300x171.png 300w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (only Cell D2 value will paste in cell D3 instead of formula)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-377\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-10.png\" alt=\"Paste special\" width=\"477\" height=\"375\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-10.png 477w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-10-300x236.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/p>\n<h2><strong>Example-3<\/strong> <strong>Shortcut to Paste Formats<\/strong><\/h2>\n<ul>\n<li>Copy Cell D2 outline in Step 1<\/li>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<li>Select only <strong>Formats<\/strong> from Paste Special dialog box, outlined below<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-378\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-11.png\" alt=\"Paste special\" width=\"707\" height=\"392\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-11.png 707w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-11-300x166.png 300w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (only Cell D2 format will paste in cell D3 instead of formula and values):<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-379\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-12.png\" alt=\"Paste special\" width=\"473\" height=\"377\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-12.png 473w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-12-300x239.png 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/p>\n<h2><strong>Example-4<\/strong> <strong>Shortcut to Paste Comments and Notes<\/strong><\/h2>\n<p>Copy Cell D2 outline below (D2 include a Note)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-380\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-13.png\" alt=\"Paste special\" width=\"473\" height=\"262\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-13.png 473w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-13-300x166.png 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/p>\n<ul>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<li>Select only <strong>Comments and Notes<\/strong> from Paste Special dialog box, outlined below<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-381\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-14.png\" alt=\"Paste special\" width=\"763\" height=\"361\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-14.png 763w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-14-300x142.png 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (only Cell D2 Note or comments will paste in cell D3):<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-382\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-15.png\" alt=\"Paste special\" width=\"537\" height=\"425\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-15.png 537w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-15-300x237.png 300w\" sizes=\"(max-width: 537px) 100vw, 537px\" \/><\/p>\n<h2><strong>Example-5<\/strong> <strong>Shortcut to Paste Validation<\/strong><\/h2>\n<ul>\n<li>Copy Cell B2 outline below (B2 include a Data Validation)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-383\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-16.png\" alt=\"Paste special\" width=\"477\" height=\"298\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-16.png 477w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-16-300x187.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/p>\n<ul>\n<li>Select Cell B3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<li>Select only <strong>Validation<\/strong> from Paste Special dialog box, outlined below<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-384\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-17.png\" alt=\"Paste Special\" width=\"573\" height=\"356\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-17.png 573w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-17-300x186.png 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (only Cell B2 Data Validation will paste in cell B3):<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-386\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-18.png\" alt=\"Paste Special\" width=\"433\" height=\"293\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-18.png 433w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-18-300x203.png 300w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/p>\n<h2><strong>Example-6<\/strong> <strong>Operation Part, Shortcut Paste to Add<\/strong><\/h2>\n<ul>\n<li>Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-387\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-19.png\" alt=\"Paste Special\" width=\"463\" height=\"312\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-19.png 463w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-19-300x202.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/p>\n<ul>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<\/ul>\n<p>Select only <strong>Add <\/strong>from Paste Special dialog box operation part, outlined below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-388\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-20.png\" alt=\"Paste Special\" width=\"598\" height=\"328\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-20.png 598w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-20-300x165.png 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (Cell D2 value will add with cell D3 value):<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-389\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-21.png\" alt=\"Paste Special\" width=\"537\" height=\"352\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-21.png 537w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-21-300x197.png 300w\" sizes=\"(max-width: 537px) 100vw, 537px\" \/><\/p>\n<h2><strong>Example-7<\/strong> <strong>Operation Part, Shortcut Paste to Subtract<\/strong><\/h2>\n<ul>\n<li>Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-390\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-22.png\" alt=\"Paste Special\" width=\"380\" height=\"256\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-22.png 380w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-22-300x202.png 300w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/p>\n<ul>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<\/ul>\n<p>Select only <strong>Subtract <\/strong>from Paste Special dialog box operation part, outlined below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-391\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-23.png\" alt=\"Paste Special\" width=\"768\" height=\"402\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-23.png 768w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-23-300x157.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (Cell D2 value will Subtract with cell D3 value):<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-392\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-24.png\" alt=\"Paste Special\" width=\"442\" height=\"361\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-24.png 442w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-24-300x245.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/p>\n<p><strong>Example-8<\/strong> <strong>Operation Part, Shortcut Paste to Multiply<\/strong>:<\/p>\n<ul>\n<li>Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-393\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-25.png\" alt=\"Paste special\" width=\"377\" height=\"253\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-25.png 377w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-25-300x201.png 300w\" sizes=\"(max-width: 377px) 100vw, 377px\" \/><\/p>\n<ul>\n<li>Select Cell D3<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong><\/li>\n<\/ul>\n<p>Select only <strong>Multiply <\/strong>from Paste Special dialog box operation part, outlined below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-394\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-26.png\" alt=\"Paste Special\" width=\"698\" height=\"357\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-26.png 698w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Paste-Special-26-300x153.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/p>\n<ul>\n<li>Click Ok, Result outlined below (Cell D2 value will Multiply with cell D3 value):<\/li>\n<\/ul>\n<h2><strong>Application of Paste Special Shortcuts in Excel<\/strong><\/h2>\n<ol>\n<li><strong>Values Only (Alt + E, S, V)<\/strong>:\n<ul>\n<li>Paste values without formatting, removing any formulas or links from the copied data.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Formats Only (Alt + E, S, T)<\/strong>:\n<ul>\n<li>Copy cell formatting (e.g., font, color) and apply it to selected cells without changing their content.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Transpose (Alt + E, S, E)<\/strong>:\n<ul>\n<li>Swap rows and columns by pasting data in a transposed manner, converting columns into rows and vice versa.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Operations (Alt + E, S, O)<\/strong>:\n<ul>\n<li>Perform arithmetic operations during paste, such as adding, subtracting, multiplying, or dividing data.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Column Widths (Alt + E, S, W)<\/strong>:\n<ul>\n<li>Copy and paste column widths from one range to another, ensuring consistent formatting.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Validation (Alt + E, S, N)<\/strong>:\n<ul>\n<li>Copy data validation rules from one cell to another, ensuring consistent data entry.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>These Paste Special shortcuts streamline data manipulation and formatting tasks in Excel, saving time and ensuring accuracy in your worksheets.<\/p>\n<p>You may be interested:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Paste Special Shortcuts in Excel are your secret weapons for precision and efficiency in data manipulation. These keyboard shortcuts put the power of data formatting and transformation right at your fingertips, allowing you to seamlessly tailor your Excel worksheets to meet your exact needs. With &#8216;Paste Special Shortcuts in Excel,&#8217; you&#8217;re not just pasting data; &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-paste-special-shortcuts-in-excel\/\"> <span class=\"screen-reader-text\">How to Paste Special Shortcuts in Excel<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[202],"tags":[203,204],"class_list":["post-367","post","type-post","status-publish","format-standard","hentry","category-paste-special-shortcuts-in-excel","tag-paste-special-in-excel","tag-paste-special-shortcuts"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=367"}],"version-history":[{"count":6,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/367\/revisions"}],"predecessor-version":[{"id":8332,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/367\/revisions\/8332"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}