Is it possible to have different column widths in same column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example in cell B1 I have a heading that is really long, but in cell B3 I
only need to input a small number and the cell is taking up too much space
for that number. Is it possible for cell B1 to have a width of say 24 while
cell B3 only has a width of 12?

Thanks.
 
Peter

Column widths and row heights are properties of the entire columns and rows.

What have you got in C1?

If nothing, select B1:C1 and Format>Cells>Alignment>Horizontal>Center Across
Selection.

Or B1:D1?

Might do the trick for you you.


Gord Dibben MS Excel MVP
 

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

Column Width 2
Change Cell Width WITHOUT changing Column width 1
HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN 4
modifying cell width within same column, but on different rows 2
excel "IF" formula... if this possible ??? 0
column pixels vs column width 2
Column width 1
Can you lock the width of a column? 2

Back
Top