Adjusting columns

  • Thread starter Thread starter Té
  • Start date Start date
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?
 
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.
 
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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding 1 everytime something is in a column 2
CRYORIG A40 Ultimate 1
Conditional Formatting for an unknown range 7
finding data in the same sheet 1
finding data on same sheet 1
copy data in the same sheet 1
ind data in same sheet 1
finding data in same sheet 1

Back
Top