Format/Column/Autofit selection lost

F

Flemmo

In Excel 2002 I was trying to put the Format/Column/Autofit Selection option
onto the toolbar. In the Customize/Commands window I could not find this
command under the Format category (or any other). I then tried to drag the
option from the Format/column menu onto the toolbar which effectively
deleted the option from that menu. Any ideas?
 
D

Dave Peterson

If you hold the control down when you drag that menu item, you'll end up with
two copies.

I like to do it this way:
Tools|customize (just to show that dialog)
then
expand the menu and control copy the item to its new location.

You should be able to put a copy back to its original location using this
technique, too.

The original order is:

width
autofit selection
hide
unhide
standard width


If you've done enough damage <bg> to the toolbar, you can always reset it.

tools|customize|toolbars tab
select the worksheet menubar
click reset
(you'll have to redo any customizations to that menubar, though.)
 
B

bigwheel

Hi Flemmo

Is your question asking how to get the menu option back? If so, there is a
reset button on the Customize dialog which should restore the menu.
 
Top