How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
Heather
How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
Heather
You can't!
"heather" wrote:
> How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
> Heather
You can merge cells from multiple columns to make certain cells in a column
appear wider, but you need to have an adjacent blank cell that you can use
for this purpose.
In your example you could select cells B1:C1 and then open the Alignment tab
of the Format Cells option dialog box and select the Merge Cells option box.
Then resize both columns B and C as needed to display the contents of both
cells.
Hope that helps,
TK
"heather" wrote:
> How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
> Heather
If you go with the merged cells, be prepared for future problems when attempting
to copy, paste, sort, filter and others I can't think of of.
Gord Dibben MS Excel MVP
On Mon, 12 Jun 2006 13:15:02 -0700, T Kirtley
<[email protected]> wrote:
>You can merge cells from multiple columns to make certain cells in a column
>appear wider, but you need to have an adjacent blank cell that you can use
>for this purpose.
>
>In your example you could select cells B1:C1 and then open the Alignment tab
>of the Format Cells option dialog box and select the Merge Cells option box.
>Then resize both columns B and C as needed to display the contents of both
>cells.
>
>Hope that helps,
>
>TK
>
>"heather" wrote:
>
>> How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
>> Heather
Thank you for the input! I'll try it.
Heather
"T Kirtley" wrote:
> You can merge cells from multiple columns to make certain cells in a column
> appear wider, but you need to have an adjacent blank cell that you can use
> for this purpose.
>
> In your example you could select cells B1:C1 and then open the Alignment tab
> of the Format Cells option dialog box and select the Merge Cells option box.
> Then resize both columns B and C as needed to display the contents of both
> cells.
>
> Hope that helps,
>
> TK
>
> "heather" wrote:
>
> > How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
> > Heather
Hey Gord,
Thank you for the warnings. I only need to make a sheet from which a hard
copy will be made. I'm making a form so I won't need to sort or filter.
It's good to know for future use though. I appreciate the information.
Heather
"Gord Dibben" wrote:
> If you go with the merged cells, be prepared for future problems when attempting
> to copy, paste, sort, filter and others I can't think of of.
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 12 Jun 2006 13:15:02 -0700, T Kirtley
> <[email protected]> wrote:
>
> >You can merge cells from multiple columns to make certain cells in a column
> >appear wider, but you need to have an adjacent blank cell that you can use
> >for this purpose.
> >
> >In your example you could select cells B1:C1 and then open the Alignment tab
> >of the Format Cells option dialog box and select the Merge Cells option box.
> >Then resize both columns B and C as needed to display the contents of both
> >cells.
> >
> >Hope that helps,
> >
> >TK
> >
> >"heather" wrote:
> >
> >> How do I do this? Cell B1 is 30 width and cell B2 is 20 width? Thanks,
> >> Heather
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks