T
Té
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?
my columns so they only apply to a40 and below?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
??
J
JLatham
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.
You may be able to get added width by merging cells in other columns, but
that can cause other problems.
T
Té
So there isnt any to set a column for different ranges of cells? Columns
apply to the entire worksheet?
apply to the entire worksheet?
D
Dave Peterson
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!
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!
G
Gord Dibben
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
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
T
Té
Thank you everyone!!!