Using the right-click mouse button in Excel can significantly streamline your workflow by providing quick access to various commands and options. In this Excel tutorial, you will learn several right-click mouse tips.

Right-click to show worksheets list

At the bottom left corner of your Excel window, next to the sheet tabs, you will see small arrows (see the picture below).

Now, you can simply choose one sheet, click OK and go to it. This tip is useful when you work with the spreadsheet with plenty of sheets included. This way is much faster than scrolling them one-by-one.

Adding to Quick Access Toolbar

Right-click any ribbon’s button to add it to the Quick Access Toolbar or customize it.

This way you can also Customize Quick Access Toolbar, Show Quick Access Toolbar below the Ribbon, Customize the Ribbon and Collapse the Ribbon.

Moving cells

Select any cell. Right-click its border and drag & drop the cell somewhere else. Now secret menu appears. Here you can choose from several options such as Move, Copy, Link or Create Hyperlink.

Filling series

Select any cell. Move cursor to the right-bottom corner. You should see black cross here. Right-click cell and drag it down (or up/right/left). This way you can fill the series of cells in Excel.

There are also other options besides filling. You can Copy Cells, Linear Trend and Growth Trend as well.

These tips provide quick access to useful commands, simplify navigation, and streamline data manipulation tasks, making your Excel experience smoother and more effective.

Related posts:

How to Cut ✂️ Text in Excel How to Reduce Excel File Size? Save Excel as Pipe Delimited