Size with Window

  • Thread starter Thread starter klf-WA
  • Start date Start date
K

klf-WA

I'm working on a workbook with several charts. When I "create a copy" of a
worksheet that contains only a chart, the copy comes in automatically set to
"size with window". I don't want this to happen and can't figure out how to
undo the feature. I tried clicking on the icon, using Alt+, etc. to no
avail. Any suggestions?

Telecommuting using Excel 2003 from work.
Thanks!
 
Nomenclature: if it's a chart-only sheet, it's not a worksheet, it's a chart
sheet. A worksheet by definition has all those rows and columns.

With the chart sheet active, go to Tools menu > Options > Chart tab, and
uncheck the box for Chart sizes with window frame.

- Jon
 
Thanks for the clarification - yes it is indeed a chart sheet. I tried
unchecking the icon for "Size with Window" but this was ineffective. Other
suggestions? Thanks.
 
Sometimes this setting doesn't work properly unless you have a printer
installed.

- Jon
 
Hello Jon,

I tried to follow your suggestion, but the "sized with window" check box is
grayed out. Is there a way to uncheck it.

Thank you,

Ray G.
 
This might be one of those features that's inexplicably not available unless
there is a printer installed.

- Jon
 
Back
Top