If you read this blog with any regularity, you know that I am a huge fan of Keyboard Shortcuts.
That being the case, I am nonetheless a proponent of using
the mouse when it offers opportunities to augment your productivity. Double-Clicking with your mouse is
one such way to add speed and efficiency to your Excel work.
Here is an Updated
List of My Favorite Ways to Use Double-Click:
1. Adjust to Ideal Column
Widths – Select Multiple Columns and Double-Click on the separators; Works
for adjusting row heights too. Perfect Solution!
2. Auto-Fill a Series of
Cells with Data or Formulas - Select the formula in first cell,
Double-Click in the “handle” (small Black Square in
bottom-right-corner) and Bamm! This works for formulas, auto-fills (of numbers,
dates, etc) as long as the adjacent column has data.
3. Rename
a Worksheet Tab: Double-clicking the tab allows you to immediately edit the
name.
4. Insert a Split -
Double-Click just above scroll-bar to include a horizontal split; Works for a
vertical split too, by clicking on the little bar shape next to the right of
horizontal scroll-bar.
5. Edit
a Cell Formula: Double-click any cell to edit its contents in place (rather
than using the formula bar.)
6. Collapse Ribbon to Get More
Space – One of my favorites. Just Double-Click on ribbon Menu Names.
7. Lock
Format Painter – Save a lot of Time by Double-Clicking on the Format
Painter icon, making it Reusable. Great Solution!
8. Jump to Last Row / Column
in Table – Another gem: Just select a cell, and Double-Click on the
cell-border in the direction you want to go. Presto! You’re there.
9. Pivot Table Drill-Down:
Double-click on any data value within a pivot table to instantly create a new
worksheet which will show the Underlying Records that comprise that value.
Keyboard shortcuts a Totally Cool, but Double-clicking with
your mouse is also a powerful tool that can save you many hours of work. Try
any or all of the nine techniques and see if you do not agree that Double-Click
Rocks!
No comments:
Post a Comment