Excel 2007 Interface

  • Thread starter Thread starter Paul W Smith
  • Start date Start date
P

Paul W Smith

Is there any way to use Excel 2007 with toolbars like all THe previous
versions, or at least Excel 2003.

My productivity is appauling using Excel 2007 as evertything takes so long
to find, if indeed i Can.

PWS
 
Hi Paul,

To see the traditional menus, you may download one free addin from Addins
page of below site

http://in.geocities.com/shahshaileshs/

choose Excel Menu 2003.

1. This Addin need to load only for the first time.
2. It installed Worksheet Menubar, Standard Toolbar and Formatting Toolbar
in the Addins Tab inside the Ribbon.
3. The File Size is only about 20 kb.


BTW when you use more of Excel 2007, you should be familar with the 2007
Ribbon UI.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.
 
If you work at it, you can find it at, follow the Excel add-ins link. Not
tried it but it looks okay

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I have tried it, and it works fine.
Nice bit of code and thanks to Shah Shailesh for sharing this with
everyone.

--
Regards

Roger Govier


Bob Phillips said:
If you work at it, you can find it at, follow the Excel add-ins link.
Not tried it but it looks okay

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)
 
Hi there,

I just hopped on Excel 2007, after being an avid user of 2003. I was
formally a key command wizard, and I new every shortcut. Now I am
lame and slow.

Two questions. First, Excel 2007 has retained the 2003 key commands,
but I've noticed that keying in these 2003 commands takes much longer
than it used to. Is anyone else seeing this in Excel 2007? 2003 key
commands hard to use?

Second, I'm wondering how many people are going to stick with the new
interface or go with Shah's add in. Any strong feelings here?
 
Steve Kleha said:
Two questions. First, Excel 2007 has retained the 2003 key
commands, but I've noticed that keying in these 2003 commands
takes much longer than it used to. . . .

There's almost certainly going to be a lag because XL2007 has to
interpret whether your keystrokes match the ribbon or the prior
version 'Classic' menu. It also displays your keystrokes in a little
box as you type them. No doubt that's been, er, optimized for Vista so
it'd only takes a few extra MB RAM and a few hundred milliseconds of
CPU time.

Sarcasm aside, I wouldn't want to bet this feature survives into the
next major version.
Second, I'm wondering how many people are going to stick with
the new interface or go with Shah's add in. Any strong feelings
here?

Lots of strong feelings. It was never self-evidently obvious to me
that spreadsheets, word processors and other application types would
benefit from the same basic UI. MSFT seems intent on taking this to
absurd extremes. Also, if MSFT can adict Office users to the ribbon
UI, and since it won't license the ribbon UI to any direct
competitors, and since Lotus Development Corp. vs Mosaic Software and
Paperback Software International is still operative law in the US,
potential competitors may not be able to clone the ribbon's look &
feel, MSFT is further cementing its monopoly, er, competitive
advantage by forcing the ribbon on Office users.

The ribbon may be better for GRAPHICAL tasks like selecting themes,
but it's less reading bits of text on different lines spread all
across the screen than it is reading a list (which is what Classic
menu entries are). That means the ribbon is not better for all tasks,
and it's certainly not better for more advanced users of previous
versions. However, it meets MSFT's goal of crushing what little
competition there still is quite nicely.
 
I have had the same problem although I upgraded from Office 2000 to
Office 2007. Once I have learned where commands may be found, my
productivity is returning. The problem is that learning command
locations after 7 years of practice with Office 2000 can be quite
difficult & time consuming. Here are a few references I have found
useful:

Excel ribbon mapping workbook. This workbook lists the locations of
Excel 2003 commands in Excel 2007.
http://office.microsoft.com/en-us/templates/TC102128621033.aspx?pid=CT102130321033&AxInstalled=1&c=0

Excel shortcut and function keys
http://office.microsoft.com/en-us/excel/HP100738481033.aspx?pid=CH100947761033

Excel 2007 Cheat Sheet
Here's how to find your way around and get the most out of Excel 2007
http://www.computerworld.com/action...eBasic&articleId=9028228&source=NLT_AM&nlid=1

Microsoft offers similar workbook help files for Word & Powerpoint.

The Excel 2007 Cheat Sheet (once you view it with your browser)
contains a link for a Word 2007 cheat sheet.

Let me know if you need Word & Powerpoint links
 
Back
Top