resident? Don’t worry.If you work with data in Microsoft Excel, you know how important it is to be able to insert rows quickly and efficiently. or iPhone support, repair, training… or just want some questions answered? Call me at 31.

Live in Los Angeles County and need Mac, iPad. Have a good week… This tip should shave hours off your day 🙂 Your new shortcut will appear in the Current Keys box.Ĭongratulations, you now know how to create keystroke shortcuts in Excel. It’s best if you create a keystroke shortcut, and the message says – Currently assigned to: Unassigned.If you choose to ignore that message click Add.

If you choose a keystroke shortcut that is already in use, a message will appear below the input box – Currently assigned to: ABC.Now, press the keys that you want to use as a shortcut for this command.After selecting the command, move the cursor to the box labelled Press New Shortcut Key.

I locate Paste Special… Values, by selecting Edit from the Categories list and Paste Special from the Commands list.

The Current Key box may show that a shortcut already exists.

Locate the Command you want to customize using the Categories and Command lists.

A dialog box opens showing Menu Bar Categories, Commands in each Category, and the Current Keys or Current Keystroke Shortcut.

Three steps too many if you use this command every day.

Choose Values from the dialog box and click OK.

To use the Menu Bar to access this command you need to copy a cell, then: When you copy a cell in Excel, you can paste it in a number of different ways you can paste the formula, the value, the formatting, the comments, etc., In this example, I’m going to make a shortcut for the command Paste Special… Values. If you use a command regularly and it has no keystroke shortcut… you can make your own. In the Menu Bar, you’ll find most commands have a keystroke shortcut shown in symbols.

Microsoft Excel for Mac 2011 has hundreds of command options.

Excel shortcuts on a mac