Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing column size w/o losing text
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 |
#2
|
|||
|
|||
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. In article , Carrie wrote: 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. |
#3
|
|||
|
|||
Carrie wrote:
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 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 |
#4
|
|||
|
|||
You can also try "center across selection" for the title row or Row 15.
Gord Dibben Excel MVP On Tue, 12 Apr 2005 21:22:26 -0600, JE McGimpsey wrote: 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. In article , Carrie wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a text column | Excel Worksheet Functions | |||
getting excel to print text equal to a column | Excel Discussion (Misc queries) | |||
How do I change the text size in a drop down box | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Why is my text changing to pound signs? | Excel Discussion (Misc queries) |