• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course โ€“ Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Hidden Excel Double Click Shortcuts

You are here: Home / Excel Shortcuts / Hidden Excel Double Click Shortcuts
double click shortcuts thumbnail
November 10, 2022 by Mynda Treacy

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 Video

Subscribe YouTube


Download the Quick Reference Cheat Sheet [FREE]

Enter your email address below to download the sample 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 Shortcuts

239 Excel Keyboard Shortcuts PDF

Download our free PDF showing 239 Excel Keyboard Shortcuts.


Double Click Shortcut 1 - Ribbon

When 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:

Excel Double click shortcut to hide an unhide the ribbon

Tip: If you have Microsoft 365 you can also switch to the new compact toolbar, also known as the Simplified Ribbon:

excel double click shortcuts ribbon example

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 Tab

Open 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:

Excel Double click shortcut to activate tab


Double Click Shortcut 3 โ€“ Dialog Boxes

No 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:

Excel Double click shortcut for dialog boxes


Double Click Shortcut 4 โ€“ Selecting Formulas

Double 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:

Excel Double click shortcut for selecting formulas


Double Click Shortcut 5 โ€“ Open PivotTable Dialog Boxes

Open 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:

Excel Double click shortcut to open pivot table dialog boxes


Double Click Shortcut 6 โ€“ Drill Down on PivotTables

Double 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.

Excel Double click shortcut to drill down on pivot tables


Double Click Shortcut 7 - Navigating

Navigate 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:

Excel Double click shortcut for navigating


Double Click Shortcut 8 โ€“ Autofit Rows/Columns

Resize 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:

Excel Double click shortcut to autofit rows and columns


Double Click Shortcut 9 โ€“ Copy Formulas Down

No 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):

Excel Double click shortcut to copy formulas down


Double Click Shortcut 10 โ€“ Format Painter

Enable 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:

Excel Double click shortcut for the format painter

Which was your favourite double click shortcut? Or do you have one I missed? Please share them in the comments.


double click shortcuts thumbnail

More Shortcuts Posts

dax editor keyboard shortcuts

DAX Editor Keyboard Shortcuts

Keyboard shortcuts for the DAX editor in Power BI. Learning DAX is hard enough. Make your life easier by using these keyboard shortcuts.
power query keyboard shortcuts

Power Query Keyboard Shortcuts to Save Time

Time saving keyboard shortcuts for Power Query that work in both Excel and Power BI. Download the free Shortcuts eBook

20 Pro Excel Keyboard Shortcuts

Excel Keyboard Shortcuts Used by Pros. These aren't your average CTRL+C type shortcuts. These are shortcuts that take the average user years to learn.
ALT codes for symbols and characters

ALT Codes for Symbols and Characters

How to use keyboard ALT codes to insert ASCII and Unicode symbols and characters in Excel. Download the free workbook for your reference.
essential excel shortcuts

23 Essential Excel Keyboard Shortcuts

Excel keyboard shortcuts I use all the time to help me work quickly and efficiently. How many do you use?
Excel Named Ranges

Excel Named Range Shortcut

This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.

More Excel Shortcuts Posts

double click shortcuts thumbnail

Hidden Excel Double Click Shortcuts

There are a load of hidden Excel double click shortcuts that will streamline the way you work in Excel and save loads of time
autosum

AutoSUM Shortcut in Excel

Learn multiple useful ways to use the AutoSUM shortcut in Excel. You'll never have to click on that AutoSUM icon in the Ribbon ever again.
Duplicate formula, text and objects

Shortcut for Duplicating Formulae, Text and Objects in Excel



Category: Excel ShortcutsTag: shortcuts
Previous Post:burn up burn down chartsExcel Project Management Burn Down and Burn Up Charts
Next Post:Dark Themed Excel Dashboardsdark theme dashboards

Reader Interactions

Comments

  1. Gary Knott

    November 12, 2022 at 4:23 am

    Some great tricks there, Mynda.

    My favourite double-click trick (in fact my favourite Excel trick of all) is to double click on a cell to jump to the first precedent. You may have to change options: File, Options, Advanced, Allow editing directly in cells option must be turned off.

    See my video at https://www.how2excel.com/en/simply-double-click-to-jump-to-cell-formula-precedent/

    Reply
    • Mynda Treacy

      November 12, 2022 at 3:10 pm

      Cheers, Gary!

      Reply
  2. Vijay

    November 11, 2022 at 3:07 am

    I was unknown with
    1. Double Click Shortcut 3 โ€“ Dialog Boxes
    2. Double Click Shortcut 7 โ€“ Navigating

    Thanks Mynda, for sharing…

    Reply
    • Mynda Treacy

      November 11, 2022 at 8:58 am

      Great to hear you picked up some new tips you can use, Vijay!

      Reply
  3. Andrei

    November 11, 2022 at 1:04 am

    Hi,

    – Double-click the sheet tab to rename a sheet;
    – Double-click the ‘+’ sign for adding new sheet to add a new sheet and renaming it at the same time;
    – (like in old Excel versions) Double-click the top-left corner of Excel window to close the active workbook;
    – Double-click on values from a pivot table to insert new sheet with data corresponding to the respective value.

    Reply
    • Mynda Treacy

      November 11, 2022 at 9:02 am

      Thanks for sharing, Andrei! I forgot about double clicking the sheet tab to rename, so thanks for sharing. I couldn’t get your second tip to work for me. It added a new sheet, but it didn’t go into edit mode for the sheet tab name. Your third tip closes all workbooks for me. Your last tip was covered in the video.

      Reply
  4. KM packaging

    November 10, 2022 at 11:02 pm

    THANK YOU

    Reply
    • Mynda Treacy

      November 11, 2022 at 9:02 am

      My pleasure ๐Ÿ™‚

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

launch excel macros course excel vba course

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 ยท My Online Training Hub ยท All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.