Sortng Custom Views

T

TONYC

I have been saving filtered criteria using 'custom views', icon on th
toolbar, however, as this list grows, I would like to sort the assigne
names in alphabetical order within the custom views box.

Is this possible?

Ton
 
D

Debra Dalgleish

Like other dropdown lists in Excel, you can't modify the contents of the
Custom Views list.

Instead of using the Custom View list, you could move the Custom Views
command to one of your toolbars. Then, click on it to open the Custom
Views dialog box, where the views are listed alphabetically --

Choose Tools>Customize
Click on the View menu in Excel's menu bar
Drag the Custom Views command to one of your toolbars
(or hold the Ctrl key and drag a copy of the command)
Close the Customize dialog box.
 
Top