{"id":113,"date":"2023-03-29T00:03:52","date_gmt":"2023-03-29T00:03:52","guid":{"rendered":"https:\/\/www.tiposaurus.co.uk\/?p=113"},"modified":"2024-01-26T23:22:31","modified_gmt":"2024-01-26T23:22:31","slug":"shortcut-key-to-paste-values-in-excel","status":"publish","type":"post","link":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/","title":{"rendered":"Shortcut Key to Paste Values in Excel"},"content":{"rendered":"

If you came here looking for an easy shortcut key to paste values in Excel then it’s bad news I’m afraid – there just isn’t a simple keyboard shortcut in the same way there is to cut, copy or paste normally. However there is a way to paste values using the keyboard, which this tip shares with you – by using Alt keys.<\/p>\n

Paste Values Shortcut using Alt Keys<\/h2>\n

\"alt
\nIf you press Alt in Excel, you may have noticed that Excel puts letters on the ribbon, indicating the Alt key associated with that tab or function. If you press Alt, then press the letter for the tab you want (e.g. H is the home tab), you can then choose the function you want from that tab (e.g. C for copy, V for paste), and so on. Some items, including paste, have further sub-items which you can select by stringing these letters together.<\/p>\n

So to get to paste values this way, you can do the following: Alt - H - V - V<\/code>. Just press each one in time, no need to keep any key pressed.<\/p>\n","protected":false},"excerpt":{"rendered":"

If you came here looking for an easy shortcut key to paste values in Excel then it’s bad news I’m afraid – there just isn’t a simple keyboard shortcut in the same way there is to cut, copy or paste normally. However there is a way to paste values using the keyboard, which this tip … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"yoast_head":"\nShortcut Key to Paste Values in Excel - Tiposaurus<\/title>\n<meta name=\"description\" content=\"Keyboard shortcut to paste values in Excel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Shortcut Key to Paste Values in Excel - Tiposaurus\" \/>\n<meta property=\"og:description\" content=\"Keyboard shortcut to paste values in Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiposaurus\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-29T00:03:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-26T23:22:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/03\/altkeys.png\" \/>\n<meta name=\"author\" content=\"Steven\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steven\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\"},\"author\":{\"name\":\"Steven\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\"},\"headline\":\"Shortcut Key to Paste Values in Excel\",\"datePublished\":\"2023-03-29T00:03:52+00:00\",\"dateModified\":\"2024-01-26T23:22:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\"},\"wordCount\":187,\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\",\"name\":\"Shortcut Key to Paste Values in Excel - Tiposaurus\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\"},\"datePublished\":\"2023-03-29T00:03:52+00:00\",\"dateModified\":\"2024-01-26T23:22:31+00:00\",\"description\":\"Keyboard shortcut to paste values in Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tiposaurus.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shortcut Key to Paste Values in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"name\":\"Tiposaurus\",\"description\":\"Technology, Productivity and Development\",\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\",\"name\":\"Tiposaurus\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"contentUrl\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"width\":133,\"height\":97,\"caption\":\"Tiposaurus\"},\"image\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\",\"name\":\"Steven\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"caption\":\"Steven\"},\"sameAs\":[\"https:\/\/www.tiposaurus.co.uk\"],\"url\":\"https:\/\/www.tiposaurus.co.uk\/author\/steven\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Shortcut Key to Paste Values in Excel - Tiposaurus","description":"Keyboard shortcut to paste values in Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"Shortcut Key to Paste Values in Excel - Tiposaurus","og_description":"Keyboard shortcut to paste values in Excel","og_url":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/","og_site_name":"Tiposaurus","article_published_time":"2023-03-29T00:03:52+00:00","article_modified_time":"2024-01-26T23:22:31+00:00","og_image":[{"url":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/03\/altkeys.png"}],"author":"Steven","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steven","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/"},"author":{"name":"Steven","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c"},"headline":"Shortcut Key to Paste Values in Excel","datePublished":"2023-03-29T00:03:52+00:00","dateModified":"2024-01-26T23:22:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/"},"wordCount":187,"publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"articleSection":["Excel"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/","url":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/","name":"Shortcut Key to Paste Values in Excel - Tiposaurus","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/#website"},"datePublished":"2023-03-29T00:03:52+00:00","dateModified":"2024-01-26T23:22:31+00:00","description":"Keyboard shortcut to paste values in Excel","breadcrumb":{"@id":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tiposaurus.co.uk\/shortcut-key-to-paste-values-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tiposaurus.co.uk\/"},{"@type":"ListItem","position":2,"name":"Shortcut Key to Paste Values in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.tiposaurus.co.uk\/#website","url":"https:\/\/www.tiposaurus.co.uk\/","name":"Tiposaurus","description":"Technology, Productivity and Development","publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.tiposaurus.co.uk\/#organization","name":"Tiposaurus","url":"https:\/\/www.tiposaurus.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","contentUrl":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","width":133,"height":97,"caption":"Tiposaurus"},"image":{"@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c","name":"Steven","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","caption":"Steven"},"sameAs":["https:\/\/www.tiposaurus.co.uk"],"url":"https:\/\/www.tiposaurus.co.uk\/author\/steven\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":134,"url":"https:\/\/www.tiposaurus.co.uk\/excel-tips-and-tricks-for-financial-modeling\/","url_meta":{"origin":113,"position":0},"title":"Excel Tips and Tricks for Financial Modeling","author":"Steven","date":"April 10, 2023","format":false,"excerpt":"Financial modeling is an essential skill for finance professionals, allowing them to project financial performance, evaluate investment opportunities, and make informed decisions. Microsoft Excel is the go-to software for building financial models, thanks to its flexibility, functionality, and ease of use. In this blog post, we'll share tips and tricks\u2026","rel":"","context":"In "Excel"","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":131,"url":"https:\/\/www.tiposaurus.co.uk\/set-read-only-recommended-in-excel\/","url_meta":{"origin":113,"position":1},"title":"Set Read Only Recommended in Excel","author":"Steven","date":"September 14, 2022","format":false,"excerpt":"In this guide, we'll explain how to set read only recommended in Excel. That means that whenever someone opens it, Excel will suggest they open it as read only. While setting read only recommended can prevent accidental modifications, users can still choose not to open as read only, so we'll\u2026","rel":"","context":"In "Excel"","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/09\/readonly_1_info-1024x453.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":58,"url":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","url_meta":{"origin":113,"position":2},"title":"Display the Weekday as Text in Excel","author":"Steven","date":"September 19, 2022","format":false,"excerpt":"I often want to know what day of the week a date is. The obvious choice in Excel is the WEEKDAY() function for this; however it only returns an integer. For example, the formula: =WEEKDAY(\"01\/02\/2009\") returns 1 (which represents Sunday). In this article, I'll describe the various ways which you\u2026","rel":"","context":"In "Excel"","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":135,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-calculate-net-present-values-in-excel\/","url_meta":{"origin":113,"position":3},"title":"How to Calculate Net Present Values in Excel","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"Introduction Net Present Value (NPV) is a widely used financial metric that helps investors and business managers to evaluate the profitability of an investment or project. NPV calculates the difference between the present value of cash inflows and the present value of cash outflows over a certain period. A positive\u2026","rel":"","context":"In "Excel"","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":130,"url":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","url_meta":{"origin":113,"position":4},"title":"How to use MINIFS in Excel","author":"Steven","date":"August 30, 2022","format":false,"excerpt":"You'll likely be familiar with the MIN function for taking the value of a range: MIN(A1:A5) will return the minimum value in cells A1:A5.\u00a0 If you need to take a conditional minimum, which applies to only some of the values in that range, without splitting your data up, then the\u2026","rel":"","context":"In "Functions"","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"example example and uses of MINIFS","src":"https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":71,"url":"https:\/\/www.tiposaurus.co.uk\/the-dictionary-object-in-excel-vba-definitive-guide\/","url_meta":{"origin":113,"position":5},"title":"The Dictionary Object in Excel VBA – Definitive Guide","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"1. Introduction This guide aims to provide a comprehensive understanding of the Dictionary object in Excel VBA, including an overview of its features and the advantages it offers over other data structures like arrays and collections. We will also cover how to include the necessary library, create a dictionary, add\u2026","rel":"","context":"In "VBA"","block_context":{"text":"VBA","link":"https:\/\/www.tiposaurus.co.uk\/category\/vba\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/113"}],"collection":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/comments?post=113"}],"version-history":[{"count":2,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":116,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/113\/revisions\/116"}],"wp:attachment":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/media?parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/categories?post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/tags?post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}