#MICROSOFT EXCEL SHORTCUT KEYS 2003 PLUS#

View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation. You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided 'as is' and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. Title photo by Stefan Steinbauer on Unsplash This article is an excerpt from Power Excel With MrExcel Although you can invoke Quick Access toolbar commands with the keyboard, it’s probably not worth your time and effort to memorize them. Every computer’s Quick Access toolbar will be different, and your Quick Access toolbar will be different if you customize. Gotcha: Although it makes sense to memorize keyboard shortcuts for the ribbon, it does not make sense to do so for the Quick Access toolbar. In Excel, you should be able to reach every command by using the keyboard.

Others might require using the arrow keys to select them.Ī few commands in Excel 2003 were difficult to reach with the keyboard shortcuts. Some items in that menu will have shortcut keys. In some cases, a keyboard shortcut leads to a new flyout menu or gallery. Some of the shortcuts don’t seem to have any rhyme or reason I have no idea why H is used for fill color Other keyboard shortcuts make sense in a historical context for example, Ctrl+V has meant Paste for 25 years, so it seems natural to use V for Paste. Some of these keyboard shortcuts are somewhat obvious for example, FS stands for Font Size and FF stands for Font Face. In the figure below, you can see that C is Copy, F+P is Format Painter, and F+O is the dialog launcher for the Clipboard group. Press the Alt key to display these tooltips.Īfter pressing Alt,H, Excel draws in new shortcut keys to access all of the commands on the Home tab.

#MICROSOFT EXCEL SHORTCUT KEYS 2003 PLUS#

You can type Alt plus one of these letters to switch to a particular ribbon tab. The Quick Access toolbar shortcuts are numbers 1 through 9, and then they start using two digits from 09 down to 01. In the figure below, you can see that the letters F, H, N, P, M, and A will allow you to access different tabs of the ribbon. Excel labels each tab of the ribbon with a different letter. You can use the Alt key to access the ribbon tabs. While the Quick Access toolbar shortcuts are subject to change, the ribbon shortcuts are predictable and worth learning. Strategy: The keyboard shortcuts for Excel allow you to access almost everything on the ribbon and Quick Access toolbar.

I would like to be able to use the keyboard to access some of the most-used Excel commands.

Use the Table of Contents on the right to navigate.Problem: I never learned the Excel 2003 menu shortcuts. Below are common used Microsoft Excel Shortcut Keys grouped for depending on usage – from Excel Workbook shortcuts to VBA Macro Excel Shortcuts.

Microsoft excel shortcut keys 2003