microsoft excel 2007

Blog Post

Convert your Word documents into PowerPoint 2007 presentations

April 1, 2008 12:00am PDT

If you need to make a PowerPoint presentation from a Word document, don't worry about endless cutting and pasting. Mary Ann Richardson shows how you can use Word's built-in formatting to make an...

13 Latest comment by nor12345

Blog Post

10 steps to creating a Word input form

June 6, 2012 12:01am PDT

User forms make data entry more efficient, reduce errors, and ensure consistency. This walk-through will show your users how easy it is to set up their own forms.

4 Latest comment by chiponium@...

Blog Post

Where's the Convert Table To Text command in Word 2007 and 2010

October 7, 2010 7:12am PDT

Want to convert a Word 2007 table to text? You won't find the command in the most obvious place, but it's still there.

9 Latest comment by pdlarue@...

Blog Post

Eliminate those unfriendly error messages with Excel 2007's IFERROR function

March 11, 2008 12:00am PDT

Excel users know about the #N/A! error message but not know what it means. Mary Ann Richardson tells how to make the messages more user friendly, explaining the reason for a particular error...

8 Latest comment by heartres2rer

Blog Post

Create axis titles for your Excel 2007 charts

January 8, 2008 12:00am PST

Excel 2007 doesn't have a dialog box that allows you to edit chart and axis titles -- you need to insert them. If the text you want for your axis title is already in your worksheet, you can link...

Blog Post

10+ things I can never find in Access 2007/2010

August 3, 2010 2:25pm PDT

Even after working a while with Access 2007 or 2010, you may be disoriented if you're used to earlier versions. Susan Harkins offers some help in locating the tools you need.

18 Latest comment by james_dono@...

Blog Post

Create an Excel function to highlight formula cells in a worksheet

April 7, 2009 3:21pm PDT

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

7 Latest comment by danny@...

Articles

How do I... Change the normal template in Word 2007 to my preferences?

November 20, 2006 10:31pm PST

The normal template in Microsoft Word 2007 defaults to the Calibri font with one inch margins. Here is how you permanently change the normal template in Word 2007 to your preferred font, style,...

45 Latest comment by ajm2013

Blog Post

Mark duplicate entries automatically with Excel's COUNTIF function

March 31, 2009 12:00am PDT

Sometimes, it's handy to get a quick view of data that matches up between two columns. By combining an Excel function and the conditional formatting feature, you can easily accomplish this.

3 Latest comment by RRB

Blog Post

10 Outlook defaults you can customize to work the way YOU want

August 23, 2012 5:38am PDT

By changing just a few settings, you can configure Outlook to match your needs and working style.

4 Latest comment by marj@...

Blog Post

Exchange 2007: How to allow relay exceptions

October 26, 2007 11:14am PDT

Although allowing unfettered relaying of e-mail through your Exchange 2007 server should be avoided, there are situations in which allowing relaying is desirable. For example, suppose you have an...

7 Latest comment by jcarroll@...

Blog Post

Create a Strikethrough shortcut in Word

July 15, 2008 2:10pm PDT

Applying the Strikethrough format to text in a Word document requires a trip to the Font dialog box -- which will get old in a hurry, if you use that format a lot. Taking a moment now to create a...

11 Latest comment by Loosgoose

Blog Post

Convert Word 2007 documents to PDF format

January 29, 2008 12:00am PST

Office 2007 lets you convert your documents, spreadsheets, and PowerPoint presentations to PDF -- optimized for online documents, printed documents, or both. But before you can convert your...

24 Latest comment by rogerrr88

Blog Post

Change Word's default line spacing to what you want it to be

January 6, 2012 7:59am PST

Word 2007 and 2010's line spacing default isn't the same as it was in 2003. Here's how to change it to what you want it to be.

9 Latest comment by spiessa46

Blog Post

Where's the Number of Pages option in Word 2007 and 2010?

December 18, 2010 8:35am PST

In earlier versions, inserting the number of pages is a quick click on the Header and Footer toolbar. That toolbar's gone in Word 2007 and 2010, but the option is still available, if you know...

5 Latest comment by alanjason

Blog Post

How to delete duplicate values and duplicate records in Excel 2007 and 2010

January 17, 2012 8:51am PST

Using Excel 2007 and 2010, you can use the same built-in feature to to delete duplicates in columns as well as duplicate rows.

2 Latest comment by allancass

Blog Post

Add a watermark to your Word 2007 document

September 25, 2007 12:00am PDT

Word 2007 includes a number of predefined watermarks that you can add to your document without any additional formatting. Here's how to set them up.

3 Latest comment by miross

Blog Post

Five tips for printing Excel data more efficiently

August 30, 2010 9:37am PDT

Excel's printing features aren't complicated, but users often take a hit-or-miss approach and wind up with a mess. These simple tips demystify the print options and explain when to use which ones.

3 Latest comment by ecoprinting

Blog Post

How do I... Create and format tables in Word 2007?

May 9, 2007 11:25am PDT

This article is also available as a TechRepublic download and as a TechRepublic gallery. Word 2007, part of the Microsoft Office 2007 suite, has many built-in features that can enhance your...

8 Latest comment by candzgramma@...

Blog Post

Find it in Word 2007: Change Case

October 23, 2007 2:50pm PDT

Word's Change Case feature has long been one of its handiest devices. It's not smart enough to apply true title case (where articles and prepositions are left uncapitalized), but it will still...

13 Latest comment by Winnietang