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 is a special post for avide Adobe users. Adobe products have dark gray menus. It reduces the eye-strain. Office UI are white in color by default. And many people work on Office as well throughout the day… so how do you reduce the eye-strain? Simple.
Go to File – Options and choose Dark Gray theme. This theme was introduced in Office 2016. Office 2013 also has a gray theme but it is not as dark. See the difference for yourself.
Default Theme is white
Change it to Dark Gray theme
You can also try the Colorful theme. It changes color based upon the product.
This is the first thing you should do when you get Office 2016. There are three options available. Choose the one which suits you the best. Try each for few days if you are not sure. Here are the details…
Continue reading Office 2016 – Better look and feel options for menus (ribbon)
QAT is a great way of putting commonly used buttons just one click away. I found a nice way of adding buttons at the right location. Read on to find out how…
Continue reading In-depth: Customize Quick Access Toolbar Precisely
The official answer to finding the version of office is here. But it requires some trial and error. I found a very simple way. Rather than asking the user (or customer) to find out this information, it is simpler to detect it myself. I ask the customer to send the screenshot of File menu to me. That shows the version number easily.
2003 and before – File menu has a Page Setup menu option.
2007 – NO File menu. Instead there is a round, colorful button
2010 – File menu has Save and Send option
2013 – File menu has Share option
Simple and effective. Works all the time.
Small but useful post. Since Office 2012, CTRL O or CTRL S do not open Open / Save dialogs. You must click CTRL O – Computer – Browse to get that dialog. This is a GOOD THING. Because Microsoft wants to change our bad habit of storing everything locally and help us move to internet storage (OneDrive, SharePoint, DropBox, etc.).
In some cases, you want to do some quick and repeated operations on local PC. Want the simple Open / Save dialog just with CTRL O and CTRL S. Wish granted!
File – Options – Save – Don’t show the Backstage when opening or saving files.
Use this option temporarily. When the job is done, go back to the Backstage view. I will write more articles about Why Backstage is important very soon.
Using Office on a Windows touch tablet is difficult – because all the buttons and menu options are very close together. You end up choosing the wrong option by mistake. Frustrating! Solution has been given since the Office 2013 version was released. On top left corner of Office tools, look for the Touch Mode button.
Why Choose Touch Mode?
Choose Touch Mode and miraculously your problem is solved – instantly. Of course, number of options available do not reduce (that is not an option for Microsoft!). But the SPACING between them increases so that you can confidently touch what you want with your finger.
Also notice that the right click menus, drop downs and galleries also get spaced out. Can you even begin to imagine how much extra effort went into implementing this feature? Appreciate it and use it!
Read this article to know what is Quick Access Toolbar. Dual buttons are those which have two parts. Here is how you add the lower part to Quick Access Toolbar…
Continue reading What did I learn today: Adding dual buttons to Quick Access Toolbar
In today’s world of mobile phones and apps, finding options is becoming more and more difficult. These weird looking symbols have now become the default of showing menus with more options. I realized that many of us do not notice these symbols and therefore lose out on lots of nice features. Hence this article.
Continue reading … Are you noticing these “cool” / “awesome” menu options?