XL 2007 Custom Views - Print Settings Option

[LPS]

Hi again. I have been learning how to use the Custom Views... pretty
straight forward except that I have a mental block about the Print Settings
option. If this feature is de-selected, what is the impact? I cannot see
any difference between a custom view which has this feature enabled versus
one which has it disabled.

Can anyone enlighten me? All help is always appreciated.

 

[vttotal]

Hi,

I am not aware if you are trying to ask questions about the Print Preview or
the Custom View.

The only thing that Custom View does is save viewing properties (such as
zooming values, 100%, 40% etc,). Print Settings is separate from any kind of
viewing options(except Page Break Preview which lets the User adjust how much
of a spreadsheet can fit into one page).

Hope this information helps

 

[LPS]

Thanks for your response. I'll try to be more specific... It is Custom
View in Excel 2007, not print preview or page break preview.

When you click on Custom View (Excel 2007) and click "Add", you are prompted
for 3 things:

1) the name of the view
2) a check box for print settings
3) a check box for Hidden rows, columns and filter settings.

I have tried different scenarios, with the print settings check box enabled
and disabled and I do not see any difference in the resulting saved views. I
was just wondering what the check box for Print Settings is meant to do (and
I cannot find any reference to it in the on-line help).

Thx,

 

[Gord Dibben]

From help on custom views(2003)

Before you create a view Set up the workbook to appear the way you want
to view and print it. If you include print settings in a view, the view
includes the defined print area (print area: One or more ranges of cells
that you designate to print when you don't want to print the entire
worksheet. If a worksheet includes a print area, only the print area is
printed.), or the entire worksheet if the sheet has no defined print area.

I can't find simi;ar help in 2007 but I would imagine the same applies.


Gord Dibben MS Excel MVP