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

  1.
    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
    1. paras
       
      Sorry, I forgot the software... I'm using Excel 2003.

      Thanks again
      0
    2. 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
    3. 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
    4. paras
       
      Your order above inserts lines, I want to insert page breaks.

      Thank you.
      0
    5. 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
  2. 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
  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
    1. paras
       
      Thank you, I will try this solution.
      0