Excel icon

Clean up your Worksheet

In Which macro shortcut keys do you use I posted the code I use to clean up my worksheets. Since then I've revised the code somewhat. The fact that my computer crashed and I lost my personal.xls workbook had absolutely nothing to do with this decision.

Continue Reading: Clean up your Worksheet »

Excel icon

Better Worksheets for Printing

In my line of work, presentation is everything. So I like to make sure my worksheets look professional without too much effort.

Continue Reading: Better Worksheets for Printing »

Excel icon

Convert Range to Numbers

Lately I've been working with a spreadsheet that imports data from a database application (Access). The numbers are formatted as text because some of them contain letters. So the whole field has to be formatted as text. :roll:

Then again, I'm not sure if the text formatting is because of that, or if it's just a function of being a foreign data source.

Continue Reading: Convert Range to Numbers »

Excel icon

Two sorting macros

When I'm doing a lot of sorting I use these two procedures to sort my used range. I've assigned them to toolbar buttons; just select the value you want to sort on and click the button to sort.

The first one sorts ascending; the second, descending.

Continue Reading: Two sorting macros »

Excel icon

UEFA Team Logos and Country Flags In Excel

Just in time for the Champions League quarterfinals, here's another frivolous spreadsheet that pulls images from UEFA.com into Excel.

Continue Reading: UEFA Team Logos and Country Flags In Excel »

Random Data Generator