Software

Keep embedded charts off your worksheet printouts in Excel

You can print an embedded chart in Excel without its worksheet by simply selecting the chart and choosing File | Print or clicking the Print button, but did you know that you can print a worksheet separate from its embedded chart in Excel? Even if it's a large worksheet, Mary Ann Richardson tells us how in this quick tip.

You can print an embedded Excel chart without its worksheet by simply selecting the chart and choosing File | Print or clicking the Print button. But what if you want to print the worksheet without the embedded chart? You could select the worksheet, choose File | Print, click Selection, and then press OK. But if it is a large worksheet spread out over nonadjacent cells, this method can be quite cumbersome. You can print the worksheet without the chart, and save yourself some mouse clicks, by following these steps:

  1. Right-click the chart and choose Format Chart Area.
  2. Click the Properties tab.
  3. Clear the check mark from the Print Object check box, and click OK.

Now you can use File | Print to print the entire worksheet without the embedded chart.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

0 comments