There are 9 categories of Excel Options:.These options have changed significantly in 2007, so take a minute to look over the changes Excel Options – Opens the Options Menu previously located on the Tools Menu.This feature was originally located in the Shared Workspace Task Pane in Excel 2003 PowerPoint, Word) Documents related to that Workbook. Create Document Workspace: Creates a separate, online workspace for the a Excel Workbook and all related office (i.e.Workbook Management Server:This is a New Feature, and it replaces the File>Save as step, by sending the Workbook directly to Document Management server.Excel Services:This is a New Feature, saves workbook on an online browser.The Run Compatibility Checker checks to see if a feature used in the Excel 2007 Workbook is compatible with earlier versions of Excel in case the Workbook needs to be saved in an earlier format.Mark as Final: This feature previously located in the Track Changes tab of the Options Menu in 2003.Add Digital Signature:Feature previously located in the Security tab of the Options Menu in 2003.Restrict Permission: Feature previously located in the File Menu in 2003.Encrypt Workbook: Feature previously located in the Security tab of the Options Menu in 2003.Inspect Workbook:This is a New Feature.Properties: Feature previously located in the File Menu in 2003.There are several functions within this Menu Prepare– Prepares the Workbook for distribution.Print Preview - Shows you what the Workbook will look like prior to printing.Quick Print – Sends Workbook directly to printer.Print– Prints Workbook and offers a Menu to make adjustments to the print function (i.e.You MUST save presentations in Excel 97-2003 format to open them in older versions of Excel.Save As – Saves presentation with another name or presentation extension.Convert - Converts older Excel files into the 2007 Format.The MS Office Button replaces the File Menu
#Scroll bar missing in excel 2003 how to#
This opens a new window with an definition and an expanded explanation of how to use the feature or option In some cases, the F1 Button is also available.Instead, each item on the ribbon has an expanded balloon that explains the feature or option. In Office 2007, there is not a Help Menu.The Ribbon Groups: Sections containing Related items or tasks Tabs: 8 tabs representing common related activities Commands: Buttons, boxes or Menus relating to specific functions within Excel Formula Bar: Shows Excel Formulas All Menus are located within tabs on a Menu bar called the Ribbon The three parts of the Ribbon are Tabs, Groups, & Commands. Menus and Toolbars - 2007 Office 2007 is arranged differently. Menus and Toolbars - 2003 In Excel 2003, different functions within Excel are accessed through the Menu Bar,StandardToolbar, the Formatting Toolbar, and the Formula Bar Menu Toolbar Formula Bar Standard Toolbar Formatting Toolbar Click on the arrownext to the toolbar, to open the customize Menu Click the checkbox next to each feature to add and more options to the toolbar This is a New Feature By default, there are 3 buttons Save,New, and Open. Quick Access Toolbar Located next to the MS Office Button, the Quick Access Toolbar offers one-click access to the most widely used office functions. Excel Options(previously located under the Tools Menu).Publishto distribute a presentation to a server, blog, or shared workspace.Send which distributes presentations through facsimile or email.Prepare to finalize presentations for distribution.Convertconverts Excel files into the 2007 Format.