Custom Shortcuts For Excel On Mac

For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse. This article itemizes the keyboard shortcuts for Excel for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac.

Best audio editing software. Everyone knows that not only improves your productivity but also increases your overall. However, not all actions on Office 2013 have default keyboard shortcuts, some of these common actions include, changing font color or size and strikethrough text. It would be fun to have shortcuts for these actions though especially when you have to do them over and over and over again. In this post, we’ll show you how to assign shortcuts to these actions.

This trick we are showing you works for almost all commands you can find on Office 2013, namely Word, PowerPoint and Excel, the more common Office products. Recommended Reading: Custom Keyboard Shortcuts For Word 2013 Out of the 3 Office products we’ll be featuring here, only Word has the option to use custom keyboard combinations to trigger an action. Keys that we suggest to use would be a combination of Ctrl, Shift and Alt followed by a letter. Here are some examples: Start Word 2013 and navigate to the Options section by clicking on File > Options. Then navigate to Customize Ribbon and you’ll find ‘Keyboard shortcuts’; click on the Customize button next to it. Let’s first explain the things you see on this new window that pops up.

Commands are the actions you normally do on Word, for example Bold and Italics. These commands are in Categories based on the tabs in Word, e.g. The ‘Home’ tab or ‘Page Layout tab. This arrangement means you’ll easily find the command you want to customize as a keyboard shortcut. We’ll now demonstrate how to add a keyboard shortcut to the Strikethrough command on Word.

You’ll notice there is no shortcut key for Strikethrough — the ‘Current keys’ box is empty. Click on the ‘ Press new shortcut key‘ box and personalize a keyboard combination shortcut.

In this case, we used Alt + S. You can see that the combination Alt + S is not taken because it’s unassigned.

This is important as you do not want to double assign a combination. After that click on Assign. You can see all the assigned shortcuts you have for each command in the ‘Current keys’ box. If it is empty that means you have yet to assign a shortcut to the command. Click Close when you’re done. Now whenever you highlight text with your mouse, you can press Alt + S to Strikethrough it. Again, this is not just limited to Strikethrough but any command you set with a keyboard shortcut combination.

Custom Keyboard Shortcuts For PowerPoint & Excel 2013 There are some limitations creating shortcuts on PowerPoint and Excel as you don’t get as much flexibility compared to Word. However, adding keyboard shortcuts is simpler for both PowerPoint and Excel. Let’s use the example of the AutoSum button. When you need the values of certain fields added up together, you use the AutoSum function. It’s handy to have a keyboard shortcut assigned to that if you are doing your bookkeeping, for instance.