Excel shortcuts

25 Excel Shortcuts for Right Clicking Like a Pro

If you're an Excel power user, you know that a lot of the time you spend in the program is spent right-clicking. Whether you're right-clicking to insert a new row or column, to delete cells, or to format your data, there's no doubt that this is one of the most commonly used actions in Excel. And while there are some great built-in shortcuts for right-clicking (like CTRL + SHIFT + RIGHT CLICK to insert a new column), there are even more shortcuts that you can create yourself using the right-click menu. Here are 25 of the best.

1. To insert a new row, column, or cell, just right-click on the row, column, or cell where you want to insert it and select "Insert."

2. To delete a row, column, or cell, right-click on it and select "Delete."

3. To format a cell or range of cells, right-click on it and select "Format Cells."

4. To apply conditional formatting, right-click on the cell or range of cells you want to format and select "Conditional Formatting."

5. To add a comment to a cell, right-click on it and select "Insert Comment."

6. To edit a comment, right-click on the cell with the comment and select "Edit Comment."

7. To delete a comment, right-click on the cell with the comment and select "Delete Comment."

8. To insert a hyperlink, right-click on the cell where you want to insert it and select "Hyperlink."

9. To edit a hyperlink, right-click on the cell with the hyperlink and select "Edit Hyperlink."

10. To remove a hyperlink, right-click on the cell with the hyperlink and select "Remove Hyperlink."

11. To insert a picture, right-click on the cell where you want to insert it and select "Insert Picture."

12. To edit a picture, right-click on the cell with the picture and select "Edit Picture."

13. To delete a picture, right-click on the cell with the picture and select "Delete Picture."

14. To add a trendline to a chart, right-click on the data series you want to add it to and select "Add Trendline."

15. To edit a trendline, right-click on the trendline and select "Edit Trendline."

16. To delete a trendline, right-click on the trendline and select "Delete Trendline."

17. To add a data label to a data point, right-click on the data point and select "Add Data Label."

18. To edit a data label, right-click on the data label and select "Edit Data Label."

19. To delete a data label, right-click on the data label and select "Delete Data Label."

20. To add a trendline to a 3D chart, right-click on the data series you want to add it to and select "Add Trendline."

21. To edit a trendline in a 3D chart, right-click on the trendline and select "Edit Trendline."

22. To delete a trendline from a 3D chart, right-click on the trendline and select "Delete Trendline."

23. To add a data label to a data point in a 3D chart, right-click on the data point and select "Add Data Label."

24. To edit a data label in a 3D chart, right-click on the data label and select "Edit Data Label."

25. To delete a data label from a 3D chart, right-click on the data label and select "Delete Data Label."

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.