{"id":388,"date":"2023-10-30T19:52:35","date_gmt":"2023-10-30T19:52:35","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/duplicar\/"},"modified":"2023-12-25T10:25:26","modified_gmt":"2023-12-25T10:25:26","slug":"duplicar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/duplicar\/","title":{"rendered":"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-947438016\"><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>En Excel, si desea crear una hoja duplicada, es decir, crear una copia de una hoja en el mismo libro, puede utilizar dos m\u00e9todos diferentes.<\/p>\n<ul>\n<li> Arrastra y suelta con el rat\u00f3n.<\/li>\n<li> Crear una copia duplicada con copiar y mover<\/li>\n<\/ul>\n<p> En este tutorial, veremos ambos m\u00e9todos.<\/p>\n<h2 id=\"h-drag-and-drop-to-create-a-duplicate-sheet\" class=\"wp-block-heading\"> Arrastra y suelta para crear una hoja duplicada<\/h2>\n<ol type=\"1\">\n<li> Primero, active la hoja para la que desea crear una copia.<\/li>\n<li> Ahora presione la tecla Ctrl.<\/li>\n<li> Despu\u00e9s de eso, manteniendo presionada la tecla Ctrl, haga clic en la pesta\u00f1a de la hoja.<\/li>\n<li> Al final, arrastre y suelte la hoja en una nueva ubicaci\u00f3n en las pesta\u00f1as de la hoja. <\/li>\n<\/ol>\n<figure class=\"gb-block-image gb-block-image-b115ad26\"><img loading=\"lazy\" decoding=\"async\" class=\"gb-image gb-image-b115ad26\" title=\"duplicar-hoja-de-excel-arrastrar y soltar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\" sizes=\"auto, \" srcset=\"\" alt=\"duplicate-sheet-excel-drag-drop\" width=\"890\" height=\"306\"><\/figure>\n<p> Crea una hoja duplicada de la hoja, que se desliza y cae. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92667\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-glisser-deposer-pour-creer-une-feuille-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"arrastrar y soltar para crear una hoja duplicada\" width=\"546\" height=\"224\"><\/figure>\n<\/div>\n<p> Puedes ver en el ejemplo anterior; tienes una nueva hoja duplicada de \u00abHoja3\u00bb con (2) con el nombre original.<\/p>\n<h2 id=\"h-use-copy-and-move-to-create-a-duplicate-copy-of-the-sheet\" class=\"wp-block-heading\"> Utilice Copiar y Mover para crear una copia duplicada de la hoja.<\/h2>\n<p> Cuando hace clic derecho en la pesta\u00f1a de una hoja, puede ver las opciones \u00abMover o Copiar\u00bb all\u00ed. Esta opci\u00f3n le permite copiar la hoja a un libro nuevo o a un libro existente que est\u00e9 abierto. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92668\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-copier-et-deplacer-vers-la-feuille-dupliquee.png\" sizes=\"auto, \" srcset=\"\" alt=\"copiar y mover a hoja duplicada\" width=\"483\" height=\"390\"><\/figure>\n<\/div>\n<p> Pero con la misma opci\u00f3n puedes crear una copia de hoja duplicada en el mismo libro. Al hacer clic en la opci\u00f3n, aparecer\u00e1 un cuadro de di\u00e1logo para seleccionar el destino para copiar la hoja. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92669\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copies-dans-le-meme-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"copiar al mismo libro de trabajo\" width=\"548\" height=\"391\"><\/figure>\n<\/div>\n<p> En el cuadro de di\u00e1logo Mover o Copiar, marque la casilla \u00abHacer una copia\u00bb y aseg\u00farese de tener el mismo nombre de libro en \u00abPara reservar:\u00bb. Al final, haga clic en Aceptar para crear una copia duplicada. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92670\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coche-creer-une-copie.png\" sizes=\"auto, \" srcset=\"\" alt=\"marcar-crear-una-copia\" width=\"652\" height=\"212\"><\/figure>\n<\/div>\n<p> Puede elegir la posici\u00f3n para agregar la hoja duplicada en este cuadro de di\u00e1logo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92671\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-choisissez-la-position-pour-ajouter-une-feuille-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"elija-la-posicion-para-agregar-la-hoja-duplicada\" width=\"348\" height=\"323\"><\/figure>\n<\/div>\n<p class=\"qt-tip\"> <strong>Nota:<\/strong> De los dos m\u00e9todos, el primero es r\u00e1pido y sencillo. Pero puedes utilizar cualquiera de ellos seg\u00fan tus preferencias. <\/p>\n<div class=\"gb-container gb-container-3044ba66 gb-container-mt\">\n<p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/es\/conceptos-basicos-de-excel\/\">Conceptos b\u00e1sicos de Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/es\/hoja-de-calculo\/\" data-wpil=\"url\">Hoja de c\u00e1lculo de Excel<\/a><\/strong><\/p>\n<h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-530ab33a\">\n<div class=\"gb-container gb-container-530ab33a\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-1\/\">Eliminar una hoja (hoja de trabajo) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/enlace-a-otra-hoja\/\">Crear un hiperv\u00ednculo (enlace) a otra hoja de c\u00e1lculo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cerrar\/\">Bloquear una hoja (hoja de trabajo) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/actualizar\/\">Actualizar una hoja (hoja de c\u00e1lculo) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/abierto\/\">Desbloquear una hoja con contrase\u00f1a (sin contrase\u00f1a)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, si desea crear una hoja duplicada, es decir, crear una copia de una hoja en el mismo libro, puede utilizar dos m\u00e9todos diferentes. Arrastra y suelta con el rat\u00f3n. Crear una copia duplicada con copiar y mover En este tutorial, veremos ambos m\u00e9todos. Arrastra y suelta para crear una hoja duplicada Primero, active [&hellip;]<\/p>\n","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-388","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>\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?<\/title>\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\/es\/duplicar\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, si desea crear una hoja duplicada, es decir, crear una copia de una hoja en el mismo libro, puede utilizar dos m\u00e9todos diferentes. Arrastra y suelta con el rat\u00f3n. Crear una copia duplicada con copiar y mover En este tutorial, veremos ambos m\u00e9todos. Arrastra y suelta para crear una hoja duplicada Primero, active [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/duplicar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/duplicar\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/duplicar\/\",\"name\":\"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/duplicar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/duplicar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\",\"datePublished\":\"2023-10-30T19:52:35+00:00\",\"dateModified\":\"2023-12-25T10:25:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/duplicar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/duplicar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/duplicar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/duplicar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en 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:\/\/exceladvisor.org\/es\/duplicar\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?","og_description":"En Excel, si desea crear una hoja duplicada, es decir, crear una copia de una hoja en el mismo libro, puede utilizar dos m\u00e9todos diferentes. Arrastra y suelta con el rat\u00f3n. Crear una copia duplicada con copiar y mover En este tutorial, veremos ambos m\u00e9todos. Arrastra y suelta para crear una hoja duplicada Primero, active [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/duplicar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/duplicar\/","url":"https:\/\/exceladvisor.org\/es\/duplicar\/","name":"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/duplicar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/duplicar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif","datePublished":"2023-10-30T19:52:35+00:00","dateModified":"2023-12-25T10:25:26+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/duplicar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/duplicar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/duplicar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/duplicar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo crear una hoja de trabajo duplicada en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=388"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/388\/revisions"}],"predecessor-version":[{"id":1057,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/388\/revisions\/1057"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}