Excel shortcuts

The Best Right Click Excel Shortcuts That You Need to Know

If you're an Excel user, you know that there are a ton of different shortcuts that you can use in order to make your life a whole lot easier. And while some of these shortcuts are more well-known than others, there's one in particular that tends to be overlooked by a lot of users - the right click shortcut. That's right, you can actually use your right mouse button to quickly access a number of different features and options in Excel, and in this article, we're going to show you some of the best right click Excel shortcuts that you need to know.

So, without further ado, let's get started.

1. Insert a hyperlink

One of the quickest and easiest ways to insert a hyperlink into an Excel cell is to use the right click shortcut. Simply right click on the cell where you want to insert the hyperlink, then select 'Hyperlink' from the menu that appears. From there, you'll be able to enter the URL, display text, and even choose whether or not the link will open in a new window.

2. Create a new sheet

If you need to quickly create a new sheet in your workbook, simply right click on any existing sheet tab and select 'Insert' from the menu that appears. From there, you can choose to insert a new sheet either before or after the selected sheet.

3. Duplicate a sheet

If you need to duplicate an existing sheet in your workbook, simply right click on the sheet tab and select 'Duplicate' from the menu that appears. You can then choose to rename the duplicated sheet if you'd like.

4. Delete a sheet

If you need to delete an existing sheet from your workbook, simply right click on the sheet tab and select 'Delete' from the menu that appears. Keep in mind that you can only delete sheets that are not currently active, so if you need to delete the active sheet, you'll first need to activate another sheet.

5. Rename a sheet

If you need to rename an existing sheet in your workbook, simply right click on the sheet tab and select 'Rename' from the menu that appears. From there, simply type in the new name for the sheet and hit Enter.

6. Move or copy a sheet

If you need to move or copy an existing sheet to another location in your workbook, simply right click on the sheet tab and select 'Move or Copy' from the menu that appears. From there, you can choose to move or copy the sheet, as well as the location where you want to move or copy it to.

7. Change the tab color

If you want to change the color of a sheet tab, simply right click on the tab and select 'Tab Color' from the menu that appears. From there, you can choose from a variety of different colors, or you can even create a custom color by clicking 'More Colors'.

8. Hide a sheet

If you need to hide an existing sheet in your workbook, simply right click on the sheet tab and select 'Hide' from the menu that appears. Hidden sheets are not visible in the workbook, but they can still be accessed by using the right click shortcut.

9. Group sheets

If you want to group sheets together, simply right click on any sheet tab and select 'Group' from the menu that appears. From there, you can choose to group the sheets by position or by selection. Position grouping will group the sheets based on their position in the workbook, while selection grouping will group the sheets that you have selected.

10. Ungroup sheets

If you need to ungroup sheets that are currently grouped together, simply right click on any sheet tab and select 'Ungroup' from the menu that appears. This will ungroup all of the sheets in the workbook, regardless of how they were originally grouped.

11. Format cells

If you need to quickly format cells in Excel, simply right click on the cell or cells that you want to format and select 'Format Cells' from the menu that appears. From there, you'll be able to choose from a variety of different formatting options, including number format, alignment, font, border, and fill.

12. Insert a comment

If you want to insert a comment into a cell, simply right click on the cell and select 'Insert Comment' from the menu that appears. From there, you can type in your comment and even format it using the options that are available.

13. Edit a comment

If you need to edit an existing comment, simply right click on the cell that contains the comment and select 'Edit Comment' from the menu that appears. From there, you can make the changes that you need to the comment.

14. Delete a comment

If you need to delete a comment, simply right click on the cell that contains the comment and select 'Delete Comment' from the menu that appears. This will delete the comment from the cell, but it will not delete the cell itself.

15. Insert a hyperlink

If you want to quickly insert a hyperlink into a cell, simply right click on the cell and select 'Hyperlink' from the menu that appears. From there, you can enter the URL, display text, and even choose whether or not the link will open in a new window.

16. Insert a picture

If you need to insert a picture into your workbook, simply right click on the cell where you want to insert the picture and select 'Insert Picture' from the menu that appears. From there, you can choose the picture that you want to insert, as well as the insertion options.

17. Insert a shape

If you want to insert a shape into your workbook, simply right click on the cell where you want to insert the shape and select 'Insert Shape' from the menu that appears. From there, you can choose the shape that you want to insert, as well as the insertion options.

18. Insert a chart

If you need to insert a chart into your workbook, simply right click on the cell where you want to insert the chart and select 'Insert Chart' from the menu that appears. From there, you can choose the type of chart that you want to insert, as well as the data that you want to include in the chart.

19. Insert a text box

If you want to insert a text box into your workbook, simply right click on the cell where you want to insert the text box and select 'Insert Text Box' from the menu that appears. From there, you can choose the size and position of the text box, as well as the text that you want to include in it.

20. Insert an object

If you need to insert an object into your workbook, simply right click on the cell where you want to insert the object and select 'Insert Object' from the menu that appears. From there, you can choose the object that you want to insert, as well as the insertion options.

21. Format cells

If you want to quickly format cells in Excel, simply right click on the cell or cells that you want to format and select 'Format Cells' from the menu that appears. From there, you'll be able to choose from a variety of different formatting options, including number format, alignment, font, border, and fill.

22. Insert a function

If you need to insert a function into a cell, simply right click on the cell and select 'Insert Function' from the menu that appears. From there, you can choose the function that you want to insert, as well as the arguments that you want to use for it.

23. Insert a symbol

If you want to insert a symbol into a cell, simply right click on the cell and select 'Insert Symbol' from the menu that appears. From there, you can choose the symbol that you want to insert, as well as the font that you want to use for it.

24. Insert a date

If you need to insert a date into a cell, simply right click on the cell and select 'Insert Date' from the menu that appears. From there, you can choose the date that you want to insert, as well as the format that you want to use for it.

25. Insert a time

If you need to insert a time into a cell, simply right click on the cell and select 'Insert Time' from the menu that appears. From there, you can choose the time that you want to insert, as well as the format that you want to use for it.

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.