Where Is Print Preview On Excel Full Advantage Of

Printing from Microsoft Excel may seem like an obvious operation, with no need of further explanationjust press Command-P, Return, and head to the printer to pick up your document.

Where Is Print Preview On Excel Full Advantage Of

The reality, though, is that Excels print function is quite powerful, but you have to do a bit of digging to take full advantage of its capabilities.

Here are just a few of the options open to you when you print with Excel.

Much of the Excel print dialog (File - Print) looks familiar; it offers standard OS X print features such as Presets, PDF options, Preview, and Supplies.

There are some Excel-specific features, though, and heres how to take advantage of them.

If you created a print range, choosing Active Sheets will show just that print range in the preview area.

If you check the Fit To box, Excel will try to fit everything onto one pageshrinking both width and height as required to make it fit.

What I often do, though, is scale just one dimension, by entering a really large number of pages in the other dimension.

For example, you can make sure your output is scaled to fit just the width of your paper by setting the page(s) wide box to 1, and the page(s) tall box to 999.

Click Page Setup in the Print dialog, then go to the Sheet tab.

You can pick from predefined headers and footers via the pop-up menu, or you can create your own by clicking the Customize buttons.

I usually make sure the full path and file are included somewhere, just so I can be sure the version Ive printed matches the one Im looking at onscreen.

These are just a few of the interesting options hiding in Excels Print dialog, but there are plenty more.

Go ahead and experiment to see what works best for your needs.

Where Is Print Preview On Excel For Mac