MartinW;181377 Wrote:
Welcome to the wonderful world of merged cells which cause no end of
problems and should be banned from existence.

Hi Gord,

There are times that merged cells come in handy.
My organisation has a timeheet that was probably created in Word
then converted to PDF and is available to all parts of the
organisation
on the company Intranet as a standard form. The intended use of the
form is to be hand written.

I made an Excel version of the form that automated the input and
calculated
times etc. but in order to re-create an EXACT replica of the original
form I
needed to use merged cells.

Admittedly, due to the merged cells, it is not entirely user friendly,
the
merged
cells can cause the odd minor problem, but it works very well for
myself and
anyone else who is fairly competent in Excel.

Regards
Martin

Martin, merged cells can be easily replaced by using Format - center
across selection.
The effect is the same and the problems merged cells create are
avoided.
As to persons " fairly competent", I know a lot of MVP's who strongly
recommend AVOIDING merged cells at all costs ( save for cosmetic
purposes).
But if you want to stick with them, be my guest, and welcome to the
fifth dimension !


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49937