Print Preview
 

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. But I'm just going to print the selection. So how do I
view what the selection will look like? Thanks.

Print Preview
 

In xl2003 menus:

File|Print
Check Selection
click the Preview button

dhstein wrote:

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. But I'm just going to print the selection. So how do I
view what the selection will look like? Thanks.

--

Dave Peterson

Print Preview
 

Excel 2007 - doesn't seem to work that way

"Dave Peterson" wrote:

In xl2003 menus:

File|Print
Check Selection
click the Preview button

dhstein wrote:

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. But I'm just going to print the selection. So how do I
view what the selection will look like? Thanks.

--

Dave Peterson

Print Preview
 

Select the range | go to | page layout tab | print area : set print
area | office button | print | print preview or shortcut key for print
preview Ctrl + F2


On Apr 7, 7:14*am, dhstein wrote:
Excel 2007 - doesn't seem to work that way

"Dave Peterson" wrote:
In xl2003 menus:

File|Print
Check Selection
click the Preview button

dhstein wrote:

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. *But I'm just going to print the selection. *So how do I
view what the selection will look like? *Thanks.

--

Dave Peterson

Print Preview
 

Thanks muddan - that was it.



"muddan madhu" wrote:

Select the range | go to | page layout tab | print area : set print
area | office button | print | print preview or shortcut key for print
preview Ctrl + F2


On Apr 7, 7:14 am, dhstein wrote:
Excel 2007 - doesn't seem to work that way

"Dave Peterson" wrote:
In xl2003 menus:

File|Print
Check Selection
click the Preview button

dhstein wrote:

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. But I'm just going to print the selection. So how do I
view what the selection will look like? Thanks.

--

Dave Peterson

Print Preview
 

That's why it's important to include what version of excel you're using.

dhstein wrote:

Excel 2007 - doesn't seem to work that way

"Dave Peterson" wrote:

In xl2003 menus:

File|Print
Check Selection
click the Preview button

dhstein wrote:

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. But I'm just going to print the selection. So how do I
view what the selection will look like? Thanks.

--

Dave Peterson


--

Dave Peterson

Print Preview
 

You don't need to change the print area.

Office Button|Print|Print
Check selection
click the Preview button

It's very close to the way xl2003 and earlier work.

dhstein wrote:

Thanks muddan - that was it.

"muddan madhu" wrote:

Select the range | go to | page layout tab | print area : set print
area | office button | print | print preview or shortcut key for print
preview Ctrl + F2


On Apr 7, 7:14 am, dhstein wrote:
Excel 2007 - doesn't seem to work that way

"Dave Peterson" wrote:
In xl2003 menus:

File|Print
Check Selection
click the Preview button

dhstein wrote:

If I select a range for printing - say A20:G60 and want to see how it will
print on the page - when I do a print preview it displays as if I'm going to
print a full page. But I'm just going to print the selection. So how do I
view what the selection will look like? Thanks.

--

Dave Peterson



--

Dave Peterson