Tags: dragged, excel, inadvertantly, menu, menus, microsoft, msdn, restore, software, spreadsheet

Restore the Data menu in Excel 2003

On Microsoft » Microsoft Excel

1,771 words with 3 Comments; publish: Thu, 22 May 2008 18:42:00 GMT; (30693.75, « »)

I inadvertantly dragged the Data menu into a spreadsheet and it removed it

from the menus. How do I restore it?

All Comments

Leave a comment...

  • 3 Comments
    • 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.

      Dale wrote:

      > I inadvertantly dragged the Data menu into a spreadsheet and it removed it

      > from the menus. How do I restore it?

      --

      Dave Peterson

      #1; Thu, 22 May 2008 18:43:00 GMT
    • 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

      On Wed, 19 Apr 2006 11:56:01 -0700, Dale <Dale.excel.todaysummary.com.discussions.microsoft.com> wrote:

      >I inadvertantly dragged the Data menu into a spreadsheet and it removed it

      >from the menus. How do I restore it?

      #2; Thu, 22 May 2008 18:44:00 GMT
    • and click rest

      should be:

      and click reset

      Dave Peterson wrote:

      > 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.

      > Dale wrote:

      > >

      > > I inadvertantly dragged the Data menu into a spreadsheet and it removed it

      > > from the menus. How do I restore it?

      > --

      > Dave Peterson

      --

      Dave Peterson

      #3; Thu, 22 May 2008 18:45:00 GMT