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/Lead performer/S
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

DVD2WMV Encoder 1.0 ALPHA Started

Now it's under active development. The main challenge is WMEncoder refusing AviSynth script files. While writing the CCE to WMV guide this idea was to born to create a tool to calculate the total time of a movie. This will be added to DVD2WMV Encoder -- not as a standalone executable but integrated, so that the values can be used by the WM9 Bitrate Calulator part to determine the target Video Bitrate. 0:41:38 + 0:39:15 + 0:39:11 = 0:119:64 = 1:59:64 = 1:60:04 = 2:00:04
Read more