How do I do column headings if it takes up more than 1 line?

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

Guest

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.
 
Add a line feed with alt + enter for a new line in the same cell

--
Regards,

Peo Sjoblom

(No private emails please)
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
How to create a bubble chart with more than 2 variables 0
Column Heading 2 Lines 3
how do I remove page headings from an imported text file 1
how do I sort data excluidng headings? 2
how do I remove line breaks from several cells? 6
Line Up Two Columns In Excel 2
How do I sort a database without also sorting the column heading? 1

Back
Top