Contextures

Excel Double-Click Tips

Save time with these Excel double-click tips. Use these mouse shortcuts for quick formatting, naming, resizing, and more time-savers.

Format Painter

After you format one part of a worksheet, you can click on the Format Painter, then click on another location, to apply the same formatting.

If you have multiple locations where you want the same formatting:

  • Select the cells whose formatting you want to copy
  • Double-click on the Format Painter button, to "lock" it.
  • Then, click on another location, where you want to apply the same formatting.
  • Continue clicking on different locations, until all the formatting has been applied

When you're finished:

  • Press the Esc key on your keyboard

    OR

  • Click the Format Painter again, to "unlock" it.

Double-click Format Painter

Excel Ribbon

The Excel Ribbon uses a a bit of room at the top of the Excel window, and if you need extra space, you can temporarily hide the Ribbon commands.

To hide the Ribbon commands:

  • Double-click on the active tab of the Ribbon
  • Only the Ribbon tabs will be visible.

Point to the Fill Handle

To use the commands when they are hidden:

  • Click on any tab, to see its commands
  • Cick on the command that you want to use
  • NOTE: The commands will temporarily cover the formula bar and part of the worksheet

To unhide the Ribbon commands again:

  • Double-click on any tab on the Ribbon (but not the File button).

Show Ribbon commands again

Rows and Columns

To quickly adjust the row height or column width, use a double-click shortcut.

To autofit the row height for the tallest entry in each row

  • Select one or more rows
  • In the Row buttons at the left side of the sheet, point to the line at the bottom of one of the selected rows
  • Double-click to adjust the height of all the selected rows.

To autofit the column width for the widest entry in each column

  • Select one or more columns
  • In the column buttons at the top of the sheet, point to the line at the right side of one of the selected columns
  • Double-click to adjust the width of all the selected columns.

Adjust column widt

Sheet Names

Name your worksheets, so it's easy to find what you need in each workbook. Don't leave the names as Shet1, Sheets, etc.

To rename a sheet:

  • Double-click the sheet tab
  • Type a new name for the sheet (up to 31 characters).
  • Press the Enter key, to complete the name

Rename a worksheet

To quickly navigate through a worksheet, use a double-click shortcut.

  • Select a cell in the row or column where you want to navigate
  • Double-click on one of the cell' borders -- top, bottom, left or right

Double-click for navigation

Excel will select a cell in that row or column, moving in the direction that you clicked.

It stops at the cell just before the first blank cell.

Double-click for navigation

Close Workbook

Instead of using the X at the top right of an Excel workbook, use a double-click shortcut.

This saves time if your mouse pointer is closer to the left side of the workbook, and you're working with a big workbook window.

To quickly close a workbook:

  • Point to the top left corner of the workbook's window, just above the File tab..
    • NOTE: In Excel 2013 and earlier, there is an Excel logo in that corner. In Excel 2016, there is just a blank space.
  • Double-click in that corner, to close the workbook.
    • NOTE: If there are any unsaved changes in the workbook, Excel will prompt you to save.

Point to the top left corner

Excel Window

Instead of dragging the workbook's borders, to resize it, use a double-click shortcut to quickly change its size.

  • To maximize a normal-sized window, double-click in the Title Bar.
  • To restore a maximized window to its previous size, double-click the Title Bar again.

Double-click the Title Bar

Pivot Tables

If you're troubleshooting a pivot table, use this shortcut to see all the data that is summarized in one of its values.

  • Double-click any number in the pivot table Values section, to create a new sheet with all of the related data for that value.
  • To see all of the data, remove any filters on the pivot table, then double-click the Grand Total

Pivot Table Grand Total

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

More Tutorials

Fill Blank Cells

Convert Text to Numbers

Increase Numbers With Paste Special

Date Picker

 

 

 

Excel Data Entry Popup List

 

 

 

 

 

 

 

 

 

 

 

pivot power premium

 

 

 

 

 

Last updated: April 5, 2018 9:48 AM
Contextures RSS Feed