Banner

Archive for the ‘Level 300 - Advanced’ Category



Center Across Selection - the Merge and Center alternative in Excel 2007

Icon Written by The New Paperclip on April 15, 2008 – 8:30 pm

Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, rows, or both.
Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection".  It’s just […]



Turn off the mini toolbar in Excel 2007

Icon Written by The New Paperclip on April 14, 2008 – 8:24 pm

Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu.  You know the one, it lets you change the font, the font size, the font colour and a lot more.
Some people think it is great.  Some people think it is annoying.
I think it is great, but […]



Increase/Decrease AutoRecover Frequency in Word 2007

Icon Written by The New Paperclip on April 14, 2008 – 8:10 pm

How many times have you lost everything in your document?  Word crashed?  Maybe the power went out?  Whatever it was that happened… I bet it happened just before you were going to save, right?
By default, Word 2007 makes an Auto Recover save every 10 minutes.  But if you are clumsy like me, or don’t trust […]



Turn off the mini toolbar in Word 2007

Icon Written by The New Paperclip on April 14, 2008 – 7:50 pm

Have you ever noticed if you select some text in Microsoft Word 2007 you get a little pop-up menu.  You know the one, it lets you change the font, the font size, the font colour and a lot more.
Some people think it is great.  Some people think it is annoying.
I think it is great, but […]



Change the angle or orientation of text in Excel 2007

Icon Written by The New Paperclip on August 19, 2007 – 4:36 pm

Have you ever seen those spreadsheets or charts where the text isn’t normal?  You know the ones where the text is diagonal, or vertical, or on its side?  It is a pretty nifty trick you can use to display more information in less space.  And in Excel 2007 it is really easy to do.
How to […]



Email Merge in Word 2007

Icon Written by The New Paperclip on June 8, 2007 – 10:15 pm

Do you have a message that you want to send to multiple contacts, but you don’t want to do the old BCC trick?  Better yet… do you want to actually personalise the message for each recipient? 
Instead of “Hi all”, what about “Hi Bill”, “Hi Jane” etc?
You can, with email merge in Word 2007.
Email merge works […]



Change the Duration and Transparency of Email Notifications in Outlook 2007

Icon Written by The New Paperclip on June 4, 2007 – 10:46 pm

Here is a quick way to control how the pop up email notification (you might know it as the desktop alert, or toast) acts and looks in Outlook 2007.

Got to Tools, then Options in the menu
On the preferences tab, in the E-mail section click on the “E-mail Options…” button
Then click on the “Advanced E-mail Options…” button
Then click […]



Turn On or Off New Email Notifications in Outlook 2007

Icon Written by The New Paperclip on June 4, 2007 – 10:32 pm

Some people like them… some people hate them.  That’s right, we are talking about new email notifications.  It doesn’t matter what you call them… the popup thing in the bottom right hand corner… the envelope down the bottom beside the time… the toast… some people love them, and some people hate them.
How to turn on […]



Insert a Drop Cap in Word 2007

Icon Written by The New Paperclip on May 4, 2007 – 7:15 pm

Have you ever read a book, or a fancy brochure and noticed that the first letter of a chapter is really big (and goes across a few lines) and the rest of the text looks normal?  That is called a “Drop Cap”, and you can insert one really easily in Word 2007.
How do I insert a […]



Do you have Office 2007 Questions? Get the answers at The New Paperclip forums - now ONLINE!

Icon Written by The New Paperclip on March 14, 2007 – 11:02 pm

Ask your Office 2007 questions at The New Paperclip Forums - http://forums.thenewpaperclip.com
Do you have questions about Word 2007, Excel 2007 or Outlook 2007, but don’t know who to ask?  Are you stumped by something in Access 2007, OneNote 2007, or Visio 2007?  Do you know what to do with SharePoint Designer 2007, Publisher 2007, Groove […]