Did you know: You can change all the menus in Office?

image I am amazed to see how many people don’t know this.Do you wish Insert menu had Insert Comment option?

Don’t wish. Do it.
Create new tabs or modify existing ones. Share it with your colleagues.

Powerful, useful and delightful!

Estimated reading time 5 min

Continue reading

How to create a formal document in Word?

This is the last article in the series on Word Sections. You must read these articles to follow the concepts explained in this article.

Be stylish – Use Word Styles
Unknown but extremely useful: SECTIONs in Word
Word Sections – Part 2 – Partial Multiple Columns
Word Sections – Part 3 – Headers and Footers

What is a formal document? It contains a title page, table of contents and the actual content. Page numbers start only from the actual content. Numbers start with 1. But the page number is not shown on the first page. We will see how to create such a document template in this article.

image

Continue reading

Green Marks Part 2: Formulas showing wrong results!

Green mark in top left corner of Excel cells is an indication that something is wrong with the data you see. Read this article first to understand the concept: Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!

In this article, we will discuss the most important and potentially dangerous error which is commonly ignored. Read on and share it with as many people as you can.

image

Continue reading

Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!

I am sure we see these everyday across almost all Excel files. But do you know the meaning and significance of these green marks?

These are WARNINGS – it is Excel’s way of telling you NOT to trust what you see. Billions of people are ignoring these green marks for over a decade. If you are one of them, please read this article and share it with everyone who matters to you.

image

Continue reading

How to Copy Paste efficiently – Part 1

image

These are the SECOND most commonly used keyboard shortcuts across Office tools. But it never works exactly the way you want. I could not find any detailed and easy to understand explanation about various ways of copy pasting. Hence I am starting with this series.

If you are in a hurry, just read the Summary at the bottom.

Guess what is the MOST COMMON shortcut used?

image

Yes. UNDO is the most common action performed by ONE BILLION people everyday!
I am sure you also use UNDO everyday – without realizing one very disturbing and demeaning fact.

Why do you need to use UNDO so often? If you did something by mistake and then used UNDO, it is fine.

But usually, you use UNDO because you wanted something to happen and then something else happened. You don’t want it that way. Therefore you press UNDO. But what you originally wanted is still not done. You will now get that done in some other manual, round-about way.

So think again… what is that UNDO telling you?

“Undo means you don’t know how to do.”

So here is a simple way of improving your efficiency. Every time you are about to press Ctrl Z… STOP there. And think a little. What can I do differently so that I will get what I want. This way I will ELIMINATE the need for UNDO in that context next time onwards.

Every UNDO is a learning opportunity!

The most common reason why we need to UNDO is COPY PASTE gone wrong.

Therefore, we will discuss copy paste in detail in this series of articles.

The concept

We copy SOMETHING from SOMEWHERE and paste it SOMEWHERE ELSE.

image

Copying is easy. Whatever is selected is copied and put in the clipboard. But what about Pasting at the destination? There could be many ways of pasting it.

image

Depending upon the content and your needs, various formats may be used for pasting. Common formats are text only, picture, grid and so on.

The problem is when you press CTRL V to paste, which format should Microsoft apply by default. Microsoft finds out the most commonly desired format by surveying users and that becomes the default.

For example, if you copy any Excel data and Paste it into PowerPoint, the default format is a TABLE. Why so?

Because Excel is anyway like a huge grid (table) and PowerPoint does not understand Excel format but it understands what a Table is. Therefore, that is the default.

What if you don’t like the default paste format?

No problem. Microsoft has already thought about it. That is why there is PASTE SPECIAL.

image

It shows all the available formats for pasting – including the default.

The wrong way… which incidentally the most common way!

image

The right way…

image

Microsoft realized that this inefficient behavior is rampant and is leading to inefficiency. So they provided another solution…

After the default paste, one small little icon appears automatically and hopes to attract your attention.

image

It did attract attention but in the wrong way. Everyone hates it. Nobody knows why such icons appear in the first place. In fact it it difficult to get rid of them. They just linger around irritating you even more!

Let me vocalize what that icon is trying to tell the world…

image

When you click on it (or press imagekey) it shows you most of the options which you get in Paste Special. You can then choose the one you want.

In fact, to help you choose the right option, you just move your mouse cursor over each option. It temporarily pastes it in that format and shows you the result visually. If you don’t like it, move to the next one. When you find the desired one, click on it. (In case you are interested – this is called Paste Preview)

image

Unfortunately, most of us never noticed this great feature and therefore, never benefited from it.

Notice the keyboard shortcuts as well. Even in today’s TOUCH world, keyboard shortcuts are the most efficient way of working. So if you wanted Keep Source Formatting… notice that (K)

You could have directly pressed image

Microsoft still continued its effort to make our lives easier. Since 2010 onwards, they modified the Right Click menu to add all the Paste Options in it – complete with the live preview.

image

 

Summary


If you want to copy paste in the most efficient way… here is the right method.

image

While choosing formats, notice the keyboard shortcuts and start using them for even more efficient and accurate copy paste.

In the next article we will cover nuances of various pasting formats – Paste Sepcial – Deep Dive for Excel.