| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
print a new page for each group
Hi,
Fist sort in alphabetical order the column containing the value based on which you want to create a break. Then go to Data Subtotal and check the box for Page break between groups. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ben" wrote in message ... is it possible to have a page break automatically inserted when there is a change in value in a particular column? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you print single page multiply times with increasing page . | Excel Worksheet Functions | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
