Many of us highlight important portions of documents while reading in Word. The question is, next time you refer to the document, how to read the highlighted portions only? Most people have not even attempted to find the answer to this question. They just scroll and scroll … defeating the purpose of highlighting!
The solution is simple. Press CTRL G and click he Find tab. Click More – open the Formatting dropdown. Choose Highlight.
Now the Find textbox shows that highlighted text will be searched. Click on Find. Now press Escape button to close the find dialog. Read the highlighted area. Now to find the next area just press CTRL PgDn button. Is this not easy and elegant?
Now, let us go one step further. What if you want to send only the highlighted content to someone? This is like selecting all the highlighted portions in one go. That is also easy. Instead of choosing the Find button, click the Find In – Main Document option. Now close the Find dialog. All the highlighted portions are now selected. Press CTRL C to copy and then paste it into another document. That’s it.
If you reuse an existing proposal for a new customer, you have to Find-Replace the customer name. Sometimes, the earlier customer remains and that can create a lot of problems for you. Here is an elegant way to prevent that from happening ever again. Using Word Fields. Watch the 3.5 minute video.
While working with Outlook Web Access (now called Outlook for Web), I noticed a nice little feature which I felt would be useful to fight the junk mail menace and reduce spam.
While handling my mail using OWA, I marked a particular mail as Junk. This messaged popped up. This way, the contents of message will reach Microsoft immediately. That will help them block similar types of mails at server level itself in future. Try it out and help fight spam.
I could not find a similar feature in Outlook full version. I am assuming that the data must be going to Microsoft if you have participated in the Customer Improvement Program.
Multiple desktops is like having multiple monitors on a single monitor. Windows 10 makes this feature very easy to use. Learn it in 4 minutes.
Continue reading Use multiple desktops in Windows 10 to simplify work
This is a picture blog. Self-explanatory! Learn how to Sum visible cells only using the Aggregate function.
Works only in vertical direction (not horizontal). It is best to use it with Excel Tables as shown above. That way, adding more data will automatically update the formula results.
Works from Office 2010 onwards.
This is the continuation of the earlier article about Validations. Data Validation using Formula is not very well understood. Hence this article. Try it out and you will immediately know where you can use it. Reading time 9 min.
Continue reading Data Validation using Formula
This is a very old feature. But it is still very useful. Spend 10 minutes to learn where you should use and not use Range Names in Excel.
Continue reading Where and when to use Range Names in Excel