I have data from a1:g35, When I start typing in A40 is there anyway to adjust
my columns so they only apply to a40 and below?

??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Té" <(E-Mail Removed)> wrote in message
news:13E232AB-E496-4CFC-A971-(E-Mail Removed)...
>I have data from a1:g35, When I start typing in A40 is there anyway to
>adjust
> my columns so they only apply to a40 and below?

Simple answer is NO. All cells in a column will be the same width.

You may be able to get added width by merging cells in other columns, but
that can cause other problems.

"Té" wrote:

> I have data from a1:g35, When I start typing in A40 is there anyway to adjust
> my columns so they only apply to a40 and below?

So there isnt any to set a column for different ranges of cells? Columns
apply to the entire worksheet?

You could merge cells in the same row that will give you the appearance of wider
columns.

But once you work with merged cells for more than 30 seconds, you'll find that
there are so many things that are screwy that you'll never want to use them
again!

Té wrote:
>
> So there isnt any to set a column for different ranges of cells? Columns
> apply to the entire worksheet?

--

Dave Peterson

Column width applies to the entire colulmn.

Each entire column can be a different width.

Same for row height.

You could workaround for visual and printing by cutting the lower source range
to another worksheet, adjust columns then take a picture and paste that back
into the source sheet.


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 14:33:00 -0700, Té <(E-Mail Removed)> wrote:

>So there isnt any to set a column for different ranges of cells? Columns
>apply to the entire worksheet?

Thank you everyone!!!