 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Page Breaks And Merged Cells
Hello! In Excel 2003, I have a table in which the cells in Column A and Column C are merged in groups of two rows each. For example, Cells A4 and A5 are merged together, C4 and C5 are merged together, A6 and A7 are merged together, C6 and C7 are merged together, etc. The cells in Columns B and D are not merged. Is there a way to have the page breaks automatically not occur in the middle of a merged cell? I know how to adjust the page break locations manually. I was hoping for a command similar to the "do not let rows break across a page" function in Word, but I could not find one. Thank you in advance for any assistance. Excel has limited Word Processing functionality. I know of no way to prevent a pagebreak in the middle of merged cells. Manual seems to be the only way unless you went with VBA to seek out the merged cells at a logical pagebreak point and place a pagebreak above or below. "Logical" being the keyword.........you wouldn't want a pagebreak at every set of merged cells. Gord Dibben MS Excel MVP >Hello! > [quoted text clipped - 10 lines] > >Thank you in advance for any assistance. XL doesn't have anything like "do not let rows break". Since merged cells usually cause more problems then they're worth, is there a way you could do without them - e.g., use ALT-ENTER to put in a line break within a cell? > In Excel 2003, I have a table in which the cells in Column A and Column C > are merged in groups of two rows each. For example, Cells A4 and A5 are [quoted text clipped - 6 lines] > I was hoping for a command similar to the "do not let rows break across a > page" function in Word, but I could not find one. JE & Gord Thank you for your replies. In this case, since my worksheets are fairly small (2-3 pages at most), it will be easier to manually adjust the page breaks a few times a year than to unmerge the cells. > XL doesn't have anything like "do not let rows break". > [quoted text clipped - 15 lines] >> I was hoping for a command similar to the "do not let rows break across a >> page" function in Word, but I could not find one.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.