A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Lock group of rows for printing purposes



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2004, 11:36 PM
Benjamin
external usenet poster
 
Posts: n/a
Default 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  
Old April 25th, 2004, 01:58 AM
DDM
external usenet poster
 
Posts: n/a
Default 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  
Old April 26th, 2004, 03:11 PM
Benjamin
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.