PCMag editors select and review products independently. If you buy through affiliate links, we may earn commissions, which help support our testing.

Ten Tips for Microsoft Word and Excel

Our team tests, rates, and reviews more than 1,500 products each year to help you make better buying decisions and get more from technology.

Our Expert
LOOK INSIDE PC LABS HOW WE TEST
65 EXPERTS
43 YEARS
41,500+ REVIEWS

PCMag.com's Microsoft Office 2010 tips collection continues, this time with ten tips for Word and Excel users. Most of these tips are fairly straightforward, and most apply to the most recent versions of Office. Some of them, however, offer new twists for the latest version of Office. Expert users will be familiar with some of these ten tips, but we hope that any user will find at least a few of these to be useful.

What kind of tips am I talking about this time? Finding ways to perform poorly documented functions in Word and Excel. One of these tips, for example, tells you what to do when Word inserts a horizontal line across the page when you only wanted to type a few dashes. In the past few months, everyone in my family has tried and failed to wrestle an unwanted horizontal line out of a Word document. It might not sound like a big issue, but once you've got it in your document, good luck finding help from Microsoft on how to get rid of it.

Some software vendors, like Adobe, continue to provide help systems that work like improved versions of traditional software manuals. In those apps, every menu item, every toolbar icon, is carefully explained, and with a little patience you can find all the information you need. Microsoft, in contrast, provides with you a kind of information supermarket, with huge essays about topics you don't care about, dozens of selections when you only need one, and no consistent way to find the information you want. When I need help with Office, I don't click the help button on the upper right of the ribbon—I go to Google or Bing. Curiously, Google is more likely than Bing to send me to useful pages at Microsoft.com.

I've focused these tips, therefore, on convenient ways to do things that Office doesn't offer much guidance about, either on its menu or on its ill-conceived online help system, which has a bad habit of not telling me what I need to know.



Whatever your level of Word and Excel expertise, you'll find a technique worth remembering among these ten tips. Click on the slideshow above to read the rest of our Word and Excel 2010 tips story.

Looking for even more Microsoft Office 2010 tips? Check out the rest of our ongoing series.

How to Use Excel More Effectively: 10 Great Excel Tips & Tricks
Microsoft Office 2010: 10 Tips and Tricks
Microsoft Office 2010: 10 More Tips and Tricks
10 Expert Tips for Microsoft Word
10 Excellent Tips for Microsoft Excel 2010
10 Simple Outlook 2010 Tips
10 Tips for Microsoft Word and PowerPoint 2010
How to Use Outlook Better: 10 Tips

About Our Expert

Edward Mendelson

Edward Mendelson

My Experience

I've been writing about software and hardware for PCMag for more than 40 years, focusing on operating systems, office suites, and communication and utility apps. I've specialized in everything related to word and document processing, including format conversion, OCR, and PDF apps. In my spare time, I build apps for Macs and Windows PCs that make it easy to run legacy operating systems (such as old versions of macOS and Windows) and work with legacy documents.

I've also written about technology for non-technical publications, such as The New York Review of Books. Before joining PCMag, I reviewed music and sound equipment for audio magazines. In my other career, I'm the Lionel Trilling Professor in the Humanities at Columbia University and write books about modern literature.

The Technology I Use

For work, I use a Lenovo ThinkCentre M901s desktop (one at home, one in the office) and a Lenovo ThinkPad X13 laptop. For everything else, I use an M4 MacBook Air and an M4 MacBook Pro. I also have an iPad Air and a closet full of obsolete ThinkPads and Macs that I use for testing and nostalgia. I still use an iPhone 13 mini because it's the smallest iPhone that Apple still supports.

My speakers are a mix of Bang & Olufsen and Sonos models, driven by a mix of tube-based and solid-state electronics and a WiiM Pro streamer.

Read full bio