View original (French)

Insert multiple page breaks

paras -  
 paras -
Hello,

I have a staff list of about 200 lines. I would like to insert a page break after each line in order to print one sheet per employee. Is there a way to do this with a macro?

The only way I have found is to use ctrl + Y (repeat last action), but I have to do it manually for each line.

Thank you

Sylvie

3 answers

Answer 1 / 3
bcl3 Posted messages 193 Registration date   Status Member Last intervention   90
 
Hello, what word processing software are you using?
If it’s Word, here’s the link:
https://support.microsoft.com/en-us/office/insert-a-page-break-7613ff46-96e5-4e46-9491-40d7d410a043?ocmsassetid=ha010031062&correlationid=41f9a135-5bcb-4802-a142-20cb6515203e&ui=en-us&rs=en-us&ad=en
0
paras
 
Sorry, I forgot the software... I'm using Excel 2003.

Thanks again
0
bcl3 Posted messages 193 Registration date   Status Member Last intervention   90
 
There is no problem ^^ otherwise for a macro I found this on CCM =):


By designating the range, and .select is unnecessary:
Rows("5:14").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
or even shorter if it's the default values:
Rows("5:14").Insert

So I don't know if this works since I saw it on this forum:
https://forums.commentcamarche.net/forum/affich-8933429-inserer-plusieurs-lignes-avec-une-macro
Let me know if this works
0
bcl3 Posted messages 193 Registration date   Status Member Last intervention   90
 
ah by the way, I found this:
http://office.microsoft.com/en-us/excel-help/add-remove-or-move-page-breaks-HP005203049.aspx
0
paras
 
Your order above inserts lines, I want to insert page breaks.

Thank you.
0
bcl3 Posted messages 193 Registration date   Status Member Last intervention   90
 
Have you tried the second link?


Oh, otherwise I found this:
http://office.microsoft.com/en-us/excel-help/add-or-remove-page-breaks-HP005203049.aspx
0
Answer 2 / 3
bcl3 Posted messages 193 Registration date   Status Member Last intervention   90
 
I think this is what you're looking for:

In the Insert menu, select "page break"!

The break is inserted above the selected cell.

Let me know if it works.
0
Answer 3 / 3
Anonymous user
 
Hello Paras

Inserting a page break 200 times is torture!

If you don't have a macro proposal in Excel, you could use Word with the mail merge function, which consists of linking the Word file and the Excel file.

Check out this link for a guide on mail merge
https://www.faqword.com/index.php/word-faq/publipostage/410-ou-trouver-des-informations-concernant-la-fusion-et-publipostage-.html
and follow the procedure 'to create form letters'.

You will have one page per record in Word (thus per employee)

Argitxu
0
paras
 
Thank you, I will try this solution.
0