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 one of these links:
- Microsoft OneDrive: Keyboard shortcuts in Excel - PW1.xlsx
- 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 calculate WEEKNUMBER in Month / Quarter / Year with Excel? - Let's say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month ...Hace 1 hora
-
Gemini vs. ChatGPT: ¿Quién gana en la batalla de la IA? - El 13 de agosto de 2024, Google organizó un evento muy esperado donde presentó las últimas actualizaciones y avances en […] The post Gemini vs. ChatGPT: ...Hace 2 horas
-
See what's possible with Copilot in Excel - Kicking off a new weekly series that aims to explore new ways in which Copilot in Excel can help empower and inspire the way you work. This week, the fo...Hace 1 día
-
OBTENER LA DIFERENCIA EXACTA ENTRE HORAS, MINUTOS Y SEGUNDOS EN POWER APPS - Hola a todos: Algunas veces necesitamos obtener la diferencia exacta entre horas, minutos y segundos. Y en Power Apps también. No es algo sencillo obtene...Hace 3 días
-
The Engineer’s Quick Guide to Mastering XLOOKUP - The XLOOKUP function in Excel is a powerful tool for retrieving data, especially in engineering applications where precision and efficiency are critical. U...Hace 4 días
-
Debra’s Excel News–August 2024 - Quick filter, fill blank cells, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for p...Hace 1 semana
-
py_Conbeam – 4 - The last post in the current series compares results from the py_Conbeam function with beam analysis results from the Strand7 FEA software. There have been...Hace 1 semana
-
✨ Excel: Seleccionar y eliminar todos los objetos en una hoja de Excel rápido y a dos clic [VIDEO] - Hoy te enseñaré cómo seleccionar de manera sencilla y rápida todos los objetos de una hoja. y posteriormente eliminarlas de una vez. ¡Prepárate para domi...Hace 2 semanas
-
Anillos Olímpicos en Excel - 🔝*To translate this blog post to your language, select it in the top left Google box. * Anillos Olímpicos Explicación detallada de cómo crear los 5...Hace 2 semanas
-
7 Ways To Recover Unsaved Microsoft Excel Files - Are you wondering how to recover unsaved Excel files? Read this ultimate Excel tutorial to learn the tried and tested methods. It’s possible you forgot to ...Hace 1 mes
-
Regresos 11: Construcciones con un número y sus cifras - Hace un tiempo, publiqué en Twitter (@connumeros) esta identidad: 22622*2*2*6*2*2=2171712 En ella, un número capicúa (o palindrómico), multiplicado por s...Hace 1 mes
-
Facturando con Copilot Edge y Excel - Facturando con Copilot Edge y Excel es preciso, rápido y sencillo, a continuación te explico cómo. Introducción Facturando con Copilot Edge y Excel En el...Hace 2 meses
-
-
Minutos de juego y puntos. El Espanyol, sus finales de partido y mis enfados - Pienso que el Espanyol este 2024 se está dejando muchos puntos al final de los partidos. Cuando el ... Leer más » The post Minutos de juego y puntos. El ...Hace 4 meses
-
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 5 meses
-
MASTERCLASS Gratis – Gráfica de Gestión Proyectos en #EXCEL. - Aprende a crear un Gráfico de CURVA S, ideal para GESTIÓN DE PROYECTOS, porque te permite identificar como esta tu proyecto tanto en COSTOS como en TIEMP...Hace 6 meses
-
Interés compuesto con Excel - En la imagen, se presenta un esquema de las distintas funciones Excel para calcular el valor del dinero en el tiempo mediante la capitalización compuesta...Hace 6 meses
-
Demos cursos de Excel 2007, 2010, 2013, 2016, 365 - Puedes consultar las demostraciones de los siguientes capítulos de los cursos Excel. Demo cursos ExcelHace 7 meses
-
Atajos esenciales de Excel que todo profesional debe conocer - Manejar Excel con destreza puede ser el superpoder que no sabías que necesitabas. Agiliza tus tareas diarias y sorprende a tus colegas con estos atajos c...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 1 año
-
-
Navigating Outlook Favorites - I have these four favorites defined in Outlook: From the inbox, I could hit Shift+F6 to get into the Favorites area but sometimes I would end up in no man’...Hace 1 año
-
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 1 año
-
Progress on the Block Protocol - Since the 1990s, the web has been a publishing place for human-readable documents. Documents published on the web are in HTML. HTML has a little bit of… Re...Hace 1 año
-
Hello world! - [image: Hello world!] Welcome to WordPress. This is your first post. Edit or delete it, then start writing!Hace 1 año
-
Decálogo para realizar Trabajos de Fin de Grado (TFGs) y de Fin de Máster (TFMs) - 1.- Tanto TFGs como TFMs son un requisito para graduarse a la vez que una oportunidad para aprender. Así, el tiempo que se le dedica es muy variable. De...Hace 2 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 3 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 4 años
-
Dimensiones-Propiedades de perfiles de acero (IMCA) - Saludos compañeros, en esta oportunidad compartimos esta Planilla Excel que contiene las Propiedades y dimensiones de diferentes tipos de perfiles de acero...Hace 4 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 5 años
-
-
-
-
-
-
-
-
-
No Response to "Keyboard shortcuts in Excel"
Leave A Reply
Dime si te gusta lo que lees y, si no te gusta, dime por qué. Tengo habilitada la moderación de comentarios. Tu comentario se publicará pronto.