Repair unwanted Bold bullets

This is a common and frustrating problem. For some reason, only one bullet or numbering item becomes bold.


Wherever you click intuitively and press Ctrl B to solve it just does not work. Beginning, ending of the line or trying to select the number itself – the stubborn bold formatting remains there Devil


Here is the secret. Formatting about these things is stored in the paragraph marker. The marker is not usually seen. But you can see it if you enable hidden characters as shown below.

image    image

You do not have to make it visible, just select it by double clicking at the end of the line. You can also navigate to the end of the line and choose Shift + Right Arrow. Now, you should see the mini-toolbar automatically. Bold should be selected at this stage.


Click on the Bold button to remove the setting or press Ctrl B. That’s it. 

Problem solved!

Pivot Report Sharing

Here is a fast paced, 8 minute video which will revolutionize Pivot Report Sharing. Using OneDrive or SharePoint, control the visibility and provide full interactivity. Reports render instantly even with large files and low bandwidth.

Pivot Report Sharing articles

New, Improved way of delivering Excel reports: Part 1
New, Improved way of delivering Excel reports: Part 2
New, Improved way of publishing Excel reports: Part 3

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.


Continue reading Drop-down Gamification

SFB Mute Mic :Meeting Etiquette

Skype for Business meetings are quite common nowadays. These meetings can go on for a long time and have many participants. Everyone is not speaking at all times. Most people are on mute. But what about the person who is speaking? While speaking, suddenly, there is a noisy interruption – cough, sneeze, someone barging in and talking loudly, phone ringing, etc. Most participants are using headphones. Imagine being sneezed right into your ear. Excruciatingly disgusting.  So here is a shortcut you must remember Windows key and F4. It works even when Skype for Business is not the current application. It works irrespective of which application you are currently in – typically PowerPoint, Excel or whatever else. Practice pressing Windows + F4 several times to make it into an instant reflex action. This will prevent you from torturing the participants with unexpected loud sounds.
This video has no commentary. 14 sec.

If you mute and unmute too often, are you not worried about others hearing this muting sound? Do not worry. Other’s cannot hear the muting sound. It is just for you to hear so that you are sure that the Mute shortcut worked. Unmuting does not have a sound associated with it. Sometimes you may unmute and not realize that the mic is on. Avoid such a situation. How? If in doubt press Windows + F4 agian. If you were on mute, no sound will come. If your mic was ON, you will hear the mute sound. Now decide what you want to do

Another practical use for Windows + F4 is answering while on mute. When you ask a question to someone who is on mute, you will notice a significant delay before the answer comes. Why is that? Because the muted person may not have SFB as the active application. Alternatively, that person is viewing your presentation in full screen mode. In either case the Mic mute / unmute button is not immediately accessible. The delay in response is due to that person struggling to find the unmute button! Now, using Windows + F4 you can reply instantly.


SFB Etiquette: Do not talk when you join a meeting

Yes. Just keep quiet. Listen to what is being said. Assess when is the right point of time when you can make others aware that you are a part of the meeting. At the most opportune moment, interject and introduce yourself and participate in the discussion. Simple SFB Etiquette. Follow it.

Do you know what happens usually? People join at different points of time in an online Skype for Business meeting. The person joining has no clue about what is being discussed before the point of joining. Unfortunately, most people in the world think that the entire audience is waiting for them to announce their grand presence. Which is rarely the case!

Join as usual. Listen for some time. Get the hang of what is being discussed. Most people who are already in the SFB meeting will notice that you are added to the participant list. Even if they don’t, just give yourself some time to understand the context. If you are lucky, some stupid people who have already joined will talk some secret or gossip thinking that you are not around… enjoy the moment. Finally, when the time is right, you talk and introduce yourself. That’s it. Try it and let me know if it works. If you are the host of SFB meetings frequently, it may be a good idea to educate your participants about it…. by adding one extra line in the invitation itself:

“When you join, your microphone is automatically muted. Even if it is not, mute it. Listen to what is being said and then introduce your presence at the right point of time.”