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

The UK's most regular instructor-led training courses.
Training information: microsoft excel training london · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

How do I remove the scenarios menu from the toolbar?

Matthew has attended:
Excel Advanced course

by - delegate Matthew [2 posts] (2006 Nov 22 Wed, 09:14) Reply

how do I remove the scenarios menu from the toolbar?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	4	book now	£475	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	5	book now	£450	£485
2003/XP	2008 Sep 18 Thu + 19 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Sep 25 Thu + 26 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Oct 6 Mon + 7 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 46 Excel VBA course dates. Bookings currently available until 26th November 2009.

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

by - trainer Richard platinum contributer [774 posts] (2006 Nov 22 Wed, 10:36) Reply

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

· Advanced Excel Training - takes you to the next level
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Features and Functions for Accountants
· Microsoft Office and the Small Business: Part 1 Excel
· Microsoft Excel Training Course

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips