Learn

double click shapes and colors

Macro 42: Sort a Range on Double- Click

Macro 42: Sort a Range on Double- Click When you distribute your Excel reports to your customers, it’s often nice to add a few bells and whistles. One of the easier enhancements to apply is the ability to sort when a column header is double-clicked. Although this may sound complicated, it’s relatively easy with this […]

Macro 42: Sort a Range on Double- Click Read More »

Macro 29: Zooming In and Out of a Worksheet with Double-Click

Macro 29: Zooming In and Out of a Worksheet with Double-Click Some spreadsheets are huge. Sometimes, we are forced to shrink the font size down so that we can see a decent portion of the spreadsheet on the screen. If you find that you are constantly zooming in and out of a spreadsheet, alternating between

Macro 29: Zooming In and Out of a Worksheet with Double-Click Read More »

Share knowledge