{"id":9306,"date":"2019-10-30T07:49:40","date_gmt":"2019-10-30T05:49:40","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9306"},"modified":"2019-10-30T07:49:42","modified_gmt":"2019-10-30T05:49:42","slug":"how-to-copy-paste-only-values-without-formatting-excel-2007","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/","title":{"rendered":"How to copy paste only values without formatting? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">You should\ncopy and special paste only the values of the range and afterwards simply\ndelete the cells you just copied into another location. The reason for using\ncopy instead of cut is because Paste Special is not applicable in case of\ncutting.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to copy paste only values without formatting? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/gYG8_S5yU9A?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>You should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3501],"tags":[3731,3509,3673,3762],"class_list":["post-9306","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-copy","tag-excel-2007","tag-formatting","tag-paste"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"You should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Karl\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#article\",\"name\":\"How to copy paste only values without formatting? | Excel 2007 | Office ToDo\",\"headline\":\"How to copy paste only values without formatting? | Excel 2007\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-10-30T07:49:40+02:00\",\"dateModified\":\"2019-10-30T07:49:42+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#webpage\"},\"articleSection\":\"Excel 2007, copy, excel 2007, formatting, paste\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"position\":2,\"name\":\"MS Office\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"name\":\"Excel 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"position\":3,\"name\":\"Excel 2007\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#listItem\",\"name\":\"How to copy paste only values without formatting? | Excel 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#listItem\",\"position\":4,\"name\":\"How to copy paste only values without formatting? | Excel 2007\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"name\":\"Excel 2007\"}}]},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\",\"name\":\"Office ToDo\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/\",\"name\":\"Karl\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/\",\"name\":\"How to copy paste only values without formatting? | Excel 2007 | Office ToDo\",\"description\":\"You should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-copy-paste-only-values-without-formatting-excel-2007\\\/#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2019-10-30T07:49:40+02:00\",\"dateModified\":\"2019-10-30T07:49:42+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\",\"name\":\"Office ToDo\",\"inLanguage\":\"en\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to copy paste only values without formatting? | Excel 2007 | Office ToDo","description":"You should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.","canonical_url":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#article","name":"How to copy paste only values without formatting? | Excel 2007 | Office ToDo","headline":"How to copy paste only values without formatting? | Excel 2007","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-10-30T07:49:40+02:00","dateModified":"2019-10-30T07:49:42+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#webpage"},"articleSection":"Excel 2007, copy, excel 2007, formatting, paste"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","position":1,"name":"Home","item":"http:\/\/www.officetodo.com\/public","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","position":2,"name":"MS Office","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","name":"Excel 2007"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","position":3,"name":"Excel 2007","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#listItem","name":"How to copy paste only values without formatting? | Excel 2007"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#listItem","position":4,"name":"How to copy paste only values without formatting? | Excel 2007","previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","name":"Excel 2007"}}]},{"@type":"Organization","@id":"http:\/\/www.officetodo.com\/public\/#organization","name":"Office ToDo","url":"http:\/\/www.officetodo.com\/public\/"},{"@type":"Person","@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author","url":"http:\/\/www.officetodo.com\/public\/author\/admin\/","name":"Karl"},{"@type":"WebPage","@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#webpage","url":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/","name":"How to copy paste only values without formatting? | Excel 2007 | Office ToDo","description":"You should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/#breadcrumblist"},"author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"creator":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"datePublished":"2019-10-30T07:49:40+02:00","dateModified":"2019-10-30T07:49:42+02:00"},{"@type":"WebSite","@id":"http:\/\/www.officetodo.com\/public\/#website","url":"http:\/\/www.officetodo.com\/public\/","name":"Office ToDo","inLanguage":"en","publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"}}]}},"aioseo_meta_data":{"post_id":"9306","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-05 05:06:52","updated":"2026-05-27 00:07:04","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/\" title=\"MS Office\">MS Office<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/\" title=\"Excel 2007\">Excel 2007<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to copy paste only values without formatting? | Excel 2007\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.officetodo.com\/public"},{"label":"MS Office","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/"},{"label":"Excel 2007","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/"},{"label":"How to copy paste only values without formatting? | Excel 2007","link":"http:\/\/www.officetodo.com\/public\/how-to-copy-paste-only-values-without-formatting-excel-2007\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=9306"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9306\/revisions"}],"predecessor-version":[{"id":9307,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9306\/revisions\/9307"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9306"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}