I need to make a spreadsheet in Excel 2007 where one column needs two lines of text How do I do that?

Question

The spreadsheet has an Address column, and I want the street adress on one line and the city, state, and zip underneath it.

Answer 1

See if it will work as it did in Office 2000 --
type the first line
then
Alt+Enter
this should put you on the next line in the same cell

I don't know what you are using this for, but I keep several Excel data files. One of the first things we learn is to put the first and last names in two separate columns - this assists alphabetizing.

Secondly, it is a good idea to have separate columns or fields for
address / city-state / zip

This way, if you need to send out a mass mailing, you can sort the file by zip - which I think, is required by the post office for over 200 pieces of bulk mail.

Answer 2

The alt/Enter is correct but if you are creating a database that you want to use for address labels you want to have a separate col for each part of address.

Answer 3

Alt/enter or just cut copy and paste from a sheet thats already made.

Answer 4

Simple: Press ALT/Enter to put a line break into the cell.

That should do it.