Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Are conditional formats available for setting page breaks?
I have a list of information for several manufacturers in a spreadsheet. I
would like to force a page break between each manufacturer name, so I can create one list to send to each manufacturer. |
#2
|
|||
|
|||
You can't add page breaks with conditional formatting. However, you
could use Excel's Subtotal feature to add them. Select a cell in the list Choose DataSubtotals In the 'At each change in:' dropdown, select the field on which you want to base the page breaks Select a field to subtotal Add a check mark to 'Page break between groups' Click OK To print the heading rows on each page -- Choose FilePage Setup Select the Sheet tab In 'Rows to Repeat at top', enter the rows, e.g.: $1:$1 Click OK Or create a pivot table, with manufacturer in the page area, and print a copy of the pivot table for each manufacturer. There are instructions and links for pivot tables on Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivotstart.htm Nicky Armstrong wrote: I have a list of information for several manufacturers in a spreadsheet. I would like to force a page break between each manufacturer name, so I can create one list to send to each manufacturer. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
How do I set more than 3 conditional formats in Excel | Excel Discussion (Misc queries) | |||
Use Conditional Formats to highlight blanks? | Excel Worksheet Functions | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Conditional Formats in Excel | Excel Worksheet Functions |