Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I do column headings if it takes up more than 1 line?
I am making a chart that includes 7 colums and each column has a heading but
some of the titles takes up more than 1 line. It falls on two or three lines, how do I go about doing that? I tried to merge it but that didn't do anything. |
#2
|
|||
|
|||
Add a line feed with alt + enter for a new line in the same cell
-- Regards, Peo Sjoblom (No private emails please) "tj" wrote in message ... I am making a chart that includes 7 colums and each column has a heading but some of the titles takes up more than 1 line. It falls on two or three lines, how do I go about doing that? I tried to merge it but that didn't do anything. |
#3
|
|||
|
|||
tj,
For most Excel tools (charts, sort, pivot tables, autofilter, etc.), you need to have your headings in a single row. Use Alt-Enter as Peo suggested. Or set the heading row cells to wrap the text (Format - Cells - Alignment). -- Earl Kiosterud www.smokeylake.com "tj" wrote in message ... I am making a chart that includes 7 colums and each column has a heading but some of the titles takes up more than 1 line. It falls on two or three lines, how do I go about doing that? I tried to merge it but that didn't do anything. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change column headings from A,B,C to actual words? | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
move column headings from row to column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |