Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I have an excel document with many merged cells. I would like when it prints to automatically make the page breaks between non-merged cells. Right now I'm having problems with the merged cells being split between two pages. I know I can manually change the page breaks, but the document is a checklist that will have new data entered in often, so it would have to be changed every time it is printed out.
Name: DerbyDad03 Date: June 1, 2009 at 10:31:37 Pacific
Reply:
I'm not sure if this will work for you but give it a try...
If you go to View...Page Break Preview, you can drag the page breaks to where you want them and they should stay where you put them even if you add or delete rows.
For example if you put the page break above a merged cell and then delete a row above the merged cell, the entire merged cell will stay below the page break.
Summary: One of our users is having a problem with merging cells in excel 2002. She cannot merge cells, but only in one worksheet. The merge button is even grayed out. Is there check box, or an option somewher...
Summary: hello there, I have an issue when printing multiple excel worksheets in colour. I'm using Excel 2003. The default driver setting for our printer is set to Black & White although it can do both colour...
Summary: Dear Concern, I have an excel 2003 sheet filled with data. Now i want others to add the data but not edit the old data expect me. If some one can suggest me how to make this function work that after e...
0 
