The official answer 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.
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 QAT. Dual buttons are those which have two parts. Here is how you add the lower part to QAT…
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.
This article assumes that you are a right handed person, if you are a left handed person, you have to use the other mouse button (secondary mouse button).
Drag and drop performs most popular action
When you drag and drop items, the most commonly expected logical action happens. For example, when you drag a file from one folder and drop it into another folder, it is moved.
That is called the DEFAULT ACTION.
Another example is… when you drag a number from the corner of the cell, it automatically adds further numbers.
This is a good thing in most cases. But if you don’t like the default or standard action, then you have a problem. To solve this issue, there is RIGHT DRAG DROP.
Press the RIGHT mouse button while dragging
That is called Right Drag (Drop). So what is the big deal? What benefits do you get?
Right Drag Drop shows you all the actions available
Here is what happens if you right drag drop a file… The item in bold tells you what is the default action.
Right drag a number in Excel
Right drag a shape in PowerPoint
Right drag a mail from Inbox and drop it into Task folder
The list is endless…
Simple rule: Try right drag drop and learn more
This book explains how the Ribbon is an empowerment rather than a disappointment. Office Ribbon was introduced around for 7 years. Still most of us are still not comfortable with it. Some of us hate it actively, most of us just settle for a compromise.
View details on Amazon Kindle bookstore. Only available on Kindle platform.
USD 5 (INR 307).
If you don’t have a Kindle device you can still read it by downloading free Kindle Reader Apps for Windows PC/ Mac, Android, Windows Phone, BlackBerry, iPhone or iPad devices.
- Ribbon is good for you.
- Read each tooltip in each tab to learn more about great features which you may be ignoring
- Add commonly used buttons which don’t have keyboard shortcuts to Quick Access Toolbar (QAT)
- Add buttons which you need but are not available in the Ribbon to the QAT
- First 9 buttons get automatic shortcuts Alt 1 to Alt 9
- Therefore, arrange the most useful 9 buttons in QAT at first 9 positions
- Create Custom Ribbon and Custom QAT as per your needs
- Commonly used buttons go into QAT. Activity related buttons go into custom Ribbon tabs
- The File menu now occupies the full screen for a purpose. Explore all options there and you will be surprised how much you were missing out on.
- Quick Print button can be activated by using the dropdown next to the QAT
- You must share your customization with your colleagues using Export / Import feature
- IT can deploy pre-customized ribbon automatically using a login script and group policy
- Sometimes, you need to create a custom ribbon for a specific document.
- Such documents, if commonly reused, should be stored as templates.
- Templates can be shared using email (not recommended), SharePoint + Group Policy or SharePoint Content Types
- Download interactive command guides. These help you find old commands in the new UI.
Features NOT mentioned in the book
Specially for followers of this blog
Double click works with some buttons
Try using it on Format Painter and Highlighter. Double clicking allows you to use the button repeatedly – it remains in the same ‘Mode’.
For example, if you want to copy formatting from one shape and apply it to multiple shapes (even across slides) – this is how you do it.
- Select the original shape from where you want to copy the formatting.
- Double click on Format Painter.
- Now the mouse cursor changes.
- Now click on one or more shapes.
- You can change to another slide, still it is in Format Painter mode.
- When you finish, press Escape.
Double click DOES NOT work with shapes
This is unfortunate because we do need to draw multiple shapes of the same type quite often. But don’t worry. Right click on the shape and choose Lock Drawing Mode.
Now you can draw multiple shapes of the same type without clicking on the shape icon repeatedly.
I will cover what I learnt while creating and publishing the Kindle Book.