What does double-clicking between any two rows or columns do to the cells?
|
Note: Columns and rows cannot overlap. For example, if you select values in Column C, and try to paste them into a row that overlaps Column C, Excel displays an error message. The destination area of a pasted column or row must be outside the original values.
Show
Keyboard shortcuts are great, but there are also hidden Excel double click features and shortcuts available for mouse users. Which means everyone, because we all use the mouse, even those hardcore keyboard shortcut fans. Watch the VideoDownload the Quick Reference Cheat Sheet [FREE]Enter your email address below to download the sample workbook. Get Workbook By submitting your email address you agree that we can email you our Excel newsletter. Please enter a valid email address. Download the Double Click Shortcuts PDF. More ShortcutsDownload our free PDF showing 239 Excel Keyboard Shortcuts. Double Click Shortcut 1 - RibbonWhen working in large spreadsheets you need all the space you can get. You can quickly hide and unhide the ribbon by double clicking the ribbon tabs:  Tip: If you have Microsoft 365 you can also switch to the new compact toolbar, also known as the Simplified Ribbon: This simplified ribbon displays the commands in a single line, which frees up space so you can see more spreadsheet. Double Click Shortcut 2 – Activate TabOpen the contextual format tab for shapes and images. When you first insert an image the contextual tab typically opens at the same time, but if you want to go back and edit that image or shape, a single left click doesn’t aways bring the contextual tab to the front, but a double click does: Double Click Shortcut 3 – Dialog BoxesNo need to click the OK button in dialog boxes (most of the time). Simply double click the radio button you want. Excel will effectively select it and click OK with a double click: Double Click Shortcut 4 – Selecting FormulasDouble click a cell to go into edit mode. Select cell references in formulas with a double click anywhere in the cell reference. It also works for the function name. And with a triple click you can select the whole formula: Double Click Shortcut 5 – Open PivotTable Dialog BoxesOpen PivotTable dialog boxes by double clicking column headers. For row label columns, position the mouse until the arrow appears, then double click. For value field headers, position the mouse inside the cell area, then double click: Double Click Shortcut 6 – Drill Down on PivotTablesDouble click grouped items to expand and collapse, or double click on a value cell to see the underlying transactions that make up the value. Tip: double click on the Grand Total to see all rows in the source data. Double Click Shortcut 7 - NavigatingNavigate by double clicking the edge of a cell to jump to the end of the range. Hold down SHIFT to select a range of cells: Double Click Shortcut 8 – Autofit Rows/ColumnsResize columns, rows, etc. by double clicking the line between each column/row. Or select all columns/rows, a range of columns/rows or the whole sheet and double click: Double Click Shortcut 9 – Copy Formulas DownNo need to CTRL+C and CTRL+V to copy and paste formulas down a column. Simply double click the bottom right corner of the cell containing the formula and it will copy it down the column as long as there is contiguous data in an adjacent column (left or right of the cell containing the formula): Double Click Shortcut 10 – Format PainterEnable multiple applications of the format painter by double clicking it. Then paste as many times as you like. Press ESC to clear the format painter: Which was your favourite double click shortcut? Or do you have one I missed? Please share them in the comments. What is the purpose of doubleDouble-clicking the Fill Handle causes the selected text, formula, or data to be copied downward, with different behaviors resulting depending on the contents of the cell.
What happens if you doubleWhat happens when you double-click a column border? The column width is adjusted to fit the text.
What is doubleTurns out, there is a trick to quickly move across your data through double clicks! Pick a cell you want to start on with. Double click on the edge of where you want to go to. For example, if we double click on the bottom edge of the cell, that means we will go downwards to the end of the data.
What happens when we doubleDouble-clicking sometimes creates a view that you can use without further modification. More often, it can provide a starting point, which you can then modify to get the ideal result. Double-clicking the Profit measure in the Data pane automatically adds that field to the view in an intelligent way.
|
