Tom Urtis / Atlas Programming

Tom Urtis / Atlas Programming Expert consulting, training, project development for Microsoft Excel. Comprehensive skills testing wi

Atlas Programming Management is all about the business of Microsoft Office, particularly Excel. We provide a variety of services and support to business clients & individual Excel users at all skill levels. Our website is also an extensive resource offering expert information, tips and tools

Double-clicking any cell in a range of data to toggle-sort the range by ascending or descending order of that cell's col...
05/29/2026

Double-clicking any cell in a range of data to toggle-sort the range by ascending or descending order of that cell's column.

Formatting a comment shape's individual lines of text with a different color.
05/28/2026

Formatting a comment shape's individual lines of text with a different color.

Showing a vertical divider between ListBox fields without affecting the worksheet or source data range.
05/27/2026

Showing a vertical divider between ListBox fields without affecting the worksheet or source data range.

Bubble-sorting a ListBox at Initialization without touching the source data.
05/26/2026

Bubble-sorting a ListBox at Initialization without touching the source data.

05/25/2026
Tom’s Tutorials For Excel: Conditionally Formatting Locked and Unlocked Cells
05/13/2026

Tom’s Tutorials For Excel: Conditionally Formatting Locked and Unlocked Cells

There are times when your users will find it easier to enter data directly into worksheet cells, instead of a userform interface. You’ll want to protect all the cells containing formulas and static header labels, while allowing certain cells to be unprotected for users to input data.

Tom’s Tutorials For Excel: Toggling to Show or Hide Your Group and Outline Buttons
05/06/2026

Tom’s Tutorials For Excel: Toggling to Show or Hide Your Group and Outline Buttons

The VBA for turning off and turning back on again is this: ActiveWindow.DisplayOutline = False ActiveWindow.DisplayOutline = True

Tom’s Tutorials For Excel: Transposing a Dynamic List From Horizontal to Vertical
04/28/2026

Tom’s Tutorials For Excel: Transposing a Dynamic List From Horizontal to Vertical

I previously posted this example, of transposing a range by copying it, and selecting the Transpose method in the Paste Special dialog box.

Showing Conditional Formatting for dates that are equal to, greater than, and less than a specified date.
04/21/2026

Showing Conditional Formatting for dates that are equal to, greater than, and less than a specified date.

Tom’s Tutorials For Excel: Using VLOOKUP With MIN, MAX, and AVERAGE
04/13/2026

Tom’s Tutorials For Excel: Using VLOOKUP With MIN, MAX, and AVERAGE

You can nest a function as the lookup_value argument with VLOOKUP, to return an item relating to the lookup_value function. In the pictured example, MIN, MAX, and AVERAGE are nested to return the name of the salesperson associated with those functions.

Address

Lafayette, CA
94549

Telephone

+19253104170

Website

Alerts

Be the first to know and let us send you an email when Tom Urtis / Atlas Programming posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share