Format/Column/Autofit selection lost

  • Thread starter Thread starter Flemmo
  • Start date Start date
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?
 
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.)
 
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.
 
Back
Top