10 Excel Mouse Tips Everyone Should Know

10 Time-Saving Excel Mouse Tips Everyone Should Know

By Marie McCooey

Although everyone loves keyboard shortcuts, Excel mouse tips can also help you save time.

Here are 10 of the most popular Excel mouse tips you’ll want to start using today.

1. Double click to autofit multiple columns widths and row heights

Select the row(s) to adjust
Excel Mouse Tip 1a

Select the column(s) to adjust

Excel Mouse Tip 1 b

2. Quickly copy formulas to multiple cells with the Fill Handle

Excel Mouse Tip 2

3. Edit cell entries instantly with double click

Excel Mouse Tip 3

4. Easily convert formulas to values

  1. Select a range of cells and use the right mouse button to click the border.
  2. Keep the right mouse button pressed, and drag one row to the right and drag back to the original position.
  3. Release the right mouse button and select ‘Copy here as values only’.

Excel Mouse Tip 4

5. Double click any cell border to jump in that direction to the last cell in the range

Excel Mouse Tip 5

6. Apply formatting to multiple cells with one quick double click

  1. Select the cell with the formatting to copy.
  2. Double-click the Format Painter.
  3. Apply the formatting to multiple cells without having to repeatedly click the Format Painter button.
  4. When the formatting is complete, press ESC to release the Format Painter.

Excel Mouse Tip 6

7. Use the Fill Handle to create series of numbers, dates, days of the week, and so much more

  1. Use the left mouse button to drag the Fill Handle to create a series.
  2. Right click and drag the Fill Handle to display the Fill menu options.

Excel Mouse Tip 7

8. Right click to display a list of all worksheets in a multi-sheet workbook

Excel Mouse Tip 8

9. Rename a worksheet with a quick double click

Excel Mouse Tip 9

10. Access a chart’s format options in no time

Double click the chart border to open the Chart Formatting pane.

Excel Mouse Tip 10