Traducir el blog
Keyboard shortcuts in Excel
If you know and use all of the keyboard shortcuts in Excel, you're sure to that make your life more productive, read no further.
Read on for more keyboard shortcuts in Excel if you don't like to learn from the lists that are published on thousands of Excel websites, because you cannot find the shortcut you are looking for or because it is not easy to find it on those websites, not even on the official Microsoft website:
Keep reading below and you'll find any of the keyboard shortcuts in Excel.
With my method you can search for any key combination using a drop-down list of keyboard shortcuts, or by searching for any word or key entered in cell B3.
ATTENTION: In that animated image is searched for: +F9, with a plus sign before it. For this, the orthographic sign of apostrophe (') must be introduced before the sign plus (+), so it isn't interpreted as a formula. For example: '+F9
The same happens if you start looking for the minus sign (-) or for the equal sign (=).
Using the drop-down menu for cell C2, the system is selected:
- Android
- iOS
- macOS
- Web
- Windows
In cell B2 there is a hyperlink to the Microsoft page with the keyboard shortcuts in Excel for the chosen system.
It is interesting to note that Excel for the Web has different keyboard shortcuts than Excel for desktop.
With this keyboard shortcuts search engine it will be easy to find the combination of keys that you need at all times, for keyboards in English and for any operating system with Excel, and even for Excel for the Web. And all, without leaving this page!
To adjust the zoom of this shortcuts searcher:
- On a mobile or cellphone, use two fingers on the screen, as you do to expand or reduce a photo.
- On the PC, place the cursor inside the browser and press the key <Control> turning the wheel of the mouse.
IMPORTANT: I have included some Undocumented keyboard shortcuts for Windows and for Excel for the Web, which are not found on the official Microsoft website discussed at the beginning of this article. Missing include undocumented methods of the other systems.
This search engine cannot be updated in the cloud, as it contains connections from external data that is not supported by Excel for the Web.
If tried it will give a WARNING: THE DATA COULD NOT BE UPDATED. Power Query queries in Excel for the Web cannot be updated on workbooks saved to a location on the third party cloud.
Although what really happens in this case is that the update of the queries loaded into the data model is not yet supported in Excel embedded in websites.
If Microsoft modifies or adds any key combination on the official website with the Keyboard shortcuts in Excel, you'll have to download version 1.2 from this link:
- Sites Google Drive: Keyboard shortcuts in Excel - PW1.xlsx
Open the file and press the button: Enable editing when it appears the PROTECTED VIEW notice.
Press the button: Enable content when the WARNING appears SECURITY External data connections have been disabled
To update the keyboard shortcuts of the 43 queries with Power Query, you must select on the ribbon: Refresh All or the key combination: Control+Alt+F5
The file has the 'Keyboard Shortcuts' sheet protected without a password, so that users don't trash the formulas. The book is also protected without a password, to protect its structure.
There are 45 hidden sheets, 43 of them with the results of the queries with Power Query to the official Microsoft commented website at the beginning of this article, and 2 of them to carry out the search, so I encourage you to that you study each of the sheets, gut their formulas and analyze the queries, if you want to improve your Excel skills.
Mi lista de blogs
-
How to Reverse Numbers in Excel - Do you need to reverse a number in your report or dashboard? This blog post cover 8 advanced methods to reverse the number in an Excel spreadsheet. A word,...Hace 3 horas
-
Colección de Excel insertados en mi blog - 🔝*To translate this blog post to your language, select it in the top left Google box. * ¡COLECCIONA EXCEL! El mes de septiembre es el mes por anton...Hace 8 horas
-
Text from pictures in Excel - Excel recently added the ability to extract text from an image, either on the clipboard or from a selected file. To try this out I used a screenshot of a t...Hace 3 días
-
7 Casos Reales con SI + Y + O en Excel — Funciones Condicionales - En el trabajo siempre estamos decidiendo: ¿aprobado o no?, ¿envío gratis o con costo?, ¿en riesgo u OK?En Excel, esas […] The post 7 Casos Reales con SI ...Hace 3 días
-
Fórmulas REGEX en EXCEL - Descubre REGEX en EXCEL en este post y practica con ejemplos. Las expresiones regulares (abreviado RE GEX, Regular Expressions) es una herramienta para b...Hace 4 días
-
CREAR FLUJO EN POWER AUTOMATE PARA ENVIAR RECORDATORIO DE CUMPLEAÑOS - Hola a todos! Ya que me lo habéis pedido, os mostraré con detalle el flujo que construí con Alicia, mi hija, para que que nos … La entrada CREAR FLUJO E...Hace 3 semanas
-
Who is my boss’s boss? [Data Analytics Challenge – 001] - Let’s try something different. I will share a data analytics challenge here. Post your solutions in the comments. Our first challenge involves Employee D...Hace 4 semanas
-
How to Get Started With Excel FILTER Function - In the video below, I show how to get started with the Excel FILTER function, which is available in Office 365. You can enter a formula in one cell, and th...Hace 5 semanas
-
Todo lo que debes saber sobre la función EVALUAR en Excel - Antes de empezar con este tema, te lo digo claro: No te recomiendo que uses la función EVALUAR en tus archivos de Excel. Y no… The post Todo lo que debes...Hace 5 semanas
-
🛠️ Error Formula.Firewall en Power Query: ¿Qué es y cómo solucionarlo? - Power Query es una herramienta poderosa para transformar y combinar datos en Excel o Power BI. Sin embargo, en algunos escenarios comunes, puedes encontrar...Hace 1 mes
-
Regresos 15 - Generaciones con cifras y potencias - En una entrada antigua de este blog se invitaba a buscar igualdades similares a la siguiente: 882+332=8833 En aquella ocasión se dio más protagonismo a ...Hace 2 meses
-
Cómo hacer gráficos en Excel - Excel es una de las herramientas más potentes y versátiles para el análisis y la presentación de datos. Los gráficos en Excel no solo ayudan a visualizar...Hace 5 meses
-
Fin - Llevo tiempo pensando esta entrada y no sé que decir. Analisis y Decisión nació en 2008 y no ... Leer más »Hace 7 meses
-
Análisis DAFO (FODA, DOFA) las decisiones con Excel - Para conocer la situación de una empresa, proyecto o persona, recurrimos al análisis DAFO (FODA, DOFA) en la toma de decisiones con Excel. El los años sese...Hace 9 meses
-
Color, Conditions, and Copilot: How to save time using conditional formatting with Copilot in Excel - Hi everyone, this is part 11 in a series of posts to show you some of the things that are possible to do with Copilot in Excel. *What is conditional f...Hace 10 meses
-
How To Predict Bearing Life With Excel - When you work in mechanical engineering, understanding the reliability and performance of bearings under various conditions is crucial. Bearings are the co...Hace 1 año
-
-
TikTok’s search evolution - 2 in 5 Americans use TikTok as a search engine. Nearly 1 in 10 Gen Zers are more likely to rely on TikTok than Google as a search engine. More than half of...Hace 1 año
-
Unblocking and Enabling Macros - When Windows detects that a file has come from a computer other than the one you're using, it marks the file as coming from the web, and blocks the file....Hace 2 años
-
Office Scripts: Trabajando con Tablas - [image: Office Scripts: Trabajando con Tablas] Me he dado cuenta que últimamente solo escribo de lenguaje M (es mi pequeño vicio)... pero hay que liberar l...Hace 2 años
-
Hello world! - [image: Hello world!] Welcome to WordPress. This is your first post. Edit or delete it, then start writing!Hace 2 años
-
La importancia de saber mecanografía en 2022 - [image: Resultado de imagen de mecanografía viñeta escribiendo a máquina] Según la RAE, la mecanografía es el arte de escribir a máquina. Hace unos cuantos...Hace 3 años
-
London Excel Meetup Workbooks - The workbooks used in my presentation on “Analytical and Interactive Dashboards in Excel” at the London Excel Meetup, September 3, 2020Hace 5 años
-
Cálculo de jornada que termina al día siguiente (Power Query) y despedida - [image: Cálculo de jornada que termina al día siguiente (Power Query) y despedida] Este blog se ha ocupado de cálculos de tiempo con bastante intensidad, c...Hace 5 años
-
Agenda Perpetua Excel Calendario Perpetuo - Saludos a los ingenieros y a todos los que forman parte de nuestra comunidad de planillas Excel para ingeniería civil, ya se vienen las fiestas navideñas y...Hace 5 años
-
International Keyboard Shortcut Day 2019 - The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient...Hace 5 años
-
Welcome, Prashanth! - Last March, I shared that we were starting to look for a new CEO for Stack Overflow. We were looking for that rare combination of someone who… Read more "W...Hace 5 años
-
Visualize parts and whole - combine clustered column and stacked column charts - *Inga: Disa what?* *Igor: -ppeared.* by The FrankensTeam ------------------------------ Really it was 3 years ago we posted our last article? *Freddy: Th...Hace 6 años
-
Salvador Sostres, analfabeto profesional - Los nuevos tiempos traen nuevas profesiones. Internet, además, ha revolucionado el mundo del periodismo y la palabra escrita. Adaptarse o morir, ese es el ...Hace 7 años
-
Planificación de compras - Realizar una lista con los productos que necesitamos y que formarán parte de nuestra cesta de la compra nos ayuda a *encontrar la combinación de bienes p...Hace 13 años
-
-
-
-
-
-
-
-
-
No Response to "Keyboard shortcuts in Excel"
Leave A Reply
Comenta este artículo, critícalo o avisa si detectas algún error que haya que corregir.