MRU is a list of Most Recently Used files. We see that list in File – Open –Recent documents. As you know, this list shows the latest documents opened by you. Documents opened earlier move down in the list and eventually get removed when more files are opened. However, Office allows you to explicitly remove a particular item from the MRU list. Right click on any item and choose Remove from List.
The question is, why would you want to do that? Anyway the file will get flushed from the list soon. The answer is not so obvious. There are many practical scenarios where this is very useful. I am not going to explain each scenario. Just a list.
- You opened a local file and stored it on OneDrive. Now to files are seen in MRU. I want to remove the local file to avoid editing it accidentally.
- I am presenting to customer X. I also presented to the competitor Y just yesterday. I want to remove files related to customer Y.
- I opened XLS file, saved it as XLSX. This way Compatibility Mode is removed and I can use all the new features. Now, I do not want to accidentally open the XLS file and confuse myself.
- I am editing a complex file. I keep saving versions. When I save the latest version, I want to remove the entry of the older version from MRU to avoid confusion
If you can think of more usage scenarios, do post it as comments.
This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational Operational Risk significantly. Notice the green mark below.
This is the biggest Excel risk.
If you see even a single green mark, you should send the file back.
Ask the sender to handle all the green marks and send the revised file to you.
Of course, they may not know what you are talking about.
Ask them to read these 5 articles: Knowledge Pack: Green Marks in Excel
The rule is, Excel sheet with Green Marks should not be sent to anybody. It is the sender’s responsibility to remove all errors – not the recipient’s.
Continue reading Excel risk Mitigation
Word Mobile is a brilliant product. It exceeds expectations in every possible way. For example, take a simple feature like scrolling. What more can you do to enhance scrolling? But Microsoft has really boosted that feature beyond your imagination. Here is a short visual blog to show you how it works.
14 sec video. It will repeat automatically.
It allow you to scroll while viewing the thumbnail. So convenient and useful.
The clarify of the thumbnail is perfect, even on the small mobile screen.
Works flawlessly with large documents.
Reach the desired page and stop scrolling. It will move to that page.
There is no way to abort scrolling. Remember, no Esc button on mobiles!
Neither scrolling nor thumbnail is a new feature in itself.
But combining them together in touch context is called innovation.
Although Word is most commonly used for creating documents, it can also be used for capturing data like a form. Word Forms do not require any programming knowledge. These are easy to create and will work across ALL versions of Word.
The Need for Word Forms
This is very useful for conducting quick surveys or quizzes where you want to control the responses. Of course, there are more sophisticated methods and tools available for bother these scenarios, Word is familiar to everyone and almost guaranteed to be available on every desktop. Hence it is a compelling option even today (2017).
Continue reading Using Word Forms
This is a sneak preview of my upcoming Udemy course on Pivot Tables. This video explains the relationship between Pivot Tables and File Size. Watch this 6 minutes video and learn from it.
Apply this knowledge to your existing pivots – especially those with large file sizes and see the difference. Make sure you try it out on a copy. Never learn using Live files.
Continue reading Pivot Tables and File Size
Here is the list of articles I have written about Show Values As in Pivot table. This is a very important set of features but are mostly ignored.
Continue reading Show Values As: Knowledge Pack
Attachments is the most popular and misused Outlook feature. If you are DELIVERING a file – use attachments. If you are Sharing a file – it is best to share the file. Sending CCs is the most important reason why “Teamwork” is inefficient. Here is a practical guide about how you should use Outlook Attachments with Office 365.
Continue reading Outlook Attachments Usage Guide
Here is a new year gift for the Indian customers. Converting Amount to Words is always a problem. Many application require it and that code is always written manually, within the application. What is really needed is a comprehensive Excel function. Many people have written lots of Excel functions. But neither of them is specific to India, nor is it comprehensive.
We (Raj and me) had created it in 2005, but I had forgotten to publish it on the blog. We have done good amount of testing – but still you have to use it at your own risk. No guarantees. Read on to download, install and use the Excel function.
Continue reading Amount to Words macro