LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
51
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Speed up Inputting Complicated Terms with AutoCorrect
UPVOTE
51
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Speed up Inputting Complicated Terms with AutoCorrect

Excel Spreadsheet

Take my name, Liza Brown, for ex., w/c can be replaced by LZ. Every time I input LZ, it can autocorrect to Liza Brown. Go to File->Options->Proofing->AutoCorrect Options and input Replace text with correct text in the red rectangular area, as above.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

If you need to repeat the same value and it is complicated to input, the best way is to use the AutoCorrect function, which will replace your text with the correct text. Take my name, Liza Brown, for example, which can be replaced by LZ. Therefore, every time I input LZ, it can autocorrect to Liza Brown. Go to File->Options->Proofing->AutoCorrect Options and input Replace text with correct text in the red rectangular area, as above.



User Comments