Microsoft Office Tutorials and References
In Depth Information
Maximizing usable space in the program window
If you’d like to export your ribbon customizations to a file that can be used to apply those
changes to another Excel 2013 installation, click the Import/Export button and then click
Export All Customizations. Use the controls in the dialog box that opens to save your file.
When you’re ready to apply saved customizations to Excel, click the Import/Export button,
click Import Customization File, select the file in the File Open dialog box, and click Open.
When you’re done customizing the ribbon, click the OK button to save your changes or click
Cancel to keep the user interface as it was before you started this round of changes. You
can also change a tab, or the entire ribbon, back to the state it was in when you installed
Excel. To restore a single tab, click the tab you want to restore, click the Reset button, and
then click Reset Only Selected Ribbon Tab. To restore the entire ribbon, including the Quick
Access Toolbar, click the Reset button and then click Reset All Customizations.
Maximizing usable space in the program window
You can increase the amount of space available inside the program window by hiding the
ribbon, the formula bar, or the row and column labels.
To hide the ribbon, double-click the active tab label. The tab labels remain visible at the top
of the program window, but the tab content is hidden. To temporarily redisplay the ribbon,
click the tab label you want. Then click any button on the tab, or click away from the tab, to
rehide it. To permanently redisplay the ribbon, double-click any tab label.
KEYBOARD SHORTCUT Press Ctrl+F1 to hide and unhide the ribbon. For a complete list of
keyboard shortcuts, see “Keyboard shortcuts” at the end of this topic.
To hide the formula bar, clear the Formula Bar check box in the Show/Hide group on the
View tab. To hide the row and column labels, clear the Headings check box in the Show/
Hide group on the View tab.
In this exercise, you’ll add a button to the Quick Access Toolbar and customize the ribbon.
SET UP You need the PackageCounts workbook located in the Chapter01 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Click the File tab to display the Backstage view, and then click Options to open the
Excel Options dialog box.
Click Quick Access Toolbar to display the Customize The Quick Access Toolbar
Search JabSto ::

Custom Search