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.