{"id":122,"date":"2023-11-15T20:03:44","date_gmt":"2023-11-15T20:03:44","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/borrar\/"},"modified":"2023-12-25T10:25:07","modified_gmt":"2023-12-25T10:25:07","slug":"borrar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/borrar\/","title":{"rendered":"\u00bfc\u00f3mo eliminar valores de celda en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2089154067\"><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>La forma m\u00e1s r\u00e1pida de eliminar valores de celda es utilizar la tecla \u00abEliminar\u00bb del teclado. Los usuarios pueden eliminar completamente los valores ingresados en las celdas usando la tecla de m\u00e9todo abreviado de teclado \u00abEliminar\u00bb y dejar las celdas en blanco.<\/p>\n<p> O, a veces, los usuarios descubren que el valor ingresado en la celda est\u00e1 mal escrito o ingresado con un valor adicional y, para eliminar esos caracteres o valores adicionales, pueden usar la tecla de m\u00e9todo abreviado de teclado \u00abEliminar\u00bb para corregir el valor.<\/p>\n<h2 class=\"wp-block-heading\"> Atajo de teclado para eliminar en Excel<\/h2>\n<p> El m\u00e9todo abreviado de teclado para eliminar valores se menciona a continuaci\u00f3n:<\/p>\n<p> <kbd>BORRAR<\/kbd> <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74576\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"borrar teclado\" width=\"839\" height=\"329\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para eliminar valores usando un atajo de teclado<\/h2>\n<ol>\n<li> Primero seleccione la(s) celda(s) cuyos valores desea eliminar. <br \/><img decoding=\"async\" title=\"selecci\u00f3n de 2 celdas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selection-de-cellules.png\" sizes=\"\" srcset=\"\" alt=\"selection-of-cells\"><\/li>\n<li> Una vez seleccionado, simplemente presione la tecla \u201cEliminar\u201d en el teclado, los valores se eliminar\u00e1n y las celdas quedar\u00e1n vac\u00edas. <br \/><img decoding=\"async\" title=\"3-valores-eliminar-celdas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-supprimees-des-cellules.png\" sizes=\"\" srcset=\"\" alt=\"values-delete-from-cells\"><\/li>\n<li> O seleccione la celda en modo de edici\u00f3n usando las teclas \u201cFn + F2\u201d y mueva el cursor a la izquierda del car\u00e1cter que desea eliminar. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4 celdas en modo edici\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-en-mode-edition.png\" sizes=\"auto, \" srcset=\"\" alt=\"cell-in-edit-mode\" width=\"539\" height=\"229\"><\/li>\n<li> Una vez hecho esto, presione la tecla \u00abEliminar\u00bb y esto eliminar\u00e1 un solo car\u00e1cter escrito a la derecha del cursor.<\/li>\n<li> Presione la tecla \u00abEliminar\u00bb varias veces para eliminar varios caracteres. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-eliminar-valor-car\u00e1cter\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-supprimer-le-caractere-de-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"delete-character-from-value\" width=\"547\" height=\"234\"><\/li>\n<\/ol>\n<p> En la imagen de arriba, puede ver que cuando presionamos la tecla \u00abEliminar\u00bb, Excel elimin\u00f3 el car\u00e1cter \u00abt\u00bb que estaba colocado hacia la derecha del cursor. <\/p>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s atajos <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-122\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/filtro-1\/\">Aplicar y quitar filtro<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/\">Suma autom\u00e1tica<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contenido-claro\/\">Borrar contenido<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/bajar-deslizandose\/\">Deslizar hacia abajo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/\">Mostrar f\u00f3rmulas<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p> \u21e0 Volver a <a href=\"https:\/\/exceladvisor.org\/es\/atajos-de-teclado\/\">los atajos de Excel (hoja de referencia en PDF)<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La forma m\u00e1s r\u00e1pida de eliminar valores de celda es utilizar la tecla \u00abEliminar\u00bb del teclado. Los usuarios pueden eliminar completamente los valores ingresados en las celdas usando la tecla de m\u00e9todo abreviado de teclado \u00abEliminar\u00bb y dejar las celdas en blanco. O, a veces, los usuarios descubren que el valor ingresado en la celda [&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-122","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 eliminar valores de celda 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\/borrar\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo eliminar valores de celda en excel?\" \/>\n<meta property=\"og:description\" content=\"La forma m\u00e1s r\u00e1pida de eliminar valores de celda es utilizar la tecla \u00abEliminar\u00bb del teclado. Los usuarios pueden eliminar completamente los valores ingresados en las celdas usando la tecla de m\u00e9todo abreviado de teclado \u00abEliminar\u00bb y dejar las celdas en blanco. O, a veces, los usuarios descubren que el valor ingresado en la celda [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/borrar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\" \/>\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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/borrar\/\",\"name\":\"\u00bfc\u00f3mo eliminar valores de celda en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\",\"datePublished\":\"2023-11-15T20:03:44+00:00\",\"dateModified\":\"2023-12-25T10:25:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/borrar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo eliminar valores de celda 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 eliminar valores de celda 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\/borrar\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo eliminar valores de celda en excel?","og_description":"La forma m\u00e1s r\u00e1pida de eliminar valores de celda es utilizar la tecla \u00abEliminar\u00bb del teclado. Los usuarios pueden eliminar completamente los valores ingresados en las celdas usando la tecla de m\u00e9todo abreviado de teclado \u00abEliminar\u00bb y dejar las celdas en blanco. O, a veces, los usuarios descubren que el valor ingresado en la celda [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/borrar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/borrar\/","url":"https:\/\/exceladvisor.org\/es\/borrar\/","name":"\u00bfc\u00f3mo eliminar valores de celda en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/borrar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/borrar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png","datePublished":"2023-11-15T20:03:44+00:00","dateModified":"2023-12-25T10:25:07+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/borrar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/borrar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/borrar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/borrar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo eliminar valores de celda 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\/122","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=122"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/122\/revisions"}],"predecessor-version":[{"id":1008,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/122\/revisions\/1008"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}