Microsoft Office Tutorials and References
In Depth Information
Five Excel Oddities
Five Excel Oddities
You might rarely need any of the features presented in this section. However,
in the right circumstance, they can be timesavers.
Adjust the gridline color in the Display section of the Advanced
category. If you are tired of gray gridlines, you can get a new outlook
with bright red gridlines. I ve met people who have changed the grid-
line color and can attest that nothing annoys an old accountant more
than seeing bright red gridlines.
Allow negative time by switching to the 1904 date system in the Gen-
eral section of the Advanced category. Excel never allows a time to
return a negative time. However, if you are tracking comp time and you
allow people to borrow against future comp time, it might be nice to al-
low negative time. In this case, switch to the 1904 date system to have
up to 4 years of negative time. Use caution when changing this setting.
All existing dates in the workbook will shift by approximately four
Put an end to the green triangles on your account numbers stored as
text. Most of the green triangle indicators are useful. However, if you
have a column of text account numbers where most values are num-
bers, seeing thousands of green triangles can be annoying. In addition,
the green triangles can hide other, more serious problems. Clear the
Numbers Formatted as Text or Preceded by an Apostrophe in the Error
Checking Rules check box in the Formulas category.
Automatically Insert a Decimal Point replicates the antique adding
machines that were office fixtures in the 1970s. When working with a
manual adding machine, it was frustrating to type decimal points. You
could type 123456 and the adding machine would interpret the entry as
1,234.56. If you find that you are doing massive data entry of numbers
in dollars and cents, you can have Excel replicate the old adding ma-
chine functionality. After enabling this setting, you can indicate how
many digits of the number should be interpreted as being after the
decimal point. The only hassle is that you need to enter $5 as 500
500. The
old adding machines actually had a 00 key, but those are long since
Change Dwightto Diapersusing AutoCorrect Options. If you are a
fan of the NBC sitcom The Office, you might remember the 2007 episode
Search JabSto ::

Custom Search