{"id":115,"date":"2023-11-16T04:16:08","date_gmt":"2023-11-16T04:16:08","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/"},"modified":"2023-12-06T11:36:25","modified_gmt":"2023-12-06T11:36:25","slug":"copiar-colar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/","title":{"rendered":"Como copiar e colar via atalho do excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3643064444\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-3619916217\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Copiar e colar \u00e9 o recurso mais comumente usado do Excel. Este recurso \u00e9 usado para copiar e colar dados de um lugar para outro. Os usu\u00e1rios podem criar v\u00e1rias c\u00f3pias dos dados copiados em v\u00e1rios locais da mesma planilha, em planilhas diferentes ou em v\u00e1rias pastas de trabalho.<\/p><p> Como outros recursos do Excel, esse recurso tamb\u00e9m possui um atalho de teclado e se voc\u00ea adora atalhos de teclado, deve conhecer esse atalho de copiar e colar.<\/p><h2 class=\"wp-block-heading\"> Atalho de teclado para copiar e colar no Excel<\/h2><p> <kbd>Ctrl<\/kbd> + <kbd>C<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"c\u00f3pia de atalho de teclado\" width=\"809\" height=\"317\"><\/figure><\/div><p> <kbd>Ctrl<\/kbd> + <kbd>V<\/kbd> ou <kbd>Enter<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-coller.png\" sizes=\"auto, \" srcset=\"\" alt=\"colar de atalho de teclado\" width=\"813\" height=\"319\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Etapas para copiar e colar usando o atalho do teclado<\/h2><ul><li> Primeiro, v\u00e1 at\u00e9 a c\u00e9lula ou selecione o intervalo de c\u00e9lulas do qual deseja copiar os dados e pressione as teclas \u201cCtrl + C\u201d. <br><img decoding=\"async\" title=\"3-copie o intervalo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copier-la-plage.png\" sizes=\"\" srcset=\"\" alt=\"copy-the-range\"><\/li><li> Depois disso, v\u00e1 at\u00e9 a c\u00e9lula onde deseja colar os dados copiados e pressione a tecla \u201cEnter\u201d ou as teclas \u201cCtrl + V\u201d e seus dados ser\u00e3o colados\/copiados l\u00e1. <br><img decoding=\"async\" title=\"4-cole os dados\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coller-les-donnees.png\" sizes=\"\" srcset=\"\" alt=\"paste-the-data\"><\/li><\/ul><p> Na imagem acima voc\u00ea pode ver que pressionamos \u201cCtrl + V\u201d na c\u00e9lula \u201cF1\u201d, e os dados copiados foram colados l\u00e1.<\/p><h2 class=\"wp-block-heading\"> Aprendizado<\/h2><ul><li> Para colar os dados em um local, voc\u00ea pode usar a tecla \u201cEnter\u201d para colar os dados.<\/li><li> Para colar os dados copiados em v\u00e1rios locais, voc\u00ea precisa usar as teclas \u201cCtrl + V\u201d, caso contr\u00e1rio, voc\u00ea precisa copiar os dados repetidamente para col\u00e1-los em v\u00e1rios locais.<\/li><li> Para colar os dados usando a op\u00e7\u00e3o especial de colar (somente valor, f\u00f3rmula ou formato), voc\u00ea precisa usar as teclas \u201cCtrl + Alt + V\u201d para colar os dados copiados. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Mais atalhos <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-51\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/referencia-absoluta\/\">Refer\u00eancia absoluta<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/copiar-e-colar\/\">Copiar e colar<\/a><\/li><li> Bloquear c\u00e9lulas<\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/colar-valores\/\">Colar valores<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/selecione-uma-linha\/\">Selecione uma linha<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/transpor-2\/\">Transpor<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-115","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como copiar e colar via atalho do Excel? - Consultor Excel<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para copiar e colar no Excel. Agora este atalho de teclado\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como copiar e colar via atalho do Excel? - Consultor Excel\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para copiar e colar no Excel. Agora este atalho de teclado\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:36:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/\",\"name\":\"Como copiar e colar via atalho do Excel? - Consultor Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\",\"datePublished\":\"2023-11-16T04:16:08+00:00\",\"dateModified\":\"2023-12-06T11:36:25+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para copiar e colar no Excel. Agora este atalho de teclado\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como copiar e colar via atalho do excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como copiar e colar via atalho do Excel? - Consultor Excel","description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para copiar e colar no Excel. Agora este atalho de teclado","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:\/\/exceladvisor.org\/pt\/copiar-colar\/","og_locale":"pt_PT","og_type":"article","og_title":"Como copiar e colar via atalho do Excel? - Consultor Excel","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para copiar e colar no Excel. Agora este atalho de teclado","og_url":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:36:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/","url":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/","name":"Como copiar e colar via atalho do Excel? - Consultor Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","datePublished":"2023-11-16T04:16:08+00:00","dateModified":"2023-12-06T11:36:25+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para copiar e colar no Excel. Agora este atalho de teclado","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/copiar-colar\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/copiar-colar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como copiar e colar via atalho do excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=115"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/115\/revisions"}],"predecessor-version":[{"id":954,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/115\/revisions\/954"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}