Excel 2011 Won'T Print Gridlines For My Graphs Full Advantage Of
Excel 2011 Won'T Print Gridlines For My Graphs How To Take Advantage

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.

Excel 2011 Won'T Print Gridlines For My Graphs 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.

Excel 2011 Won'T Print Gridlines For My Graphs How To Take Advantage

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.

Click in the Rows or Columns boxes in the Print Titles section, then click on the worksheet to select a row or column (hold Shift and click for multiple rows or columns).

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.

We give you the scoop on whats new, whats best and how to make the most out of the products you love.

Excel 2011 Mac Won'T Print Gridlines For My Graphs