Microsoft Office Tutorials and References
In Depth Information
Ten Options to Consider
File menu. You can change this setting by visiting the Display section
of the Advanced category.
• Edit Custom Lists has been moved to the Display section of the Ad-
vanced category. Custom lists add functionality to the fill handle,
allow custom sort orders, and control how fields are displayed in
the label area of a pivot table. Type a list in the correct sequence in
a worksheet. Edit Custom Lists and click Import. Excel can now auto-
matically extend items from that list, the same as it can extend Janu-
ary into February, March, and so on.
• Make Excel look less like Excel by hiding interface elements in the
three Display sections of the Advanced category. You can turn off
the formula bar, scroll bars, sheet tabs, row and column headers,
and gridlines. You can customize the ribbon to remove all main tabs
except the File menu. The point is that if you design a model to be used
by someone who never uses Excel, the person can open the model, plug
in a few numbers, and get the result without having to see the entire
• Show Zero in Cells That Have Zero Value is in the Display Options
for This Worksheet section of the Advanced category. Occasionally
people want zeros to be displayed as blanks. Although a custom num-
ber format of 0;-0;; will do this, you can change the setting globally
by clearing this option.
• Group Dates in the AutoFilter Menu is in the Display Options for
This Workbook section of the Advanced category. Starting with Excel
2007, date columns show a hierarchical view of years, months, and
days in the AutoFilter drop-down. If you like the old behavior of
showing each individual date, turn off this setting.
• Add a folder on your local hard drive as a trusted location. Files
stored in a trusted location automatically have macros enabled and
external links updated. If you can trust that you will not write mali-
cious code, then define a folder on your hard drive as a trusted loca-
tion. From Excel Options, select the Trust Center category and then
Trust Center Settings. In the Trust Center, select Trusted Locations,
Add New Location.