Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 Scenario toggling

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel 2007 Scenario toggling

Resolved · Medium Priority · Version 2007

Reply Wed 1 Jun 2011, 16:24Delegate Simon said...

Simon has attended:
Excel Advanced course

Excel 2007 Scenario toggling

Is it possible to set up an Excel cell, as opposed to a menu dropdown, to toggle on and off Scenarios?

For upcoming training course dates see: Pricing & availability

Reply Thu 2 Jun 2011, 13:00Trainer Anthony said...

RE: Excel 2007 Scenario toggling

Hi Simon, thanks for your query. Not without writing some code, I'm afraid. You could easily put some data validation on a cell to give you a drop down with the scenario names, but then you'll need to use the Worksheet_Change subroutine to capture the change in scenario name and switch to it. So it's a bit involved!

Hope this helps,

Anthony

Reply Mon 6 Jun 2011, 12:25Trainer Rodney said...

RE: Excel 2007 Scenario toggling

Hello Simon,

One more thing you may try without doing any code. Add the Scenario button to your 'Quick Access Toolbar' (QAT).

To do this, click the drop-down on the right hand side of the QAT and select More Commands. Click the drop-down on the top left hand side and choose 'All Commands' then scroll down to Scenario. Double-clicking Scenario will add it to your QAT. Go back to your Home ribbon and if you have scenarios in the sheet you can use the button on your QAT to choose a different scenario.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Mon 13 Jun 2011: Automatically marked as resolved.

Excel articles

· Microsoft Excel Training: Essential for Today's Employees
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Baffled by custom number formatting in Excel?
· How To Create A Data Table In Excel 2010
· Update Your VAT Rates In Excel

Please browse our web site to find out more about
excel training courses and other Microsoft training courses.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips