Turn on the Developer tab in Excel if you want to create a macro, export and import XML files or insert controls. To turn on the Developer tab, execute the following steps. 1. Right click anywhere on the ribbon, and then click Customize the Ribbon. 2. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary). 3. Check the Developer check…
Tag: Ribbon
Save file in 97-2003 Format
If you save your Excel files in 97-2003 format (.xls instead of the new .xlsx format), users who do not have Excel 2007 or later installed on their computer, can still open your Excel files. 1. Open a workbook. 2. On the File tab, click Save As. 3. Select Excel 97-2003 Workbook (*.xls) from the drop-down list. 4. Click Save. To automatically save your Excel files…
Customize Quick Access Toolbar in Excel
Quick Access Toolbar holds commands that a user uses frequently that is not in the ribbon. By default, the Quick Access Toolbar, located above the ribbon, contains the Save, Undo and Redo button. If you use an Excel command frequently, you can add it to the Quick Access Toolbar. You can even add commands to the Quick Access Toolbar that are not in the…
Excel Ribbon: Navigation, Customizing, Collapsing and All You Need To Know
How to Navigate through Excel Ribbon? Excel Ribbon are directly below File, Home, Insert, Page layout, Formulas, Data, Review and View tabs. Excel selects the ribbon’s Home tab when you open a workbook. You can checkout our previous post on Working with Excel ribbon. Customize Excel Ribbon The essence of customizing the ribbon is mainly to add more command icons that are needed by…
Working with and Understanding Excel Ribbon
What is Excel Ribbon? Excel ribbon is a strip of buttons and icons located above the work area that was first introduced in Excel 2007 version. The ribbon replaces the menus and toolbars found in earlier versions of Excel. Above the ribbon are a number of tabs, such as File, Home, Insert, Page layout, Formulas, Data, Review and View as shown in…