News
Commentary
12/8/2004
03:44 PM
Commentary
Commentary
Commentary
Connect Directly
RSS
E-Mail
50%
50%

The Best Free Stuff For Microsoft Office Users

There are a lot of free resources available for Office users. This week, we feature a few small but useful items that are out there for the taking.

Microsoft Office is both popular and widely distributed, which means that there are a lot of resources available for Office users. This week, instead of focusing on one feature, I'm going to point you toward a few small but useful items that are out there for the taking.

Powerpoint Backgrounds
I'm always on the lookout for interesting Powerpoint backgrounds that are suitable for business presentations. You'll find several backgrounds and templates for free download at:

   http://www.indezine.com/powerpoint/templates/index.html

While several are too dark for my taste, I like the Blue Green and Lime Geometry backgrounds in particular.

Excel Charts Using VBA Code
Want to create charts in Excel 2003 using VBA (Visual Basic for Applications) code? Microsoft's Office Developer Center has an eight-page technical article that shows you how to add a chart with the Macro Recorder, add a chart sheet with VBA, use embedded charts, and move a chart between chart sheets and workbooks.

You'll find the explanation and code at:

   http://www.officeletter.com/red/ms0408b.html

Improving Access Subform Performance
If your Access project uses a form within a form (and many do, especially those that list detailed transactions), Microsoft's Knowledge Base (article 209113) has a couple of quick tricks worth heeding. You'll find the suggestions at:

   http://support.microsoft.com/default.aspx?scid=kb;EN-US;209113

Word: Repeat Headings In Long Tables
If your table is going to span more than one page, it's best to repeat the column headings on each page. Fortunately, you don't have to do that manually (which would be a nightmare). The following tip works in Word 2000 and later.

Enter the headings in the top row of your table. Use the Table command from the main menu, and select Heading Rows Repeat (it's a toggle).

If you don't see the headings at first, don't panic. If you're in Normal mode, you won't see the headings. In Web Mode, there is no such thing as a page break, so they won't show up there either. Switch to Print Layout (use the View/Print Layout command) or use Print Preview (File/Print Preview) to see the headings at the top of each page.

One more thing: Even though you can see the column headings on subsequent pages, you can only change the heading text in the top row of the table.



The Office Letter is a weekly e-mail and online newsletter offering tips, tricks, and techniques for Microsoft Office. It offers shortcuts, explores features, and boosts productivity with hands-on how-to information for Word, Excel, Outlook, PowerPoint, and more.

Comment  | 
Print  | 
More Insights
IT's Reputation: What the Data Says
IT's Reputation: What the Data Says
InformationWeek's IT Perception Survey seeks to quantify how IT thinks it's doing versus how the business really views IT's performance in delivering services - and, more important, powering innovation. Our results suggest IT leaders should worry less about whether they're getting enough resources and more about the relationships they have with business unit peers.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Government Oct. 20, 2014
Energy and weather agencies are busting long-held barriers to analyzing big data. Can the feds now get other government agencies into the movement?
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
A roundup of the top stories and trends on InformationWeek.com
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.