Help with formatting

[jcmckeon]

The attached shows how I'd like a form to look when printed. The inspectors fill out the lines and when they get to the last line row 30 I want the next 30 lines to take on the same formatting so when they are done I can print 2 full pages that look the same. Its a manual form that they type into. If you have any suggestions on how to achieve what I'm looking for please HELP HELP HELP.

Can I set a default formatting? do it programmatically, conditional formatting

what the hell????

[FDibbins]

It looks like you have headers and footers set? Perhaps you just to adjust the print range?

[jcmckeon]

It looks like you have headers and footers set? Perhaps you just to adjust the print range?

Thank you for responding

[Pete_UK]

You can set this up manually for one row, and then copy that row down to the bottom of the first printed page, then you can copy that form down the sheet as many times as you like. You will need to manually merge the requisite columns on the first blank row of your form (it's difficult to say what row that is from your picture). It looks like cells B to G need to be merged, then H to M, then N to Q, and so on across the row. You might need to adjust the row height to allow for handwriting being larger than a printed line. Use Format cells to put borders around each cell in that row, then you can just copy that one row down as far as you need to.

Hope this helps.

Pete

[jcmckeon]

Thank you for responding