| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert page break automatically?
Hi, Excel stars,
anyone knows how to insert page breaks automatically whenever the item in the colume changes? Please see the sample below. Name Tom Tom Jack Jack Mary Mary -- Thanks in advance for your answer! Jack |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to insert page break automatically?
I found that DataSubtotals can insert page breaks. If you remove Subtotals,
page breaks remain. Regards, Stefi €˛Jack€¯ ezt Ć*rta: Hi, Excel stars, anyone knows how to insert page breaks automatically whenever the item in the colume changes? Please see the sample below. Name Tom Tom Jack Jack Mary Mary -- Thanks in advance for your answer! Jack |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to insert page break automatically?
Hi, Stefi,
I tried. But when I remove Subtotals, the page breaks were left but were not in the correct positions. Just as illustrated in the example below. Maybe the way I removed the breaks is wrong. Could you please advice the correct way to remove the subtotalls and leave the breaks where they were. Tom Tom Mary Mary Mary John John John -- Jack "Stefi" wrote: I found that DataSubtotals can insert page breaks. If you remove Subtotals, page breaks remain. Regards, Stefi €˛Jack€¯ ezt Ć*rta: Hi, Excel stars, anyone knows how to insert page breaks automatically whenever the item in the colume changes? Please see the sample below. Name Tom Tom Jack Jack Mary Mary -- Thanks in advance for your answer! Jack |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to insert page break automatically?
How did you remove Subtotals? I guess you deleted them selecting Subtotal
rows one by one. Use DataSubtotalsRemove all button (bottom left button in the Subtotals dialog)! Regards, Stefi €˛Jack€¯ ezt Ć*rta: Hi, Stefi, I tried. But when I remove Subtotals, the page breaks were left but were not in the correct positions. Just as illustrated in the example below. Maybe the way I removed the breaks is wrong. Could you please advice the correct way to remove the subtotalls and leave the breaks where they were. Tom Tom Mary Mary Mary John John John -- Jack "Stefi" wrote: I found that DataSubtotals can insert page breaks. If you remove Subtotals, page breaks remain. Regards, Stefi €˛Jack€¯ ezt Ć*rta: Hi, Excel stars, anyone knows how to insert page breaks automatically whenever the item in the colume changes? Please see the sample below. Name Tom Tom Jack Jack Mary Mary -- Thanks in advance for your answer! Jack |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INSERT ROW AND PAGE BREAK | Excel Discussion (Misc queries) | |||
| cannot insert page break | Excel Discussion (Misc queries) | |||
| Automatically insert page break every 6 rows in excel doc | Excel Discussion (Misc queries) | |||
| automatically insert row at each page break | Excel Worksheet Functions | |||
| Insert Page Break | Excel Discussion (Misc queries) | |||
Linear Mode
