Excel 2007 Help

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my macros
and 2 In 2003 there used to be a box you could click on to instantly go to
nakmed ranges. Where do I find this?

Also is there discussion page solely for Excel 2007 changes?

Thanks
Rick
 
Rick said:
I have recently upgraded to Excel 2007.

Naturally things are a bit different and I am working through them. But 2
things I can't find. How do I add a menu option so I can list all my
macros
Click to expand...

Click on View tab, and at the far right-hand side click on Macros...

and 2 In 2003 there used to be a box you could click on to instantly go to
nakmed ranges. Where do I find this?
Click to expand...

The box is where it's always been, to the left of the formula bar....
Also is there discussion page solely for Excel 2007 changes?
Click to expand...

Nope.
 
Gordon said:
Click on View tab, and at the far right-hand side click on Macros...



The box is where it's always been, to the left of the formula bar....


Nope.
Click to expand...
To add to Gordon's reply, once you find the icon you can right click on
it and add it to your quick access tool bar and it will display above
your ribbon.

gls858
 
The named ranges I couldn't find because I didn't have any so that is sorted
thank.

However, with the macros issue I have the shortcut on my tool bar OK to view
any macros on open spreadsheets, but on Xl2003 I had a menu for all my
macros. How do I create the menu to attached them and run them directly.

Thanks
 
Back
Top