Software

Office challenge: How would you inhibit formats when using the fill handle?

In this week's Office Challenge, test your Excel skills with an simple fill handle trick for inhibiting formats.

Do your users sometimes suffer with hitchhiking formats? Take a look at the following sheet. When you use the fill handle to create a series, Word also copies the top border. That may or may not be what you want. If not, what quick fix would you share with users? (Your clue's in the sheet!)

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks