Friday, April 29, 2011

Word 2007 Spacing Tip

Joe, of Aeroflex asks, "I have a Word 2007 document and I want to see the spacing above the first line at the top of each page.  Some of the pages show the space and some do not."
Thanks for your question Joe!

Yes, Word 2007 is a bit different than previous versions of Word and the best way to add spacing above the first line at the top of each page is to use Styles.

The styles are located on the "Home" tab.  Preset styles, such as Headers, will add spacing above the line.  If you do not like any of the preset styles, simply click on the drop down arrow (the very bottom on the scroll bar - it says "More" when you hover the mouse over it) and select "Apply Styles."

In the window that appears, you may select a style to base your new style on and then select the "Modify" button.

This takes you to the old window for Style Formatting.  Change any formatting you would like by clicking on the "Format" button at the bottom of the window.

Click "OK" until you return to the document and the new style will be added to the Style Gallery.

There is the possibility of using paragraph formatting as well.  I'll cover this in next week's email.

I hope this helps!
If you have a question, simply click here to send me your questions.  I'll post as many answers as I can in the following Tips e-mail.

Friday, April 15, 2011

Excel 2007 Watch Window

If you're like many Excel fanatics, you probably deal with large spreadsheets and multiple cells containing formulas.

Excel 2007 has a great new feature that lets you "watch" cell contents as they change.  If numbers are added, subtracted, and changed, these specific cells are probably something you'd have to remember to review in previous versions of Excel.

To turn on the "Watch Window," follow these steps.

Highlight the cells you want to "Watch."

Click on the "Formula" tab and select the "Watch Window" button in the "Formula Auditing" group.

Click on the "Add Watch" button.

Since the cells were highlighted, simply click on the "OK" button and the cells will be added to the "Watch Window."

Excel 07 Watch Window

Now when you make changes to the spreadsheet, the "Watch Window" shows you the changes to the cells you added to the list.

If you accidentally close the "Watch Window," simply click on the "Formula" tab and then the "Watch Window" button to open it again.

Friday, April 8, 2011

Word 2007 Tip

Do you use the Highlighter in Word? Highlighting in Word can be helpful for pointing out certain words and phrases; but it doesn't print very well.

There is a somewhat simple way to hide the Highlighter for printing.

Click on the "Office" button and select the "Word Options" button.

Click on "Display" on the left menu.

Clear the "Show Highlighters" checkbox.

Word 07 Show Highlighters Option

Click on the "OK" button to save the changes and return to your document.

The Highlighters are now hidden.  Print as needed.

Remember to repeat the steps above to unhide the Highlighters.  This time select the "Show Highlighters" checkbox.

Friday, April 1, 2011

Excel 2007 Quick Tip

Many of you have seen the improvements made in Excel 2007; but most users have still not learned all of the handy new features.

One of these new features is located in the "Recent Documents" area.

We've all seen the recent documents list and I've shown ways to change the number of recent documents as well as turning them on and off.

But, did you know you can "Pin" specific documents to the "Recent Documents" list?

To do so, simply click on the "Office" button to bring up the "Recent Documents" list.

Move the mouse to the spreadsheet you want to keep on this list permanently and click on the "Pin" icon on the right side of the spreadsheet name.

See image below

Excel 2007 Pin Recent Documents

The spreadsheet will remain on the list as more spreadsheets are added.

HINT:  This is an Office 2007 feature and may be used in Word 2007, PowerPoint 2007, etc.

To "unpin" the spreadsheet, simply click on the "Pin" icon again to "unpin" the spreadsheet from the list.

How to Delete Blank Rows in Excel