Microsoft Office Tutorials and References
In Depth Information
Section 10: Customizing Excel to the way you work
Customizing Excel
to the way you
In this section:
Another way to make your life easier is to create templates. A template
Opening ready-to-use workbook
is a workbook that you use as a pattern for other workbooks. When
you open a template, which is a separate Excel file type, you have the
outline you need to create frequently used workbooks quickly.
Saving a workbook as a template
Adding commands to and moving the
Quick Access toolbar
You also have a great deal of control over how Excel handles the data that
you enter in your worksheets. Excel tries to be helpful by identifying
formulas that it thinks are mistakes, probably because the formula isn’t
consistent with other formulas near it or because it leaves out cells in a range.
Sometimes those mistakes are exactly what you intended. The same is true
for potential misspellings. Excel identifies and corrects the most common
misspellings, but if a word Excel identifies as misspelled is actually correct,
you can prevent Excel from making that change without turning off the
corrective behavior entirely.
Adding, reordering, and removing
ribbon elements
Creating new ribbon tabs and groups
Renaming a ribbon element
Hiding and displaying ribbon tabs
Controlling which error messages
Choosing the color Excel uses to display
Microsoft Excel 2013 gives you lots of ways to work with your data, with
literally hundreds of commands at your disposal. If you find that it takes
several mouse clicks to reveal a command that you use all the time, you
can add that command to the Quick Access toolbar so that you can
activate it with a single click. Excel 2013 also enables you to create custom
tabs on the ribbon.
Defining AutoCorrect entries
Controlling AutoFormat rules
Search JabSto ::

Custom Search