Column Navigator

A time saving add-in product for Microsoft Excel

Do you have these problems:

• Do you have lots of columns on your worksheets that make it difficult to find the data you want?
• Do you have trouble finding columns on your worksheets because of many of columns of data?
• Constantly getting or creating large worksheets with many columns and spending time searching for a particular column?

The Column Navigator makes it easy to find any column quickly and easily!
 

The Column Navigator for Microsoft Excel helps you move around on worksheets that have many columns. With just a click of the new "Columns" menu, a dialog appears that lists all the columns in your worksheet:

To go to any column, just click on the column description. To change worksheets, just click on the spin buttons on the upper left of the above dialog. The "Titles" button allows you to change the title rows to any rows you want. Multiple rows can be used as the column title rows. Once changed, the Column Navigator will remember the rows. 

Key features:

• If you wish to see your columns in sorted order, just click on the "Sort by title" checkbox.
• If you wish to see the column widths on all columns, just click the Options button and select the option to show column widths on all columns.
• If a column is hidden, an "H" appears to the left of the column title if widths are not displayed.  If widths are displayed, hidden columns have a zero for their width.
• The size of the dialog can be customize to any width or height for better viewing

The following picture shows the columns in sorted order and with column widths for each column.  The dialog has also been made larger: