{"id":64713,"date":"2026-04-20T12:13:03","date_gmt":"2026-04-20T11:13:03","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=64713"},"modified":"2026-04-20T12:13:03","modified_gmt":"2026-04-20T11:13:03","slug":"microsoft-excel-24-funciones-trucos-y-consejos-para-exprimir-al-maximo-la-app-de-hojas-de-calculo","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/microsoft-excel-24-funciones-trucos-y-consejos-para-exprimir-al-maximo-la-app-de-hojas-de-calculo\/","title":{"rendered":"Microsoft Excel: 24 funciones, trucos y consejos para exprimir al m\u00e1ximo la app de hojas de c\u00e1lculo"},"content":{"rendered":"<p>Microsoft Excel: 24 funciones, trucos y consejos para exprimir al m\u00e1ximo la app de hojas de c\u00e1lculo<br \/>\n<a href=\"https:\/\/www.xataka.com\/basics\/microsoft-excel-24-funciones-trucos-consejos-para-exprimir-al-maximo-app-hojas-calculo\" rel=\"nofollow\">https:\/\/www.xataka.com\/basics\/microsoft-excel-24-funciones-trucos-consejos-para-exprimir-al-maximo-app-hojas-calculo<\/a><\/p>\n<ol>\n<li>Seleccionar todo<\/li>\n<li>Usa el modo oscuro<\/li>\n<li>Resalta duplicados<\/li>\n<li>Ay\u00fadate de la inteligencia artificial<\/li>\n<li>Pasa datos de otras fuentes<\/li>\n<li>Inmoviliza una columna o fila<\/li>\n<li>Combina y divide celdas<\/li>\n<li>Bloquea celdas para que no se puedan editar<\/li>\n<li>Ordena las celdas alfab\u00e9ticamente<\/li>\n<li>Borde diagonal en una celda<\/li>\n<li>Cambia filas por columnas<\/li>\n<li>Pegado especial: pegar solo valores<\/li>\n<li>A\u00f1ade una lista desplegable<\/li>\n<li>Elimina columnas en blanco<\/li>\n<li>Automat\u00edzate con macros<\/li>\n<li>Protege un documento con contrase\u00f1a<\/li>\n<li>N\u00fameros que empiezan por cero<\/li>\n<li>Copia el formato de una celda<\/li>\n<li>Personaliza los atajos r\u00e1pidos<\/li>\n<li>A\u00f1ade atajos a palabras con la autocorrecci\u00f3n<\/li>\n<li>Usa las tablas din\u00e1micas<\/li>\n<li>Plantillas para todo<\/li>\n<li>Las f\u00f3rmulas m\u00e1s importantes de Excel<\/li>\n<li>Los mejores atajos de teclado<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel: 24 funciones, trucos y consejos para exprimir al m\u00e1ximo la app de hojas de c\u00e1lculo https:\/\/www.xataka.com\/basics\/microsoft-excel-24-funciones-trucos-consejos-para-exprimir-al-maximo-app-hojas-calculo Seleccionar todo Usa el modo oscuro Resalta duplicados Ay\u00fadate de la inteligencia artificial Pasa datos de otras fuentes Inmoviliza una columna o fila Combina y divide celdas Bloquea celdas para que no<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[375],"tags":[587],"class_list":["post-64713","post","type-post","status-publish","format-standard","hentry","category-excel-office-2010","tag-excel"],"publishpress_future_action":{"enabled":false,"date":"2026-04-30 16:25:10","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=64713"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64713\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=64713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=64713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=64713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}