Question:
Working with a spreadsheet at work that has extensive footnotes. If this were a Word document, I could invoke autotext for some of these repeated phrases and expressions. Is there a way to do something similar in Excel? A macro, perhaps, and if so, how would it be formulated? These footnotes are prefixed with superscripted numbers.
Answer:
Word's Autotext changes things "on the fly." Excel doesn't have that (at least 97 doesn't). Instead, you can type an acronym of your own choosing, like LLCC for "Adult Learning Center," then use Edit, Replace to change them after the fact. Make sure you use an acronym that won't occur in any other context, even in the middle of any word (such as "the" in "weather"). If I'd used ALC, it would have changed the word "calculate." Excel doesn't have the "whole word" option.
My version of Excel 97 does have autotext. It uses the same autotext list as Word does. Look under Tools>Autocorrect.
