If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lock group of rows for printing purposes
I'm setting up a grid with client names, addresses, phone numbers, etc. Some of the information for each client takes up two rows, others three or four. If I add a client in the middle, I'd like to be sure that all the information for each client moves forward to the next page if there's not enough room at the bottom of the page. Is there a way to group the rows so they will print together? Simply inserting a row pushes the bottom row onto the next page. I know I could put in a manual page break, but is there a way for this to happen automatically? Thanks.
ben |
#2
|
|||
|
|||
Lock group of rows for printing purposes
Benjamin, there's no way to group rows so they'll stay together at print
time. The best you can do, as you point out, is to use the Page Break Preview to set the page breaks manually. And, if I may, may I offer this advice? Try to keep each client's information on a single row. If necessary, widen the columns and wrap the text in cells (Format Cells Alignment Wrap Text), and introduce line breaks (Alt+Enter). Keeping all the client information on a single line will pay dividends later if you ever want to sort, group, or filter your client list. DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com "Benjamin" wrote in message ... I'm setting up a grid with client names, addresses, phone numbers, etc. Some of the information for each client takes up two rows, others three or four. If I add a client in the middle, I'd like to be sure that all the information for each client moves forward to the next page if there's not enough room at the bottom of the page. Is there a way to group the rows so they will print together? Simply inserting a row pushes the bottom row onto the next page. I know I could put in a manual page break, but is there a way for this to happen automatically? Thanks. ben |
#3
|
|||
|
|||
Lock group of rows for printing purposes
Thanks for the information. The idea about using a single line is a good one. Hadn't thought about it, but it should help in the future.
ben |
Thread Tools | |
Display Modes | |
|
|