Hardware

Quick Tip: Modify Excel print margins with the mouse

Do you teach or support users who love using the mouse and would rather click than type whenever possible? If so, here's a timesaving tip for situations that Excel users face on an almost daily basis.

The problem? Your users have more data than will fit within Excel's default margin settings. When they go to File | Print Preview, their suspicions are confirmed: Only five out of the six columns are visible.

To correct this by mouse, go to File | Print Preview. If you don't see dotted lines representing margin settings, click the Margins button to display them. Mouse over any of the margin lines. When the cursor changes to a bidirectional arrow, click and drag to change the margins visually.

In many cases, you can pull that last column back onto the page by shrinking the right and left margins. Save even more paper by shrinking the top and bottom margins, cutting a three-page print range down to two.

What do you think of this article format?
Our editors are developing and refining new methods and formats for delivering the solutions you need. Do shorter, step-by-step pieces such as this one help you overcome the IT problems that keep you up at night? Share your thoughts with our editors. Content for this article was derived from the TechRepublic Microsoft Office e-newsletter. You can have tips like this delivered via e-mail each week by signing up here.
0 comments