Hi All,
I create userform for user to enter the data. after enter, i will transfer
the data to sheet which in turn will print out a report out.
my problem is, its difficult to design a report in worksheet if compared to
word.
I would like to know if there is a way for me to do this.
for example, when i realign the column B width at say row 22, my design
above row 22 become off. i tried to freeze above row 22 but cannot help. I
really frustrated.
Really need the help from this forum of how to control the report layout
when want to realign column width by not affecting the upper row layout.
Please help.

Column width is the property of the entire column.

My fingers are shaking as I write this, but if just for appearance in a report,
you could avail yourself of the "Merge Cells" feature.

Or better yet, maybe "Center across Selection" would suffice.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 21:29:01 -0700, AskExcel <(E-Mail Removed)>
wrote:

>Hi All,
>I create userform for user to enter the data. after enter, i will transfer
>the data to sheet which in turn will print out a report out.
>my problem is, its difficult to design a report in worksheet if compared to
>word.
>I would like to know if there is a way for me to do this.
>for example, when i realign the column B width at say row 22, my design
>above row 22 become off. i tried to freeze above row 22 but cannot help. I
>really frustrated.
>Really need the help from this forum of how to control the report layout
>when want to realign column width by not affecting the upper row layout.
>Please help.
>
>

Gord

m.... cells???? That is to Excel what 'The Scottish Play' is to actors ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Column width is the property of the entire column.
>
> My fingers are shaking as I write this, but if just for appearance in a
> report,
> you could avail yourself of the "Merge Cells" feature.
>
> Or better yet, maybe "Center across Selection" would suffice.
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 7 Jul 2006 21:29:01 -0700, AskExcel
> <(E-Mail Removed)>
> wrote:
>
>>Hi All,
>>I create userform for user to enter the data. after enter, i will transfer
>>the data to sheet which in turn will print out a report out.
>>my problem is, its difficult to design a report in worksheet if compared
>>to
>>word.
>>I would like to know if there is a way for me to do this.
>>for example, when i realign the column B width at say row 22, my design
>>above row 22 become off. i tried to freeze above row 22 but cannot help. I
>>really frustrated.
>>Really need the help from this forum of how to control the report layout
>>when want to realign column width by not affecting the upper row layout.
>>Please help.
>>
>>
>

I did type it with shaking fingers<g>



On Sat, 8 Jul 2006 17:38:29 +0100, "Nick Hodge"
<(E-Mail Removed)> wrote:

>Gord
>
>m.... cells???? That is to Excel what 'The Scottish Play' is to actors ;-)

Gord Dibben MS Excel MVP