How do I get the classic Excel menu back in Excel 2010

Hi,

thank you for your comments - I do have a question about the toolbars: you said that the toolbar can be imported from 2003 into 2010. There arises a further question: These versions are on two separate laptops - do I have to give up the nice idea of importing or might there still be a way to do this (a way simple enough for a granny to implement ;)

Marjatta

Well, in my opinion there are also improvements with Excel 2010: it seems it saves a lot of disc space when compared with excel 2003. I have rather complicated tables and (e.g. in one file) the size of the file shrank into some 20% of the original. That definitely is a PLUS for the newer version. Strangely enough, opening it takes just the same long time than opening the original large file....Marjatta

Yes, the new "X-file" formats can be smaller than the 2003 files.  The X files are XML based "text" format primarily and that text is compressed using the ZIP algorithm.  You can see this by simply adding ".ZIP" to the end of a file name.  In Windows Explorer, you will then be able to navigate down into the newly exposed file structure to see the various XML components.

Yes, it would be really nice if the QAT was a little friendlier.

You also have the option of creating your own custom TABs or GROUPS (on existing tabs).  This gives you the option of somewhat recreating your old custom toolbars.

FYI: you can also import custom toolbars from 2003 into 2007/10/13.

I can give you more info on these concepts if you wish.

Hi,

this is an old thread indeed - and shows how frustrated many of us are with the ribbon. I dislike most of the chain - answers often seem to concentrate in ridiculing the "opponent".

Well, in my opinion there are also improvements with Excel 2010: it seems it saves a lot of disc space when compared with excel 2003. I have rather complicated tables and (e.g. in one file) the size of the file shrank into some 20% of the original. That definitely is a PLUS for the newer version. Strangely enough, opening it takes just the same long time than opening the original large file....

Also, some new functionality has been added into the tools. 

However, to come back to the ribbon issue: yes, I have got used to it BUT still I dislike it. I really hate having to jump between whatever you may call them, "pages of Shortcut collections" when working.

I do not like the drop-down lists of Excel 2003 either so I had customized the Toolbar to contain all short cuts I ever use - so it was more or less 5 rows "thick" - and enabled me to use different tools very quickly. True, it eats up some space from the top of the page - that's why I lake by laptop to have a screen of 17" or more :).

OK, in Excel 2010 I can also activate my tools in the Quick Access toolbar - but even if I hide the ribbon to save screen space, quick-access toolbar shows only one row - and it is another source of disgust to open the hidden rows in order to see what you want to see and use.

If only MS would enable seeing the Quick Access Toolbar in its entire customized shape, I'd be happy.

But don't expect anything in that regard from MS.

With regards,

Marjatta

I wasn't asking how or asking you to answer. Perhaps you did so to aver.that you "have" already wasted the time to figure those out. Hopefully, showing the answer won't deprive those [who think the interface is viable] from experiencing firsthand just how completely and utterly inept it is.  You might try doing what you did on the keyboard though.  Hope you don't have anywhere to go for a few hours or days.

And if you don't know what alt-V-T means, or meant, then it will not possibly be of any use to you. Real, real, real fast keyboard users - people who make the world go round, and do all the work out there - could not conceive of not knowing or using alt-V-T...

...and the Mentally Defective Microsoft Interface Design and Deproductivity Department ... destroyed it.

MS: offer the menu interface as an OPTION.  Is it a budget matter, for the most cash-rich company in the galaxy? I'm talking to you, Jensen Harris. Do you realize what damage you've done to the world?