The good news is that you’re not out of luck! Excel supports custom shortcuts, and we’ll show you how to create your own today. Get ready to take your shortcut-fu to the next level! A Note on Default Keyboard Shortcuts Unfortunately, it’s not all good news in the custom shortcut realm. While, Excel doesn’t offer the functionality to override standard shortcuts.
There are three main types of keyboard shortcuts:. Standard shortcuts, like CTRL + I for italics, which you cannot override in Excel. Alt shortcuts, where you press the ALT key to activate shortcuts to Ribbon items. For example, pressing ALT N T will select the Insert tab on the ribbon, followed by the Table option. Notably, you can use these types of shortcuts to You might know lots of keyboard shortcuts, but did you know you could get around Windows without your mouse?.
Excel is quite robust, meaning there is a lot of different tools that can be utilized within it, and therefore there are many skills Excel Resources Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. As a number of contributors have complained, this functionality has been withdrawn by Microsoft. I tried the universal apple preferences route to get my key stoke preferences (ie Apple preferences, Keyboard, shortcuts.(but this does not work. I think I will got back to Excel 2011 and give this defective version the flick.
Macro shortcuts, which are customized. We’ll discuss these in a bit. So, while you can’t manipulate any of the default shortcuts, you can still access quite a bit of functionality on the Ribbon and using macros; thus we’ll use those options to make custom shortcuts. Even though they’re not custom, you should still take some time to review Keyboard shortcuts can save you a lot of time!
Use these Microsoft Excel shortcuts to speed up working with spreadsheets on Windows and Mac., too. The Quick Access Toolbar The Quick Access Toolbar (QAT) is a super helpful strip of commands that always stays at the top of your screen.
By default it only includes a few commands such as save, undo, and redo (which can be removed since they already have accessible shortcuts), but you can The Quick Access Toolbar has been a part of MS Office since the 2003 version, but it has come to the forefront since the introduction of MS Office 2007 and more prominently with MS Office. The best part? Remember that Alt codes let you access That pesky Ribbon Menu. Ever since its introduction in Office 2007, I’ve been struggling to come to terms with it. I much preferred the Office 2000/2003 method of “hiding” tools that you don’t use often.
If you press ALT, you should notice the pop-up keys also appear near the QAT, giving you a one-step shortcut to any Excel command you wish! To get the bar Excel is a powerful tool, but it gets even better when you can customize it to your needs. Some of its best options are hidden inside and we draw back the curtain for you., click the drop-down arrow to the far right of the current icons and choose More commands to open the customization window. Here, you’ll see a list of available commands in the left box and your current QAT commands on the right. If you’d like, you can click any command on the right and click the Remove button to toss it, or use the arrow buttons to the right of the box to re-order the current items.
Once you’ve got that sorted, check out the left box to find commands you want to add. By default, the drop-down box above will only be showing the Popular Commands, but you can change it to Commands Not in the Ribbon if you want to avoid duplicating what’s already on the Ribbon. You can also show All Commands, but be warned there’s quite a list. Have a look through the list and select any functions that you want to have instant access to. The QAT allows for lots of commands, so don’t be afraid to pick several of your favorites or even Microsoft Office turns the Pareto Principle on its head: 80% of its users only use 20% of the features. Time to rediscover Microsoft Office features you never considered. We have compiled eight insanely useful productivity.
If you want to create groupings of similar functions, there’s an option called that lets you add a divider between icons. If you want to preserve your work, you can use the Import/Export button on the page to export your customizations to a file.
Once you’ve got everything in order, just click OK to return to Excel with your new and improved QAT. When you want to access one of its functions, press ALT followed by the number of the command to execute it right away. This is a lot faster and Microsoft Office 2013 has been available for some months now, and as is always the case with a new release there are a few quirks and annoyances that have led to users wondering if they. Than hunting through menus to find the right command! Macros Macros are an extremely useful, but often overlooked feature of Office that allow you to record a series of actions and automatically play them back. If you Excel is the spreadsheet gold standard.
If you are required to use Excel and yet have to familiarize yourself with it, these resources will quickly introduce you to the basics and more., for example, you could create a macro to automatically apply the formulas to specific cells. Macros are really just For those of you that would really love to be able to write your own application, but have never typed a single line of code before, I'm going to walk you through making your very. In the background to make Excel perform actions, but you don’t have to Maybe you've decided to pursue programming, whether for a career or just as a hobby. But maybe you're starting to feel overwhelmed. Not so great. Here's help to ease your journey.
To take advantage of macros. To get started with using them, enable the Developer Ribbon tab by going to File Options and choose Customize Ribbon on the left pane. On the right side, make sure Developer is checked, then press OK to return. Now we can record our first macro. Head to the Developer tab on the Ribbon and choose Record Macro. Give it a name to remember it by (it can’t have spaces) and then assign it a key that works for you.
The box shows CTRL + another key, but you can also add Shift in there by holding it while you select a key. Bear in mind that you can override Keyboard shortcuts can save you hours of time. Master the universal Windows keyboard shortcuts, keyboard tricks for specific programs, and a few other tips to speed up your work. Here, so if you make your macro run on CTRL + Z you won’t be able to use that to Undo. Under Store macro in: select Personal Macro Workbook.
This is a file that allows you to share macros between Excel workbooks, which is perfect for defining shortcuts. If we wanted to run macros on only one workbook, we would change this setting. Give your macro a brief description if you like, then click OK.
Important: Now, everything you do is being recorded by the macro. Any cell you select, font changes you apply, or characters you type are recorded by the macro. So you could, for example, make a macro that selects cell B3, types “test,” and formats it as bold.
Once you’ve performed exactly the action you want to record, select Stop Recording on the Developer tab to end the macro. After this, you can access it by choosing Macros from the left side of the Developer tab. This shows you a list of your macros, and you can press Edit to view the Visual Basic code for the macro — this is a good way to make sure you didn’t record any extra steps, even if you don’t fully Skilled programmers have been in high demand for years now, and it doesn’t look like that demand is about to go down anytime soon. But even if you don’t intend to make a living as. Once you’re satisfied, you can press the key combo you assigned at any time to run your macro.
Okay, I acknowledge I'm totally behind in this, but in!! Why am I just now discovering the amazingness of excel?
— Alyssa Spurling (@AlyssaSpurling) Bonus tip: You can combine macros and the QAT! Once you’ve saved a macro, open up the QAT menu again and change the Choose commands from box to Macros. Look for the name of the one you like, and you can add it to the QAT just like any other action! Thus, if you have trouble remembering your macro shortcut combos, you can set them to ALT and a number in the QAT! What you do with macros is up to you, but there are Imagine Excel was fun! Excel offers plenty of scope for projects that go beyond its intended use. The only limit is your imagination.
Here are the most creative examples of how people are using Excel. Think of anything you do in Excel on a regular basis that could be automated, and try making a macro for it. Automating these tedious tasks could save you hours, if you started using them regularly! What Are Your Top Shortcuts? Now you don’t have to waste time pecking out repetitive tasks or hunting through Excel menus to find that one function.
Shortcuts take a while to set up and will differ for everyone, but they’re essential for Excel efficiency. Macros really aren’t scary once you’ve done them, and there’s no reason not to use the QAT.
Shortcuts rule! Don’t let your shortcut reign now! Check out Hundreds of keyboard shortcuts are available in Office, but these are the most important ones you should know because they will save you a lot of time. What shortcuts have you created with these methods? I’m looking forward to hearing about your best macros in the comments!
Image Credit: by GooDween123 via Shutterstock Explore more about:,.
Sorry if I get transfixed by shortcuts in Excel 2011, but they are a vital part of how I use Excel and so much different than Excel for Windows, so anything that helps the learning curve is worth the effort. In looking for something else, I discovered you can change the keyboard shortcuts in Excel 2011, but the benefit for me is that every shortcut is listed by menu function.
Why that’s important is that in Excel 2011 they left the old menu with the new Ribbon, and this creates a common reference between the Windows and Mac versions of Excel. To see shortcuts in Excel 2011 go to the Tools menu and select Customize Keyboard. (Works in Excel 2008 too.) You’ll notice the Categories correspond to the Menu, and the right-hand pane shows the items within the selected category.
In the picture above I’ve selected the Edit menu and Undo is selected in the right-pane. The Current keys assigned to the Undo action are shown as Control+Z, F1, Command+Z. (Now I know why F1 doesn’t work for bringing up the Help system.) Checking for a Redo shortcut (in the picture below) shows none listed. I added a shortcut key for Redo by clicking in the box Press new shortcut key, which activated the Add button, then pressed the keyboard combination Control+Y, then clicked Add. Underneath the shortcut key box you see some text that shows the Currently assigned key. I tried to add another shortcut key, Command+Y, but the currently assigned key was Repeat. So I didn’t add that shortcut.
But that left me thinking, “Is Repeat and Redo the same?” (Something for another day.). Anyway, you can peruse the different menu items and look for shortcuts, or the lack of, in this Customize Keyboard dialog box.
I learned that to increase the font size one size larger, the shortcut Command+Shift+. Will do the trick and Command+Shift+, will take the font size down one level. Kind of handy when adjusting headings for a data table. To use a keyboard shortcut that’s the same as a default Mac OS X keyboard shortcut, you must first turn off that Mac OS X keyboard shortcut.
On the Apple menu, select System Preferences. Under Hardware, click Keyboard, then click the Keyboard Shortcuts tab. Find the keyboard shortcut you want to turn off, then clear the check box. 27 thoughts on “ Keyboard Shortcuts in Excel 2011”. Command+6 is redo (as well as repeat) in Excel 2011 for the MAC. In Excel 2010 and all previous versions in Windows, it’s F4 or Ctrl+y for redo/repeat. But the redo feature on the MAC is not as comprehensive as it is in Windows Excel.
In Windows Excel, for example, you can apply a color background or font color to a cell and then click in other cell(s) and press F4 or Ctrl+y and the action will be repeated. This doesn’t work in Excel for the MAC. Why, Microsoft? With certain actions, however, Command+6 on the MAC does repeat the previous action; try it with inserting/hiding rows/columns. Where is there documentation on what actions are covered by the repeat capability in Excel for the MAC?. tdodge Was very excited to find this page.
Thanks for the info. The biggest frustration I’m finding is for ‘insert/delete’ row. I understand how I can create a keyboard shortcut for these commands but I know ‘cmd + I’ is already taken. Have you switched it anyway or have you designated another letter for insert row? Just curious.
I think i’m leaning towards changing cmd + I to be insert row instead of italic because I never will use a keyboard shortcut for the latter. Also – do you know of ‘cmd + d’ is already taken as well?. Dennis Taylor I teach a lot of Excel – Windows and Excel 2011 on the MAC and am constantly trying to acquire (and remember) the various keystroke shortcuts in each version. Try these when using Excel for the MAC: After selecting a row or column, press control+i to insert a new row or column. After selecting a row or column, press control+d to delete current row or column Here are a few more: Press command+shift+x (MAC) or Ctrl+5 (Windows) to apply/remove strikethrough Press command+shift+z (MAC) or Alt+; (Windows) to select visible cells only. Post author The / key is an old Lotus 123 menu key that Microsoft Excel adapted as a “navigation key” to help smooth the transtion for Lotus 123 users, “back in the day.” Anyway, if this setting is checked, the / key would act like pressing the Alt key.
I’m not sure which version of Excel you are using, but you are looking to un-check the Transition Navigation Keys box. Here’s how you get there: In Excel 2003 choose Tools Options and click the Transition tab, then under Settings you’ll see the Microsoft Office Excel menu key and the default is /. Underneath this is the Transition Navigation Keys box, which should NOT be checked. In Excel 2007 choose the Office button Excel Options then click the Advanced tab and scroll down to the section for Lotus Compatibility. In Excel 2010 choose File Options then click the Advanced tab tab and scroll down to the section for Lotus Compatibility. Hope this helps.
Post author Alas, I’m not aware of any macro that would remap a Mac keyboard to have Windows shortcuts. The problem stems from the fundamental differences between Windows and Mac operating systems. Having said that, I have heard of people who use a Windows keyboard on a Mac. The keyboard has been remapped in some fashion. This was mentioned on the last episode of The Talk Show podcast. I’ve resigned myself to learn the Excel Mac keyboard shortcuts, which take time but can be done. The biggest thing is to change the Mac keyboard settings to recognize the Function keys with one press, instead of having to use the Fn key.
The next thing is to learn the common shortcuts on a Mac in Excel, like Control +U is really the F2 shortcut and Command + 6 replaces the F4 shortcut.