Hey! Who Took My Tools?
October 12th, 2008 Posted in MenuMy work tools seem to have a habit of walking away just when I need them. No matter how hard I try to organize them, they just scoot off.
In Excel 2007, you might be surprised to find that there isn’t a tab similar to the Tools menu. Your favorite add-ins haven’t disappeared. Instead they have been relocated to a new Add-Ins tab. The auditing, macro and protection tools have migrated to various tabs on the ribbon. Part 6 of the menu series covers the Tools menu commands in Excel 2007.
The auditing, macro and worksheet protection tools have moved to the Formula tab, Developer tab and Review tab respectively. Look for Goal Seek and Scenarios in the Data tab. The Add-ins Manager is now buried deep inside the Excel Options.
You won’t find the Developer tab unless you’ve enabled it. It isn’t enabled by default. To enable the Developer tab, open the Excel Options and navigate to the Popular category. Click on the check box that says Show Developer tab in the Ribbon and then click the OK button to exit. The Developer tab should now appear in the ribbon.
Tools Menu
| Excel 2003 Commands | Equivalent Excel 2007 Commands |
|---|---|
| Spelling (F7) | Review tab > Proofing group > Spelling (F7) |
| Research (Alt + Click) | Review tab > Proofing group > Research (Alt + Click) |
| Error Checking | Formula tab > Formula Auditing group > Error Checking > Error Checking |
| Speech > Show Text to Speech Toolbar | No equivalent command |
| Shared Workspace | Office button > Publish > Create Document Workspace |
| Share Workbook | Review tab > Changes group > Share Workbook |
| Track Changes > Highlight Changes | Review tab > Changes group > Track Changes > Highlight Changes |
| Track Changes > Accept or Reject Changes | Review tab > Changes group > Track Changes > Accept/Reject Changes |
| Protection > Protect Sheet | Review tab > Changes group > Protect Sheet |
| Protection > Allow Users to Edit Ranges | Review tab > Changes group > Allow Users to Edit Ranges |
| Protection > Protect Workbook | Protection > Protect Workbook |
| Protection > Protect and Share Workbook | Protection > Protect and Share Workbook |
| Online Collaboration > Meet Now | No equivalent command |
| Online Collaboration > Schedule Meeting | No equivalent command |
| Online Collaboration > Web Discussions | No equivalent command |
| Goal Seek | Data tab > Data Tools group > What-If Analysis > Goal Seek |
| Scenarios | Data tab > Data Tools group > What-If Analysis > Scenario Manager |
| Formula Auditing > Trace Precedents | Formula tab > Formula Auditing group > Trace Precedents |
| Formula Auditing > Trace Dependents | Formula tab > Formula Auditing group > Trace Dependents |
| Formula Auditing > Trace Error | Formula tab > Formula Auditing group > Error Checking > Trace Error |
| Formula Auditing > Remove All Arrows | Formula tab > Formula Auditing group > Remove Arrows |
| Formula Auditing > Evaluate Formula | Formula tab > Formula Auditing group > Evaluate Formula |
| Formula Auditing > Show Watch Window | Formula tab > Formula Auditing group > Watch Window |
| Formula Auditing > Formula Auditing Mode (Ctrl + `) | Formula tab > Formula Auditing group > Show Formulas (Ctrl + `) |
| Formula Auditing > Show Formula Auditing Toolbar | Formula tab > Formula Auditing group |
| Macro > Macros (Alt + F8) | Developer tab > Code group > Macros |
| Macro > Record New Macro | Developer tab > Code group > Record Macro |
| Macro > Security | Developer tab > Code group > Macro Security |
| Macro > Visual Basic Editor (Alt + F11) | Developer tab > Code group > Visual Basic |
| Macro > Microsoft Script Editor (Alt + Shift + F11) | No equivalent command |
| Add-Ins | Office button > Excel Options > Add-Ins category > Manage box select Excel Add-Ins then click Go |
| AutoCorrect Options | Office button > Excel Options > Proofing category > AutoCorrect Options button |
| Customize | Office button > Excel Options > Customize category |
| Options | Office button > Excel Options |
Tags: commands, Excel 2003, Excel 2007, Menu, tools
