microsoft excel training london - how do i remove

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training london - How do I remove the scenarios menu from the toolbar?

microsoft excel training london - How do I remove the scenarios menu from the toolbar?

resolvedResolved · Low Priority · Version Standard

Matthew has attended:
Excel Advanced course

How do I remove the scenarios menu from the toolbar?

how do I remove the scenarios menu from the toolbar?

RE: how do I remove the scenarios menu from the toolbar?

Hi Matthew

2 ways :

1. REMOVE THE MENU
Right-click on the Toolbars menu, choose CUSTOMISE.
Left click on the menu you want to remove from the toolbar, and drag it to the Customise Dialog box. You will notice a RED X next to the cursor. When you release the mouse button, the menu will be removed.

2.RESET THE TOOLBAR
Right-click on the Toolbars menu, choose CUSTOMISE.
Select the TOOLBARS Tab
Select the Toolbar that the SCENARIOS MENU appears on
Click RESET.
If the SCENARIOS MENU appears on its own toolbar, you can hide it, by unticking the box.


That should sort it out.

Richard


 

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips


Server loaded in 0.11 secs.