Category Archives: Office

Which Office version do I have?

Most people do not need to know the exact version (nor do they care). But in case you are troubleshooting a problem with Office, you will need to know the version.

Finding the exact version is a funny story. Why? Because the version is shown somewhere in some menu. Over time, that menu itself has been changed and moved around. Therefore, the answer to the question “Which version do I have?” is “You have to go to place x, depending upon the version you have”. Angry smile

That does not make any sense. Therefore, it is a visual answer. You have to literally look at the way Office looks (Word, Excel , etc. ) and then figure out where the version is mentioned.

Microsoft has written a detailed article with screen shots to answer this question. Here is the link  Which Office version do I have?. This shows various screen shots. You open a file in Word and compare the screenshots to find the version.
Funny but true.

Drop-down Gamification

Office has so many features that there is no place to show all of them on screen. That is why, Microsoft has to use drop-downs and More… buttons. Unfortunately, most of us never even notice these buttons, leave alone clicking on them to find out what more is available. Due to this, thousands of brilliant features are never noticed. Here is the solution: Drop-down Gamification. This concept applies to More buttons and sub-menus as well. The objective is to make this self-discovery of feature gems as much fun as possible.

SNAGHTML32a4b238

Continue reading Drop-down Gamification

MRU Remove From List

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.

image

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.

  1. 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.
  2. I am presenting to customer X. I also presented to the competitor Y just yesterday. I want to remove files related to customer Y.
  3. 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.
  4. 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.

How to make Office UI look like Adobe UI

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.

Office UI Office Theme

Default Theme is white

image

Change it to Dark Gray theme

change Office UI to dark gray theme

You can also try the Colorful theme. It changes color based upon the product.

image    Office UI - colorful theme   image

Knowledge Pack: Google Docs vs. Microsoft Office 365

Here is a series of articles about this commonly performed comparison.
It offers an unconventional yet practical perspective.

  1. Google Docs vs. MS Office: Want vs. Need – the concept with few examples
  2. We are doing a feature comparison. So we should know the quantification as well.
    How many features does Microsoft Office have?
  3. Google Docs vs. MS Office: “I don’t need all these features”
    This post discusses the commonest response to feature explosion in Microsoft Office

more articles coming soon …