Border

  • Thread starter Thread starter MADDY
  • Start date Start date
M

MADDY

HI,

I have an excel sheet wherein a particular merged cell is getting cut in
half by a pagebreak. i need a border on the upper and lower portion of the
cut cell, can anyone help me with this?

TIA
LK
 
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.

Best suggestion I can offer is to not use merged cells.

They cause no end of problems.


Gord Dibben MS Excel MVP
 
hi gord,

Thanks for your prompt reply. I dont want to actually prevent the pagebreak
from fallin at tht position, i want to just place a border at that position
so that the top portion in the first page and the bottom portion in the
second page are bound. i have tried placing a line object at that position
but i am not able to place it exactly where i want to and so the sheet looks
clumsy.
 
Borders go around cells.

Merging several cells creates one larger cell which can only have a border
around, not in the middle.


Gord
 
hi gord,

thanks a lot. i figured it out that you cannot put a border in between the
merged cell so i just perfected the line object placement function and ithink
the customer will agree to it. Thanks a lot for your help. is there any
microsoft page that says i cannot put a border inbetween merged cells. that
would help me lot.

TIA
maddy
 
I don't know of any MS page that says you can't place a border "between" merged
cells.

But think of the purpose in merging several cells..............it is a feature
that allows you make one cell from many.

Note the operative words are "one cell".


Gord
 
Back
Top