Excel shortcuts

How to create a right-click shortcut in Excel

If you work with Microsoft Excel a lot, you may find yourself using the same commands over and over again. For example, you may always right-click on a cell to insert a comment, or to format the cell. Instead of right-clicking each time, you can create a right-click shortcut. Here's how:

  1. Open Microsoft Excel.
  2. Click on the 'File' tab in the top left-hand corner.
  3. Click on 'Options' in the bottom left-hand corner.
  4. Click on 'Customize Ribbon' in the 'Excel Options' dialogue box.
  5. Click on the 'Customize' button next to 'Keyboard shortcuts'.
  6. In the 'Customize Keyboard' dialogue box, click on the 'Customize' button next to 'Current keys'.
  7. In the 'Press new shortcut key' field, type in the shortcut you want to use. For example, you could use 'Ctrl+Shift+C'.
  8. In the 'Replace' field, type in the command you want to use the shortcut for. For example, you could type 'InsertComment'.
  9. Click on the 'Assign' button.
  10. Click on the 'Close' button.
  11. Click on the 'OK' button.

Now, every time you use your new shortcut, the 'InsertComment' command will be executed. You can use this method to create shortcuts for any Excel command.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.