the MOST

McCombs Office Solutions and Tips

Entries Tagged as 'Office 2007'

Clip Art

November 5th, 2009 · Filed under: Excel · Images · Office 2007 · Outlook · PowerPoint · Word

Posted by Jeff Hauger

We always look for good images. Pictures tell a thousand words, making them ideal additions to blog posts, class projects, presentations, emails, and other social media applications. Fortunately, Microsoft drastically improved their Clip Art galleries in the last several years, adding thousands of high quality photographs.  Using Microsoft’s Clip Art galleries while connected to the [...]

[Read more →]

Tags: ·

Turn an Email into a Calendar Appointment

October 29th, 2009 · Filed under: Office 2007 · Outlook

Posted by Holly Green

So often, appointments are scheduled through email.  I find that I often want the text of an email to be in the body of my appointment.  That way, when my reminder goes off, and I have no idea what the appointment is about, I can click Open Item, and see the details.  But copying and pasting the contents of an [...]

[Read more →]

Tags:

Keep Track of Your Day with the To-Do Bar

October 22nd, 2009 · Filed under: Office 2007 · Outlook

Posted by Holly Green

The To-Do Bar is possibly my favorite addition to Outlook 2007.  It appears on the right side of Outlook, helps me keep track of my day by showing a small monthly calendar called the Date Navigator, my next several calendar appointments, and my Tasks list.  Thanks to the To-Do Bar I’m never caught by surprise by a meeting [...]

[Read more →]

Tags:

Select Cells and Navigate in Excel Using Keyboard Shortcuts

September 15th, 2009 · Filed under: Excel · Keyboard Shortcuts · Office 2007

Posted by Holly Green

In Excel 2003 and earlier versions, when I tried to select a large block of data using my mouse, I would often overshoot, and accidentally select more rows than I meant to.  Then I would go back, and select too few.  I often had the same problem scrolling within a spreadsheet.  I would go too fast, [...]

[Read more →]

Tags:

Print Area and Print Selected Cells in Excel

September 10th, 2009 · Filed under: Excel · Office 2007

Posted by Holly Green

More than once I’ve talked to people who clicked the Print Preview button before printing an Excel worksheet that should fit on one or two pages, only to discover that 100+ pages were slated to print, and all but the first few were going to be blank.
In my experience, this usually happens because you have [...]

[Read more →]

Tags:

Get Started in Office 2007

September 2nd, 2009 · Filed under: Excel · Office 2007 · PowerPoint · Word

Posted by Holly Green

If you’ve ever looked at Office 2007, then you know that things have changed significantly.  Most people I talk to are frustrated when they first switch to Office 2007, because they don’t know where to find the tools they used in earlier versions of Office.  Microsoft has put together videos, demos, and interactive guides to help [...]

[Read more →]

Tags:

Repeat the Same Row on Every Printed Page

August 25th, 2009 · Filed under: Excel · Office 2007

Posted by Holly Green

When you need to print a spreadhseet that has too many rows to fit on one page, the information on the second page can lose meaning without the column headers.  The same thing can happen if you have more columns than can fit on a page.  Fortunately, Excel has a feature that allows you to [...]

[Read more →]

Tags:

Freeze Part of Your Word Doc

August 19th, 2009 · Filed under: Office 2007 · Word

Posted by Holly Green

The other day I was working on page five of a document, and really wished I could refer to something on page one.  Going to page one, and then going back to page five over and over gets old really fast.  Fortunately, you can use the Split feature in Word to view two different parts of [...]

[Read more →]

Tags:

Make PowerPoint Handouts in Word

July 9th, 2009 · Filed under: Office 2007 · PowerPoint · Word

Posted by Holly Green

Last semester a student came to my office with a problem I had not encountered before.  He needed to make PowerPoint handouts, but they had to be included as part of a document that was going to be bound.  Because part of the left side of the page would be hidden by the binding, he needed [...]

[Read more →]

Tags:

Are You Sure You Want to Send That? - Use the Document Inspector

July 2nd, 2009 · Filed under: Excel · Office 2007 · PowerPoint · Word

Posted by Holly Green

Your document tells people more about you than you think.  No, I’m not talking about when people look for double meanings in your words or calculate the average number of syllables you wrote to decide how smart you are.  There can be hidden information in your documents that a savvy user could access.
Office 2007 has a built-in tool, called the Document [...]

[Read more →]

Tags: