Insert Menu Commands Distributed over 5 Tabs in Excel 2007

Okay, so far you’ve studied the corresponding commands in Excel 2007 for the File menu, Edit menu and View menu. And you think … hmm … I get this new user interface. After all, most of the commands in each menu were ported into one area. For example the commands in the File menu are found mostly in the Office button. Likewise with the Edit menu. Most of the commands are in the Home tab. And ditto with the View menu commands. You therefore expect to find most of the Insert menu commands in the Insert tab. Well … yes and no. Of the 24 commands in the Insert menu, 4 are now found in the Home tab, 10 in the Insert tab, 6 in the Formula tab, 2 in the Review tab, one in the Page Layout tab and 1 didn’t make it.

What is clear is that users who are already familiar with the menu and toolbars will have to relearn the user interface.

 

Excel 2003 Commands Equivalent Excel 2007 Commands
Cells Home tab > Cells group > Insert button > Insert Cells
Rows Home tab > Cells group > Insert button > Insert Rows
Columns Home tab > Cells group > Insert button > Insert Columns
Worksheet Home tab > Cells group > Insert button > Insert Sheet (Shift + F11)
Chart Insert tab > Charts group
Symbol Insert tab > Text group > Symbol button
Page Break Page Layout tab > Page Setup group > Breaks > Insert Page Break
Function Formulas tab > Function Library group > Insert Function (Shift + F3)
Name > Define Formulas tab > Defined Names group > Name Manager (Ctrl + F3)
Name > Paste Formulas tab > Defined Names group > Use in Formula > Paste Names
Name > Create Formulas tab > Defined Names group > Create from Selection
Name > Apply Formulas tab > Defined Names group > Define Name > Apply Names
Name > Label Formulas tab > Defined Names group > Define Name
Ink Annotations (for Tablet PC only) Review tab > Ink group > Start Inking
Comment Review tab > Comments group > New Comment
Picture > Clip Art Insert tab > Illustrations group > Clip Art button
Picture > From File Insert tab > Illustrations group > Picture button
Picture > From Scanner or Camera No equivalent command
Picture > Ink Drawing and Writing (for Tablet PC only) Review tab > Ink group > Start Inking
Picture > Autoshapes Insert tab > Illustrations group > Shapes button
Picture > WordArt Insert tab > Text group > WordArt
Picture > Organization Chart Insert tab > Illustrations group > SmartArt button
Diagram Insert tab > Illustrations group > SmartArt button
Object Insert tab > Text group > Object
Hyperlink (Ctrl + k) Insert tab > Links group > Hyperlink (Ctrl + k)

Source: http://www.dslimited.biz/excel-zen/menu/insert-menu-commands.html

Comments

Post a Comment

Popular posts from this blog

Tagging Classic Music albums with Mp3tag for iTunes and Last.fm

Image
I realized a lot of people having trouble with tagging Classic music. Initially, I got into Classical music to take up this challenge but now I am hooked into it because of its nice sophisticated melodies. There has to be a very straight forward way of tagging music. The ID3v2 specification provides us frames for the following tags that can be used to organize classical music:   Artist AlbumArtist Conductor OriginalArtist Composer Album Name   My goal is to devise a plan to fit all of these tags into Classical music appropriately, so that the Classic music composers will appear in Last.fm statistics music will be organized and displayed well in iTunes   The primary focus is given to how the music is organized. This means tagging conventions for track names is not one of the primary concerns in this article. First we familiarise ourselves with the ID3v2 frames for the tags above.   TPE1 The 'Lead artist/L...
Read more

Having to remove shoes before you enter someone’s house

I have to put this in writing before I forget it over the time. While at work, I got a call from a friend of mine to help him connect to his new ISP. I drove after work to his house and as I approached the main door, I noticed all the shoes being removed and placed at a side. Conscience told me I had to remove the shoes I am wearing. The steel toe shoes I was wearing were strictly indoor and only had house-dirt if you call it that way. I drive to work and I have separate boots to wear during site visits. The shoes came up to my ankle so it took some time for me remove both and finally enter the house. The guy was just waiting at the main door like it was part of normal activity, but *not* for me it was! After I set up the new router it came to the point where I needed the new ISP username and password. Without a surprise he had no idea about it and he said that we will have to go to his cousin’s house to check his email and get the login details from the ISP’s email. I got out of the...
Read more

DVD to WMV9 Guide 4.5

Version 4.5 is being designed using Dreamweaver MX 2004 to make the site 100% compatible with Netscape 7.0 and Opera 7.0. Until the announcement of DVD to WMV9 Guide 4.5, there will be no updates to DVD to WMV9 Guide. Visit DVD to WMV9 Version 4.4
Read more