View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Stonewall Rubberbow Stonewall Rubberbow is offline
external usenet poster
 
Posts: 12
Default 2007: Close to giving up !!!

Charlotte,
I've had a lot of headaches getting used to almost every change here.
But I have to admit that eventually, you'll see the logic in the layout, but
it might take a while. Here are some things I've come to realize that may
help ease the transition:
1. Most things that were in the Tools menu are found under the Office
Button in Excel Options.
2. Most things that were found in the Control/Forms Toolbox are under
the Developer tab, which is hidden be default. You make it visible by
changing one of the checkboxes within Excel OptionsPopular.
3. Many common tasks that relate to a worksheet can be found by
right-click on the sheet's tab itself (such as hiding/unhiding worksheets).
4. If you aren't finding the option you know should be there somewhere,
such as setting a chart type as your default chart, don't forget to click the
little tiny box-with-arrow at the bottom corner of some of the grouped ribbon
menu items.
5. The Name Manager (if you do a lot of range naming) is in the
formulas tab, and will become your new best friend, I'm totally serious
because it's far better than the old name manager. Besides, it's more logical
that naming a range relates to creating formulas, than it relates to
inserting (2003's location).
Things are better in 2007, but it does take a while to see it. What you
should see right away, is that your files are about half the size they used
to be. Also, I don't know if this was just my problem or not, but I'm used to
automatic calculations, and I think 2007 has calculations set to Manual by
default (for a long time I couldn't figure out why my conditional formatting
wouldn't act right).
And I think we all know what would happen if MS had created an option
for users to choose the 2003 menu bar over the ribbon. ;)


"Charlotte E" wrote:

I've tried installing Excel 2007, but must admit I'm close to giving up !!!
How can anything in this world be so solw and clombersome ?!?

And, also I'm finding myself spending 90% of my time looking for, what I
think is seemingly simple stuff!

Like, right now:

- Where to find the dialog for inserting and deleting names???
- Where to find the dialog for hiding and showing sheets???

There simply no logic in this Office package!!!

Why, oh why, haven't Microsoft let the user decide if he wants ribbons or
menus?!?
Why, oh why, are we forced to use what some smartass focus/developer group
suddenly think is the coolest thing since sliced bread!?

Can someone, PLEASE, help me?!?


TIA,

CE