|
Versions of Office from 95 up
have had a feature in all applications,
including Excel, which can correct common
misspellings and make the entry of common
symbols, such as © and
® simple. Autocorrect can also be customised by
the user to correct spellings they find
difficult personally, or to shorten the entry of
long repetitive text. (See dialog below).
It is also capable of turning
off the caps lock key is it senses
capitalisation is wrong, capitalising the first
word of a sentence, etc.
Sometimes this feature can be
a problem however, but simply pressing Ctrl+Z
after an auto-correction will allow you to undo
the change and enter the text you want. If you
find yourself doing this often, you may want to
delete the entry from the Autocorrect list.
The 'Exceptions' button
allows you to set exceptions for correction of
two capitalised initial letters, (e.g. ID) and
capitalised first letter of sentences. (e.g.
after approx.).
'Autoformat as you type' tab
allows you to set the handling of internet or
email addresses and rows/columns added to
'lists' (Excel XP up).
Lastly the 'Smart Tag' tab
allows you to control a new feature to Excel XP
and up (and all other Office applications).
These appear as small coloured triangles in the
bottom right corner of the cell, when hovered
over a small icon appears which can be clicked
on to select options. (Below Excel has
recognised a date and is offering options to do
with the date).
In this tab, shown below, you
can switch them off, add to them from the
Microsoft site, check the current workbook
for entries that a smart tag may recognise, or
embed them when you save the current workbook.
Lastly, in the 'Show smart
tags as' drop-down, you get the opportunity,
much like
comments, to show them as 'indicator and
button', 'indicator only' or 'none'.
 |
