Restore the Data menu in Excel 2003

D

Dale

I inadvertantly dragged the Data menu into a spreadsheet and it removed it
from the menus. How do I restore it?
 
G

Gord Dibben

Dale

Tools>Customize>Toolbars.

Select Worksheet Menu Bar and "Reset"

Alternate fix..........

Tools>Customize>Commands>Built-in Menus.

Scroll down to "Data" and drag it to the menu bar in appropriate spot.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

You can reset that whole toolbar by:

Tools|Customize|Toolbars tab
click on Worksheet Menu bar
and click rest

If you don't want to reset the whole toolbar, you can also try:
tools|Options|Commands tab
Scroll down to Built in Menus (in categories box).
Drag Data to its rightful home.
 
D

Dave Peterson

and click rest
should be:
and click reset

Dave said:
You can reset that whole toolbar by:

Tools|Customize|Toolbars tab
click on Worksheet Menu bar
and click rest

If you don't want to reset the whole toolbar, you can also try:
tools|Options|Commands tab
Scroll down to Built in Menus (in categories box).
Drag Data to its rightful home.
 
Top