mary ann richardson

Blog Post

Create process diagrams in less time with Word 2007's SmartArt

July 31, 2007 12:00am PDT

Word 2007's SmartArt makes diagram creation easier than ever, automatically resizing elements and allowing you to preview changes before you apply them. Here's how to create a simple diagram in...

Blog Post

Create an Excel data entry form that includes check boxes

July 31, 2007 12:00am PDT

You can keep a lot of information on an Excel data entry form, but you can make it easier for your users -- and yourself -- to create tables by adding check boxes. Here's how to set up check boxes...

31 Latest comment by Corbybhoy

Blog Post

Add a Total row to your Access 2007 table

July 24, 2007 12:00am PDT

What's the bottom line? In Access 2007, you can calculate totals in table view. Here's how to add a Total row to your database and then analyze the data it presents.

1

Blog Post

Quickly convert text values to numbers with Excel's Paste Special

July 24, 2007 12:00am PDT

If you regularly copy numerical data from Access tables to Excel spreadsheets, you may know that doing calculations on the copied text is challenging, if possible at all. Here's how to convert...

26 Latest comment by viren_lucky1

Blog Post

Use Word 2007's contextual spell checker to avoid embarrassing errors

July 24, 2007 12:00am PDT

Word's spell checker may miss words that sound the same. Find out how to use Word 2007's contextual spell checker to avoid slipping on homonyms.

8 Latest comment by Trackstardeb

Blog Post

Insert directions into Word using Smart Tags

July 17, 2007 12:00am PDT

If you include an address with a Word document, you don't need to send readers to an online mapping service to figure out how to get there. Use Word's Smart Tag feature and give your readers...

16 Latest comment by kvick@...

Blog Post

Add a help button to Excel 2002/2003 applications

July 17, 2007 12:00am PDT

Sometimes words and numbers don't tell the whole picture. That's why Excel 2002/2003 allows you to create and display online help text and examples for your applications and embed them right in...

Blog Post

Save time by creating tables from Access 2007 field templates

July 17, 2007 12:00am PDT

Access 2007 data field templates are predefined data fields that you add to your own database tables, saving you the step of entering the same information each time. Here's how to create your own...

Blog Post

Diagnose problems in Word 2007 with Microsoft Office Diagnostics

July 10, 2007 12:00am PDT

If Word 2007 is dragging or even crashing already, you can do some diagnostics. Microsoft Office Diagnostics will check your computer for a variety of problems, including disk errors, updates, and...

14 Latest comment by amodkshukla

Blog Post

Let Access 2007 create a form from the active table

July 10, 2007 12:00am PDT

Access 2007 makes form creation easier than ever. Here's how to make a form from any table you open.

3 Latest comment by ollney.hoopai@...

Blog Post

Add help messages to Excel applications with Data Validation

July 10, 2007 12:00am PDT

Excel applications can get tricky, and it's not unusual for your users to need some help from time to time. Here's how to add a help message to any worksheet cells you choose -- without...

1

Articles

Set Excel text boxes to reflect data updates

June 26, 2007 12:00am PDT

Have your Excel text box change with your data! Here's how to create dynamic text boxes in Excel, while giving yourself the freedom to format them to fit your style.

21 Latest comment by ArchGov

Articles

Change Access 2007 database options for your application

June 26, 2007 12:00am PDT

Make your Access 2007 databases more descriptive with custom titles in the title bar. Here's how to change database options in Access 2007.

6 Latest comment by A.K.Patel

Articles

Check the compatibility of your Word 2007 documents

June 26, 2007 12:00am PDT

Here's how to have Office check your Word 2007 document for possible conversion and compatibility problems before you send it out into the world.

Articles

Enter text without changing the underlying cells in Excel 2007

June 19, 2007 12:00am PDT

Mary Ann Richardson discusses text boxes, which can hold unlimited amounts of text without affecting any of the cells in your Excel 2007 spreadsheet.

3 Latest comment by bros3n@...

Articles

Quickly summarize group data in Access 2007 reports

June 19, 2007 12:00am PDT

Access 2007 makes it easy to compile a summary from your group data -- in fact, there's even a special dialog box for it. Here's how to create a thorough Access report using group data.

Articles

Prevent Outlook from adding the country field in Word

June 19, 2007 12:00am PDT

Writing letters in Word should be a breeze; however, Outlook may throw a snag in the process. Mary Ann Richardson walks you through the steps of how to block Outlook from automatically adding the...

Articles

Create Access 2007 reports and forms from existing tables

June 12, 2007 12:00am PDT

Access 2007 isn't totally foreign to your old databases. You can access and then import tables into the new version and create brand new forms and reports based on that data. Mary Ann Richardson...

1

Articles

Print what you see in Excel 2007's Page Layout View

June 12, 2007 12:00am PDT

Excel 2007's Page Layout View allows you to avoid the frustration of creating unnecessary printouts of your spreadsheets. Here's an easy way to see your work (including headers and footers) using...

2 Latest comment by muraliir@...

Articles

Control text flow in Word with linked text boxes

June 12, 2007 12:00am PDT

When working with columns in Word, you can wind up spending a lot of time making sure the text flows evenly from one column to another. You can avoid much of this formatting by replacing columns...

19 Latest comment by stiucum