Double+Click+Tricks!

Double Click Tricks!

Often learning simple things like keyboard shortcuts can be a huge productivity boost when working in Excel since it allows you to complete work faster. Therefore, in this page you will learn 7 very cool and effective double click tricks that may be used in Excel!

1.Double Click on the Office Button to Close Excel. Doing this will display “do you want to save…” dialog if the workbook is not saved.

2. Adjust column widths by selecting multiple columns and double clicking on the separators. You can use the same trick to adjust row heights too.

3.Double-click in the corner, just above scroll-bar to include a split. You can also create a vertical split by clicking on the little bar shape next to horizontal scroll-bar near bottom right corner of the excel window. (If you are wondering where the split would be created, it will be created at selected cell’s row (or column).

4.Double click on ribbon menu names to collapse ribbon to get more space.

5.Auto-fill a series of cells with data or formulas by just double clicking. Just select what you want copied in a cell, double click in the bottom right corner and see the magic. The trick works for formulas and auto-fills as long as the adjacent column has data.

6.Jump to last row / column in table with double-click. Just select any cell in the table and double click on the cell-border in the direction you want to go.

7.Lock a particular feature and reuse them with double-click. You can lock any repeatable feature (like format painter, drawing connectors, shapes etc.) by just double clicking on the icon This can save you a ton of time when you need to repeat same action several times.

So, next time you are working in Excel I hope you try some of these tricks out yourself and find them to be just as useful as I do!