The file menu is back! Welcome to Office 2010

So if you are a bit of an Office freak like me, you will know that Office 2010 was RTM’d last week (Released to Manufacturing – a fancy way of saying “yep, its ready”).  It will be available in the shops in the next few months, but if you are a corporate customer with a volume licensing agreement – or you have a subscription to MSDN or TechNet – you will find you can get the Office 2010 bits, and product keys already.

With RTM comes a shift in content here at The New Paperclip.  Whilst I will still produce Office 2007 content, there is a whole new world of Office 2010 that is to be explored, documented, and published in easy to understand language just for you kind folks!

Before we get into the nitty gritty of Office 2010 – there is one thing I would love to share with you.

One thing that most of you will like (and people that work on IT Helpdesks will LOVE) about Office 2010 is that the File Menu is back!  Well, technically it never left, but in Office 2007 it wasn’t called the File Menu, it was simply this weird looking “Office Orb”. 

So IT Managers – if you are looking for a quick win to cut your helpdesk calls dramatically (you know… all the ones that were like “Where has Print gone”, Where has Save gone” etc) – just upgrade to Office 2010.  Because everyone knows, you find them in the File Menu.  And you will not get as many calls about

“What is that funny looking circle thing… what do you mean you want me to click on it?  It doesn’t look like a button!”

If you are upgrading to Office 2010 – make sure you subscribe or check back regularly for more tips, tricks and tutorials.

‘till next time!

First Look Microsoft Office 2010: Free e-Book from Microsoft Press

Hi there!

Are you on the bleeding edge and have already had a play around with the beta version of Microsoft Office 2010?  Or are you just interested in what is coming in the next version of your favourite productivity tool?  Well do we have a great link for you today!

Our friends over at Microsoft Press have released a few electronic version of the book – “First Look Microsoft Office 2010”.  14 chapters of Office 2010 gold, including:

  • Welcome to Office 2010
  • Express Yourself Effectively and Efficiently
  • Collaborate in the Office and Around the World
  • Create and Share Compelling Documents with Word 2010
  • Create Smart Data Insights with Excel 2010
  • Manage Rich Communications with Outlook 2010
  • Produce Dynamic Presentations with PowerPoint 2010
  • Organize, Store, and Share Ideas with OneNote 2010
  • Collaborate Effectively with SharePoint Workspace 2010
  • Create Effective Marketing Materials with Publisher 2010
  • Make Sense of Your Data with Access 2010
  • Putting It All Together
  • Security in Office 2010
  • Training Made Easy

You can read the Microsoft Press blog post – or just click here and download the book directly.  It is about 10.5mb or so.

‘till next time!

Put a Screenshot in a Word 2010 document

Hey if you have upgraded to Office 2010, you might have noticed an unreal new feature which allows you to very quickly paste a screenshot into your Word 2010 documents, Excel 2010 workbooks, or PowerPoint 2010 decks!

Here is how!

  1. Open up your Word 2010 document
  2. Click on the “Insert tab” in the Word 2010 ribbon
  3. Look for the “Illustrations” group
  4. Click on “Screenshot”

Once you click on “Screenshot, you have two options.  The first is to simply paste in the screenshots that Word 2010 has already taken for you!  For example, if you have four different applications open, Word has figured out that you might want a screenshot of one of those applications – and simply lets you pick which one you want to use (very smart!).  All you have to do is click on the screenshot you want to use!

The second is to take a screen clipping – which allows you very fine control over which part of your screen you want to take a screen shot of.  Simply click on “Screen Clipping” and then drag your mouse to select your screenshot.

Either way, getting screenshots into Word, Excel, and PowerPoint 2010 just became a whole lot easier!

‘till next time!

Start Outlook 2007 or Outlook 2010 automatically

If you are like me, or anyone else that I work with, in fact if you are anyone in business today – chances are you use Outlook EVERY DAY!

And if you are like 99% of the population, you will double click on that Outlook icon every morning to open it.  Talk about wasting time! 

Did you know that we can automate things so Outlook will automatically start whenever you log into your computer. 

All you need to do is find the “Startup” folder in your Windows XP, Windows Vista, or Windows 7 start menu.  Once you have found it, simply drag the Outlook icon into that folder.

Actually this works with any program, not just Outlook.  So if you want to automatically start Word, Excel, PowerPoint, Internet Explorer… in fact any application on your computer – just drag the icon into the Startup folder.

So there you have it – one less thing for you to do in the morning!

‘till next time!

Count the number of blank Cells in Excel

Are you building a spreadsheet and would like to know how many black cells you have in a given range in an Excel 2007, Excel 2010 or Excel 2013 workbook?

There is a great function in Excel that you can use to do exactly that – count the number of BLANK cells in a range.

Simply type…


(replace range with the range of cells you want to limit your count to).

Note that there is one particular thing that might slip you up with this function.  When using =COUNTBLANK(), Excel is only searching for blank, empty cells.  If you have a space in a cell for example – it might look empty to you, but Excel can see that there is a space – which means it will not think it is blank, and not count it.

‘till next time!

How to undo in Word 2010

So you have upgraded to Word 2010!  If you have made the leap from Office 2003 or earlier, you might have a few challenges finding some of the features you use regularly.  One of those great features is Undo!  (I think Undo is the feature I use the most!)

To undo in Word 2010, you can either do it using your mouse, or using some shortcut keys.

To undo using your mouse in Word 2010:

  • Look towards the top left hand corner of your Word 2010 window.  Just above the office button you will see a number of small icons along the top of the screen (by the way – that is called the “Quick Access Toolbar”).  Click on the one that looks like an arrow that points backwards – that is the undo button. 
  • If you want to undo more than one mistake action – click on the little down arrow beside that button, and it will give you a list of actions you can undo!

To undo using shortcut keys in Word 2010:

  • Simply hold down the “CTRL” key, and press “z” (CTRL+Z)
  • To undo more than once, just keep pressing CTRL+Z

So there you have it – the easy way to get rid of your mistakes in Word 2010! 🙂

‘till next time!

(PS. try this article if you are looking to undo in Word 2007)