Follow this blog:
RSS
Email Alert

Microsoft Office

The Show Margins feature in Excel 2010 is revealed

Takeaway: Moving margins in Excel 2003 is easy using Show Margins. Many users can’t find it in the ribbon versions, but it’s still there.

Excel 2003 users can easily change margins in Print Preview. Simply click Margins and start dragging the margin lines. It’s easy and intuitive.

A frequent support call for users new to the ribbon versions is about this seemingly missing feature. Even in the Print panel in Backstage, they can’t find it. Many are upset that they’ll have to change margins manually, which kind of negates the whole point of Print Preview for some of them. Fortunately, the feature is still available; it just isn’t as obvious. In Backstage, Show Margins is in the bottom-right corner of the Print panel. You can still modify the margins quickly by dragging the margin markers.

What many users don’t realize is that they can use this feature to change column widths too. In the Print panel (Print Preview in Excel 2003), just click and drag the column markers to quickly resize a column. Or, position the cursor over the column border in the actual sheet area and drag.

Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.

Susan Harkins

About Susan Harkins

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.

Susan Harkins

Susan Harkins
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.
6
Comments

Join the conversation!

Follow via:
RSS
Email Alert