Changing column size w/o losing text

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

Guest

I am trying to change column width at the bottom of my worksheet (i.e. row
15), but then it also changes the column width in row 1 - my title which I
have set at a larger font, then I lose the text in my title. I can I lock
certain cells in same column so that it won't change other cells width?
Thank you for any help you can give me.
Carrie
 
As implied by the term "column width", width is a property of the
column, not individual cells.

If you want one cell wider, you can merge it with the cell next to it,
but that usually leads to more problems than it's worth.
 
Carrie said:
I am trying to change column width at the bottom of my worksheet (i.e. row
15), but then it also changes the column width in row 1 - my title which I
have set at a larger font, then I lose the text in my title. I can I lock
certain cells in same column so that it won't change other cells width?
Thank you for any help you can give me.
Carrie
Click to expand...

Not sure what you're putting on row 15 but you might want to take a look
at page setup > Header/Footer. This will allow you to put the Title in the
header and possibly the content from row 15 in the footer.

gls858
 
You can also try "center across selection" for the title row or Row 15.


Gord Dibben Excel MVP
 
Back
Top