Top 16 Excel Double Click Mouse Tricks

Excel Double Click Mouse

Excel Double Click Mouse

Excel Double Click Mouse could be powerful tool for Excel users. It saves your time and it’s easier to use compare to other method. Therefore, I decided to share my top 16 Excel Double Click Mouse including Excel shortcuts.

#1. Skip the OK button

Save time by skipping extra step. For example when you are applying cell formats, double click on the required format to skip the OK button.
Skip the OK button

#2. Collapse / Expand Ribbon by Clicking on any Tab Names

To to get more space on screen and show more rows in your excel worksheet, double click on the active tab or use the shortcut [Ctrl]+[F1]. Collapse the Ribbon
You can also permanently expand hidden ribbon back if you double click on any tab names.

#3. Rename Sheet

Instead of following the long process of right clicking and renaming a worksheet, just double click it. This enables you to edit the name or use the keyboard shortcut [Alt]+[O][H][R].
Rename Sheet

#4. Lock the Format Painter ON

If you want to apply certain formats on a number of non-continuous rows/columns, lock the format painter.

    • Select the section with the correct format;
    • Excel Double Click Mouse the format painter;

format painter

  • Apply the format by clicking in all other sections many time as you want, until you unlock it, clicking the format painter once again or pressing [Esc].

#5. Auto-Fill formula down / Auto Fill Handle Copy a Pattern of Numbers or even Dates

Manual keying of data or formula is time consuming. To save time filling a column with a formula or data that follows a pattern use the Auto-fill feature.

    • In case of a formula, just fill in the first row and double click the right-side corner of that cell.

auto fill down

    • In case of a data following a pattern, like months shown below, type on first two rows then highlight the cells and double click on the right-side corner. Data can be text, numbers or dates. You can also use a shortcut [Ctrl]+[D] after you selected the cell you want to copy and cell or range below you want to paste to.

Auto fill

#6. Adjust selected Column(s) or Row(s) Width

A column or a row width can be so small such that the data is unreadable. To Auto fit the column/row, select it and click on the edge.

The same trick applies to a range of columns or rows. If you have multiple squeezed columns, there is no need to auto adjust one at a time. Select the range and click at the edge or use a shortcut [ALT]+[O][C][A].
adjast columns

#7. Jump Go to the first/Last Row/Column with Data

Save time spent on scrolling to the last or first row/column by doing the following.
Select the cell and click on the right border to move to the last column or bottom border to move to the last row. You can also use a shortcut [Ctrl]+(Arrow) to move up, down or sideways.
jump to edge

#8. Drill down into the detail, Pivot Table Data

To drill down a summary value in a pivot table, just double click it and excel will create a new worksheet and display the details. For example, to get the details for Qtr2 2015 below, double click on value.
Pivot Table Data
Then automatically generates addition worksheet shows related details records.

#9. Pivot Chart Drill Down

Double clicking on a Pivot Chart horizontal axis will activate the drill down functionality.

#10. Splitting worksheet

You can split a workbook into separate scroll-able panes for easy comparison using the Split feature in excel or simply by selecting the cell where to vertical and horizontal split and use shortcut [ALT]+[W][S]. You can also double click on grey line which you want to hide it.

#11. Maximise / minimise window

To maximise or minimise a window, double click on the top most part of the ribbon above the tabs or use a shortcut [windows]+[down]/[up].
maximise or minimise

#12. Tracing Precedent Cells

Double click in cell which there is a reference and jump to cells referenced cell. Before you have to changes default setting under the Advanced section of the Options window in Excel 2007. In Excel 2003, this option appears on the Edit tab of Excel’s Options window and is labelled Edit Directly in Cell. In either case, once you turn the option off, double-clicking a worksheet cell will highlight the precedent cells that a given formula refers to.

#13. Open Format Chart Area Options

To easily access chart formatting options, double click anywhere on the chart or click anywhere on the chart using shortcut [Ctrl]+[1].

#14. Place and Edit the Text in Shape

To place a text in a shape, double click the shape and type your text. To edit the text, double click the shape and then double click the text.

#15. Close Excel workbook

One of the favorites for some: Close a workbook quickly by double clicking the top most left part of a workbook or use shortcut [Alt]+[F4].
Close Excel

#16. Select and Edit Words in a Cell

Select the cell with the text, on the formula bar, double click the word to select it.

#16. Extra Bonus. Triple-click in MS Word

Automatically selects an entire paragraph in MS Word.

Which one is most useful/powerful Excel Double Click mouse for you? Do you know any other double click trick in Excel which I haven’t mentioned in this post? Please share your answer.

Reduce Excel file size without deleting data

Reduce Excel file size for Optimising Performance
reduce Excel file size

10 Top tips: How to reduce Excel file size without deleting data?

1) Save the file in right version as:

    • Excel Workbook (xlsx)

Save as new version instead of then older or

You can significantly reduce Excel size file compared to default version or

    • Zip the Excel file (zip).

2) Clear unused cells

    • Clear visible unused table, columns and formatted cells.

Select it and Clear All or select rows or columns and delete (Ctr+-)

    • Clear invisible content using method:

Ctr+G / Special… / blanks / Clear All
Note: CTR + End

3) Reduce graphics

    • Delete unused images/object

To find objects that are hidden, stacked, or behind text, click:
Home, Find & Select, Selection Pane…

    • Compressing Picture

Select image / Compress Picture / Minimise document size for sharing
Compressing Picture

    • Resizing

4) Reduce Condition Formatting

    • Select the entire worksheet

(Ctrl+A and you maybe requite use Ctrl+A again) or simple click Select All button

    • Home / Conditional Formatting / Manage Roles…

Select irrelevant roles and Delete Rule

5) Reduce on Data Validation

    • Select the entire worksheet as above
    • Data / Data Validation / Setting / Allow: Any value

6) Use manual calculation

Formulas / Calculation options / Manual

7) Use Pivot Tables and Excel Tables format and named Range

Note: How to Reduce the Size of Pivot Table Workbooks

8) Optimise formulas

    • Avoid using volatile function such as:
    TODAY, NOW, INDIRECT, RAND, RANDBETWEEN, CELL, OFFSET, INFO.
    • Replace VLOOKUP, HLOOKUP and LOOKUP function with INDEX & MATCH
    • Replace nested IF functions with any of below alternative:
    REPT, INDEX & MATCH, SUMIF(s) or Boolean logic
    • Check cells containing formulas and replace them with values where a formula is unnecessary or rarely used

Note: Advanced Excel Test

9) Reduce worksheets

Check if you have unused worksheets including hidden and delete them.

10) How to Reduce Excel file size Optimize using VBA

Request a quote

UK Salary Calculator Template Spreadsheet

UK Salary Calculator

UK Salary Calculator

In the United Kingdom on April 6 each year is the start of the new fiscal year. Therefore, for employees in the UK, I have prepared UK Salary Calculator spreadsheet. Based on the annual gross salary and works out each of its components: Personal Allowance, Taxable Income, Income Tax, National Insurance Contributions and Net Salary called Take Home Pay. In addition, I have calculated the equivalent information for different periods such as year, month, week and day. In the last option, we can define the number of hours in a day. Apart from the gross amount, and the amount of working daily hours, the spreadsheet includes the option of choosing the Tax Years from 2009-10 to 2017-18.

UK Salary calculator has been prepared for taxpayers born after 6th April 1948, who are not entitled to any special incentives, tax exemptions or special tax-free amount. This calculator calculates the mean values due to the different periods, but the actual net pay wage that the taxpayer will receive may differ from the calculations. This may be due, inter alia, to the fact that for various reasons the taxpayer receives an irregular salary in a tax year or receives remuneration from more than one source.

FREE spreadsheet download

Please feel free to download UK Salary Calculator template spreadsheet. It does not require any additional software or any registration. It is also free of adverts and VBA code. Just click on the button below to download the file.

Download Free

If you are interested in special access to advanced functions and methods used in this spreadsheet, including full access to other of my spreadsheets, please visit the shop, button below.

Download Free