Home > Skills > Shortcuts > Double Click Excel Double-Click TipsSave time with these Excel double-click tips. Use these mouse shortcuts for quick formatting, naming, resizing, and more time-savers. |
Format PainterAfter 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:
When you're finished:
|
Excel RibbonThe 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:
To use the commands when they are hidden:
To unhide the Ribbon commands again:
|
Rows and ColumnsTo 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
To autofit the column width for the widest entry in each column
|
Sheet NamesName your worksheets, so it's easy to find what you need in each workbook. Don't leave the names as Sheet1, Sheets, etc. To rename a sheet:
|
NavigationTo quickly navigate through a worksheet, use a double-click shortcut.
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. |
Close WorkbookInstead 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:
|
Excel WindowInstead of dragging the workbook's borders, to resize it, use a double-click shortcut to quickly change its size.
|
Pivot TablesIf you're troubleshooting a pivot table, use this shortcut to see all the data that is summarized in one of its values.
|
Last updated: January 22, 2023 3:50 PM