This also applies to Office 2007 and 2010. Based on my original post Feb 2004 relating to Office 2003 and prior.
Most people know how to use copy and paste in Office. Or do they? Right click a selected item(s) and copy, then right click the destination and paste.
That is definitely the slow way. Keyboard people know about Ctrl+C and Ctrl+V for Copy and Paste. (or CTRL+Insert / Shift +Insert)
New Office, (2007, 2010, 2013) uses the Paste button in the ribbon to provide access (though there is still keyboard access with ALT+E+S).
Once you have something in the clipboard with the copy command, clicking the little arrow below Paste Icon in the ribbon gives you a lot more options. Each office application is slightly different as to what you get.
Word has less options than Excel. Powerpoint and Outlook, Live Writer and Publisher etc. all use this feature differently. However each of them allow you to strip metadata (formatting etc.) from the actual text and just paste the text. This extremely useful when copying text from a web page, PDF file or some other heavily formatted document.
And clicking the Paste Special link at the bottom brings up the traditional dialog box.
Ill take you through the main ones for Excel.
You can also combine options from each section as per the example below.
I got this in an email from Microsoft today – © 2010 Microsoft Corporation.
Microsoft Office 2010 has been officially released. This latest version offers flexible and powerful new ways to deliver your best work—at the office, at home, or at school.
With Microsoft Office Home and Student 2010 you get four great tools for family projects and schoolwork: Microsoft Word 2010, Excel 2010, PowerPoint 2010, and OneNote 2010 — all with new features! Buy it now.
How to articles, tips and more
Download: Keep track of the World Cup with this template
Having trouble keeping track of your favorite team in the World Cup? Use this handy Excel template to follow all the standings in the 2010 World Cup.
Office twenty-ten (the correct way of saying it) has some awesome new features over Office 2003 and 2007.
Joseph Chirilov has been busy writing (and geting guest writers to write) articles about both the upcoming changes in Excel 2010 as well as a series on using sparklines in Excel 2007 and 2010. Sparklines are mini in-line charts that can graphically display data in a very small space.
Mine did. Today. Very frustrating as was trying to produce quotes.
After looking into templates, trying to replace images with another image, trying a second pc with the same problem, and then when i tried a third pc with the same document but a different user and it was fine, I started to panic my profile was screwed up in some way.
I Googled it and found this page on the first hit.
The answer was very simply:
Click the Office orb on LH side and then in the main main drop-down click Word Options at the bottom.
Click the Advanced Tab
Under the Show Document Content section untick the "Show picture placeholders (tickbox)
Fixed – whew!