| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print one page per sheet
Hello,
Can you help me to figure out what to change to have one record printed per sheet be the standard way my report prints. -- Thank you for your time! John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print one page per sheet
Of course, we all know "the standard way my report prints"
If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Very Basic User" wrote in message ... Hello, Can you help me to figure out what to change to have one record printed per sheet be the standard way my report prints. -- Thank you for your time! John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print one page per sheet
I assume that you have a single sheet that has several records on it going
from top to bottom of the sheet? If that's the case, go to column A in the row below the last row for each record and use Insert -- Page Break (Excel 2003 and earlier) [2 steps] Excel 2007: Page Layout tab, Page Setup group, use the "Breaks" pull down to insert a page break. [4 steps] "Very Basic User" wrote: Hello, Can you help me to figure out what to change to have one record printed per sheet be the standard way my report prints. -- Thank you for your time! John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print one page per sheet
Thank you JLatham, My problem seems simple when I get answers on here.
-- Thank you for your time! John "JLatham" wrote: I assume that you have a single sheet that has several records on it going from top to bottom of the sheet? If that's the case, go to column A in the row below the last row for each record and use Insert -- Page Break (Excel 2003 and earlier) [2 steps] Excel 2007: Page Layout tab, Page Setup group, use the "Breaks" pull down to insert a page break. [4 steps] "Very Basic User" wrote: Hello, Can you help me to figure out what to change to have one record printed per sheet be the standard way my report prints. -- Thank you for your time! John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print comments at end of sheet but on same page as data? | Excel Discussion (Misc queries) | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| How can I print a different header on each page of an Excel Sheet | Excel Discussion (Misc queries) | |||
| How can I print page 2 of each sheet in a workbook? | Excel Discussion (Misc queries) | |||
| Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
Linear Mode
