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


On Wed, 28 Nov 2007 07:11:04 -0800, MADDY
wrote:

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

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.

"Gord Dibben" wrote:

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


On Wed, 28 Nov 2007 07:11:04 -0800, MADDY
wrote:

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

Borders go around cells.

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


Gord

On Wed, 28 Nov 2007 20:07:00 -0800, MADDY
wrote:

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.

"Gord Dibben" wrote:

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


On Wed, 28 Nov 2007 07:11:04 -0800, MADDY
wrote:

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

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
"Gord Dibben" wrote:

Borders go around cells.

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


Gord

On Wed, 28 Nov 2007 20:07:00 -0800, MADDY
wrote:

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.

"Gord Dibben" wrote:

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


On Wed, 28 Nov 2007 07:11:04 -0800, MADDY
wrote:

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

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

On Thu, 29 Nov 2007 19:55:00 -0800, MADDY
wrote:

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
"Gord Dibben" wrote:

Borders go around cells.

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


Gord

On Wed, 28 Nov 2007 20:07:00 -0800, MADDY
wrote:

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.

"Gord Dibben" wrote:

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


On Wed, 28 Nov 2007 07:11:04 -0800, MADDY
wrote:

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