Traducir el blog

Keyboard shortcuts in Excel

Posted on marzo 06, 2023 by Excel Pedro Wave

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:

Keyboard shortcuts in Excel - Microsoft Support

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.


Cloud keyboard shortcuts searcher

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.


Download keyboard shortcuts searcher

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:

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.

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.

Mi lista de blogs