| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
| First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
| Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
| print preview v page break preview | Excel Discussion (Misc queries) | |||
| cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Hybrid Mode
