OneNote linked notes are easy to create.
But how do you manage these linked notes later?
Here is an easy way to do it.
Estimated reading time 3 min
OneNote linked notes are easy to create.
But how do you manage these linked notes later?
Here is an easy way to do it.
Estimated reading time 3 min
Our Copy Paste series is not yet over. But I am starting another one based upon feedback from readers. In this series, I will cover common problems and solutions, starting with perhaps one of the most common irritant: Text and Picture layout problems in Word.
There are already many such sites for quick troubleshooting or Tips and Tricks. That is like spoon-feeding. This blog is not a quick fix.
Therefore, after giving the immediate solution, I will also explain the concept behind it and related features. This way, you learn something specific as well as something larger and generic. It amplifies the benefit and makes you more capable and confident.
When you insert a picture which is smaller than the width of the document it just stays there and space around it is wasted. If you type something before it, the picture moves. Very irritating! You want the text to wrap around nicely.
If you realize that you need to set the Square option often, click on the last option Set as Default Layout. Now onwards, when you insert a picture, the desired layout is applied automatically.
Look at the dropdown.
First option is treat the Image as text.
Next section (from Square, Tight, Through, Top and Bottom ) controls how the text wraps around the text.
The third section (Behind or In Front) decides the object position with respect to the text. Behind text is like having a paper on which you put a sticker and then printed the text on it. In Front of text is like you printed the text and then put a sticker on top of it.
More options of course give you more sophisticated options. If you need to do precise arrangements in layouts like newsletters, professional reports, case studies, brochures – you must know every option there. You will be surprised to know how sophisticated it is.
Final option is obvious. If you have changed the settings and you like them, then set those as the default.
Post your answers as comments to this blog.
First right answer will get the gift voucher by mail.
Please mention your email id in the reply.
You can redeem it against any Amazon.Com purchase. It never expires.
Quiz closes on 11:59 PM, 19th November 2013 Indian Standard Time.
Copy paste goes wrong often while working with multiple word documents. Here is how to get it right – every time.
If the answer is NO, then we need a quick primer. If you already use styles, skip this section. Remember one general rule about using Office efficiently.
Sounds funny? It is not. Read on …
When we create Word documents, there is regular content and then there are topics and subtopics (headings or sub-headings). We usually format these topics manually to make them look prominent. That is a complete waste of time. That is what I call “we are trying to help Word”. Why? Because we think it is not capable of understanding what we want.
Trust me – just expect a little more from Word (and Office). You have no idea how much effort has gone into creating the product. Even the smallest and rarest inconvenience is taken care of.
To cut a long story short, just type the heading and click Heading 1 in the Styles dropdown in Home tab.
There are up to 9 levels of headings. If you use styles you get many benefits like automatic navigation pane, table of contents, automatic numbering, ability to rearrange document just with drag drop of headings, ability to create a presentation automatically and so on. I will write a separate series on Styles.
Word works like this. There is the copied content (from source) and the destination where you are pasting it. If there is no style used in either, then it keeps the source formatting. If styles are used, it tries to merge the styles.
Now if you select and copy something from source to destination – what do you expect? It should adjust to the blue surroundings. Unfortunately, the default is – Keep Source Formatting. Therefore, this is what happens.
The answer is obvious if you have read the Copy Paste series of articles.
If not, notice that small little icon. Click on it.
Merge Formatting merges the paragraph level formatting and keeps the character level formatting (Bold, Italic, etc is applied and remembered at character level).
Choosing Keep Text Only (A) achieves the desired effect because it only pastes the raw text so that the local formatting is fully applied.
This is how it works – even across documents where styles are not used.
Remember that you can use the keyboard shortcut CTRL T.
This is relevant only while copy-pasting across different documents.
If source style is different than destination style, then the default option is
Use Destination Style. The logic is simple – the pasted text looks uniform.
The source Heading 1 style (brown) was adjusted to match
the destination Heading 1 style (blue). Notice that the formatting manually applied to the paragraph was retained. You will have to handle that separately.
If you want you can choose other options Keep Source Styles, Merge Formatting, Keep Text Only. But in case of style conflict, the default option works best.
Word is a very sophisticated word-processor. Therefore, it provides very granular control over copy paste. Click the Set Default Paste… option and see for yourself.
There are four possible options. You can change the settings independently. I suggest that you try changing the first two options to Keep Text Only if you do lot of cross-document copy paste without using styles. The third and fourth option defaults are usually appropriate.
Try how it impacts your copy paste effectiveness. If it is not satisfactory, you can tweak the settings as required.
I have not checked this personally. But I think you can set these defaults using group policy for Office 2013. Yes. In case you have not noticed it, Office has been providing full Group Policy integration using ADM files since 2003. High time you explored and used it to improve efficiency. Will write an article about it later.
Most common ways of invoking Paste Special are:
Although all these methods work, Microsoft added a NEW shortcut since Office 2007. Most people don’t discover it. The shortcut is
The reason is simple. Paste Special is a variation of Paste. Paste shortcut is CTRL V. For Paste Special CTRL ALT V is more intuitive. It is definitely better than using mouse anyway.
But there is more to it.
Compare the actual act of pressing the older shortcut –
On the fact of it, there are three keys to be pressed in either case. So what is the difference?
Let me show you the difference using a keyboard layout.
You try pressing Alt E S using left hand and see the position of fingers.
Now compare it with CTRL V and CTRL ALT V
Usually we press CTRL key using little finger and V using index finger. The middle finger is anyway resting near ALT key. Look at the photo on left side – I have intentionally flexed the middle finger to expose the Alt key.
You just have to decide is it Paste or Paste Special at the last moment. If it is paste, don’t press the middle finger, if it is paste special – just press the middle finger (right side photo)
Another alternative is little finger for Ctrl, Index finger for V and thumb for Alt – which is also convenient. You try it out yourself and choose the method which is most comfortable to you.
This is ergonomics!
Imagine the amount of effort the Office team is taking to make our life easier and healthier… it is just that we simply don’t notice these things and therefore are not able to utilize the products effectively.
It does not work for OneNote because OneNote does not have Paste Special functionality at all. It does not mean that you cannot choose the paste format in OneNote. It does offer four paste options as expected:
In that case, the question is – why did Microsoft not choose a default format for paste and provide Paste Special in OneNote (like all other products)? Just to avoid a Paste Special dialog? That does not sound like a good reason.
This is my guess but I think that is the logical explanation.
The reason OneNote does not have two separate options – Paste and Paste Special – because :
Although the Copy Paste series is far from over, I will deviate from it and show you how to find useful keyboard shortcuts and reduce the damage to your wrist and tendons (which can happen due to excessive usage of mouse, among other things).
We often write in the order in which it comes to our mind. We then tend to reorder content by copy pasting it. There is a better method.
Just remember these very powerful shortcuts
Whenever you write content or text with paragraphs, in any Office product, you can use the Shift Alt Up and Down arrows to move it up or down.
This works with:
This is even more powerful.
In case of Word, by pressing Shift Alt Left arrow, you actually promote the heading style – or apply Heading1 Style.
If you use Shift Alt Right arrow, it demotes the style (and outline level)
This is the fastest way of creating documents with styles. No need to click on styles or use keyboard shortcuts which are more complex (Ctrl Alt 1 2 or 3).
Like Word, it can be used for promoting and demoting bullets.
Usually to create sub-level bullets we use TAB key. But that works just after a fresh new bullet is added. If you are somewhere in the middle of a paragraph, pressing TAB key will actually insert a tab and increase spacing.
However, Shift Alt Left / Right arrows work irrespective of where your cursor is.
Now the most powerful usage in PowerPoint is to edit hierarchical information in SmartArt Editor. Try to insert a SmartArt of type – Hierarchy – choose some Org Chart and then go to the editor. You can easily promote or demote items very quickly using this shortcut key.
In the earlier post, we saw how to get up to 24 clipboards. But why would you need so many of them?
On the face of it, this sounds like an overkill. We are happily using ONE clipboard for years. So it is looks like a useless feature.
This is a very important thing to remember. Adding a feature is a very complex and costly process. Microsoft is not going to add a new feature if it was not serving any purpose.
Those of you who understand programming know that behind every feature there is a need, a problem or a use case. Unfortunately, when you use a product developed by someone else, the feature is visible first and the underlying need may not be apparent.
So what do we do? We do it in two steps.
First, we learn the functionality – what does it do? In this case we already know that. At this stage you know the technical feature. But that is NOT called knowledge. That is partial knowledge.
The next step is more important. You must find the underlying need or problem it is trying to address. Why do you care? Simple! Because it may be your need. If you do not discover the need, you may never use the feature in spite of understanding how it works technically.
Of course, there may will be features which you do not need in your current context. But in any case, if you know when they are useful, you will be able to use them if the need arises in future.
Executive Summary contains key sentences which summarize details from the document. We write Executive Summary AFTER the rest of the document is created. Here is how you can do it faster.
Very often we get tabular data from multiple files or sheets (regions, locations, months,etc). How do you combine this into a single master data sheet?
Copy – Paste to Master, Copy – Paste to Master, Copy – Paste to Master and so on.
Now you know what to do
This is a very powerful method. Let us say you are browsing for various products and you want to capture many images and put them on one slide. Another scenario would be logos of your customers.
Here is how you do it.
If you find more scenarios, please post them here. I will also learn something new.
There is more to copy paste and the series is not ending any time soon. But I am sure you want some variation. So next article will be something different. We will continue the Copy Paste series later.
All of us know that there is only ONE clipboard. WRONG! There are actually 24 clipboards if you use Word, Excel or PowerPoint.
When you copy something, whatever was already there in the clipboard gets overwritten. If you want to change that behavior you must activate these 24 clipboards.
It is simpler than you think. Just click on that unseen, unnoticed yet extremely powerful arrow at the corner. Technically these guys are called Dialog Launchers. Why? Because these activate the dialog related to the name written next to it.
Just click on it and a new pane (docked window) will open on the left side of the application.
This shows the clipboard contents. If the clipboard has something in it, it will be shown. If not, the pane will be empty.
Now onwards, whenever you copy something, it will accumulate – it will NOT overwrite the existing clipboard.
Whenever you copy, notice what happens at the bottom right side of the screen – it shows you a small popup which counts how many clipboards are colledted (1 of 24, 7 of 24 and so on).
Some kind of copying cannot be added to the clipboard – like copying files. In that case the popup will indicate the problem.
There are a few options. I will discuss these options in the next articles. But why don’t you figure it out yourself, in the mean time.
I will also show you practical usage scenarios of this powerful feature.
Before you ask, it has been there for many years. It is just that nobody noticed it – like thousands of others!
Writing this blog sitting under this beautiful Auckland Sky Tower… Lovely weather.
We want to avoid such trouble during a presentation. Therefore, we try to solve the problem by trying to copy pasting the raw data into PowerPoint. Unfortunately, large amount of data cannot fit into the limited space available on the slide.
This is not really a limitation of PowerPoint. It is just that you are using the wrong approach. Here is the correct way…
When you suspect that someone may question you on your summary data, you need to be prepared. How do you do that? You already know.
First step is to get the context of the original file into the slide.
Use Paste Link, Embed or Insert Object
In either case, WHILE EDITING the presentation, you can write click on the pasted object and open the Excel file. What we really want is to have the same ability DURING THE PRESENTATION.
To understand how it is done, we need a small detour.
I will cover this in detail in another article. But here is the shorter version.
A presentation contains slides. Each slide has various shapes and objects on it. When you run the presentation – PowerPoint shows the first slide and waits. When you click it goes to next slide … again waits … then you click – next slide … and so on till you end the presentation.
Is this a problem in word as well?
The CLICK is called the TRIGGER and MOVING TO NEXT SLIDE is the ACTION. In our case when we click on the slide containing the summary data, it simply goes to the next slide. If you right click, the menu now shows presentation related controls. The open worksheet command is missing.
This is the time we change the default behavior of PowerPoint and ask it perform a DIFFERENT ACTION when we click on the Summary object. How to do that?
Now run the presentation and see what happens. On this slide, if you click anywhere outside the Excel data, it will just go the new slide as expected.
However when you move the mouse cursor over the Excel data, the cursor shape changes to indicate that it is a hyperlink. Click on it to open the Excel file.
Show the details and then press ALT TAB to come back to the presentation. It is still running undisturbed.
Although this method works with inserted objects, there is a practical problem there. In fact there is a psychological problem.
What is the problem?
Inserted Object is shown as an icon. Therefore, your audience knows that you have a collateral file. So even if they have no reason to trouble you, they may just ask you to show the file. You don’t want that to happen. Why ask for unnecessary trouble?
We will handle that interesting situation in the next article.
Insert Object embeds an existing file or new file into your document. In that sense it is like Embedding – which we discussed in the previous post. So what is the difference?
The starting point is different. In case of Embedding we first open the source document, highlight some portion of it and then paste it into destination while choosing EMBED option.
In case of Insert Object, we first go to the destination and then choose the ENTIRE FILE to be embedded. Therefore, we do not get any control over which part of the inserted file will be shown after it is added to the destination.
If you choose an existing Excel file and Insert it into PowerPoint it tries to show the contents of the Excel file in PowerPoint. Excel file can contain many worksheets. Which worksheet to show? PowerPoint does not know that because we never mentioned that – we just selected the file to insert. Therefore, PowerPoint shows you the contents of the sheet which was active when the Excel file was closed the last time.
If this sheet happens to have large amount of data, the Insert Object command may take a very long time to complete and the results will be very deplorable.
The solution is simple. We just need to specify that there is no need to show anything from the inserted file. Just show it as an icon. That option is shown in the Insert Object dialog itself :
Now the Inserted file looks like this.
It is a good idea to change that default description to something more business context specific. Click on change icon and change the title. Also note that there are many icons available. Choose the one which suits the content type.
File size does increase as much as the original size of the file. While embedding files, make sure you are choosing the new file formats. If you embed older formats (XLS, PPT, DOC), the file size will be much larger.
Note that you can use any file in the Insert Object dialog. It need not be Office document. It could be any type of document.
The default size of the icon is very small. If required, you must manually increase the size of the icon to make it visible during the presentation.
Remember, if you make the icon visible enough, you are also taking a risk. Anyone from audience may ask you to show the contents of the file and then you must do so.
In fact that is the topic of our next article:
You are presenting some summarized data – say – sales performance by month
Do you want an easier solution?
Now that we know Paste Link, Embed and Insert Object, there is an easy solution. If you think you may have to show details during the presentation, use one of these approaches to make sure that you have the file either linked or embedded.
Now the question is – how to tell PowerPoint to open the file – ON DEMAND?
That is what we will discuss in the next article.
In the previous post, we saw how linking of files works. Now let us understand what Embedding means. We will continue with the same scenario of embedding an Excel File in PowerPoint. However, this concept would work across all Office applications.
You have copied some data from Excel. Now you paste it into PowerPoint and choose the EMBED option.
It is still showing the Excel range you copied. It behaves like a picture if you try to resize it. But it actually made a copy of the ENTIRE EXCEL FILE and stuffed it into your PowerPoint presentation.
If the original Excel file was, say, 20 MB in size, the presentation size will also grow by 20 MB.
If you want to package the Excel file with PowerPoint presentation, then this is the best option. The benefit is, you can still show specific summary data on the slide.
If you want to send the presentation with collaterals – this is the best way.
While editing the presentation, just right click on the object – Choose Worksheet Object and Select Open.
DO NOT choose EDIT. If you do, it tries to give you Excel editing capabilities in the small area in which you have pasted the data. The ribbon automatically changes to Excel options rather than PowerPoint options. This is called in-place editing. But most people get confused with it. If you want to expand the range of selection, this is a good option to use.
In either case, the Excel file which it opens is NOT the original file. It will have a name like worksheet in Presentation3. This file now lives inside the presentation (in geek language, it is called OLE File System).
For any reason, if you feel that you should not have embedded the file, how to manage the situation? I am sure you will know this answer if you have read all the Copy Paste Series posts.
Copy the Embedded object, Paste it as Picture and delete the original embedded object!
We will explore the Insert Object feature in the next post. It is similar to Embed but with a small difference. In fact Insert Object and Embed are interchangeable!