Format excel column data with fit the column width 2

[barnard89]

Hi

I am using Excel 2000

I have a pretty long column name for one of the columns
It is
"Type of Operational Source"

It seems to be pretty long to fit in a narrow column
How can I make it as a paragraph title like

"Type of
Operational
Source "

as the column name . I should be in a posion to make it flexible
Please suggest

thanks

 

[GlennUK]

Have you tried formatting the cell with alignment as "Wrap"?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

First of all - this is a basic question that could easily have been answered with a cursory look in the help files.

This is not a helpdesk site and as such, you are expected to have done some research BEFORE posting questions. Having said that, I am here to help so here are 2 options for you.

1: Format>Cells>Alignment>Wrap Text
2: Type Of <Alt>+<Enter> Operational <Alt>+<Enter> Source

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question