Sunday, January 27, 2013

Look up words in the thesaurus

You can look up synonyms and antonyms using the thesaurus.

  • On the Review tab click on Thesaurus.
  • Press ALT and click on the word that you want to look up. Results appear in the Research task pane.

Monday, January 21, 2013

Look up words in the dictionary in MS Excel

You can check the spelling of a word or find its defination using the Research features.

  • On the Review tab, click on Research button.
  • To lookup the contents of a cell, press ALT and click the cell that you want.
    • if there is one or more word in the cell, it will treat as a phrase.
  • Type a word or phrase in the Search for box and click on Start Searching.
  • And results appear in the Research task pane.

Automatically save MS Excel files

Sometimes Microsoft Office program closes before you can save changes to a file that you are working on.

Some possible reasons include below:
  • Power outage
  • Unstable system
  • if you close your file without saving
So, you have to protect your file when your file closes abnormally.

How to Enable AutoSave?
  • Click on File tab.
  • Under Help menu, click on Options.
  • Click Save.
  • Check on Save AutoRecover information every 'X' minutes.
  • Also change the location where the program automatically saves files you working on.