Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a very large file of employee data. Each row equals a different
employee. The headings (top row) include Dept#, Employee Name, etc. The file is sorted by Dept#. Sample: Dept # Employee Name 123 John Doe 123 Mickey Mouse 124 Minnie Mouse I need to automatically insert a PageBreak so that every time there is a change in Dept # the dept starts on a new page. What is the easiest way to do this that can be repeated everytime I prepare a new report? Thanks so very much for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cant move pagebreak in PageBreak View in Excel2003 | Excel Worksheet Functions | |||
How can I rid Page 1 watermark in Pagebreak Preview? | Excel Worksheet Functions | |||
Can I keep rows together so they don't separate at a pagebreak? | Excel Discussion (Misc queries) | |||
Excel 2000 PageBreak problem | Excel Discussion (Misc queries) | |||
Remove page number under pagebreak preview | Excel Discussion (Misc queries) |