Column Wrap in Excel - ie word with columns

B

Bryan

Ok,
I have a list of existing values on a spreadsheet. names and apartment numbers in 4 columns total. I would like to be able to insert a new row into the first two columns and have excel wrap the bottom row of values up to the 3 and 4 columns of values. This operation is comon in Word, 2 columns and when the text has reached the bottom the text wraps to the top of the document

Can this be done in excel? I'm pretty seasoned with Excel but the person asking me of this is very amature.

Thanks in advanc
Bryan M, MN
 
D

Dave Peterson

Word does a nice job when you use Format|columns. It'll wrap things nicely.

Excel ain't much of a word processor. It's nice to create lists that keep going
down (to row 65536???).

I'd either keep the data in MSWord or keep it in Excel and when I wanted to
print, I'd copy|paste into Word and apply format|columns. (You can sort your
list in word, too.)

But if you must keep it in excel, I'd use a macro like David McRitchie's
snakecol right before I wanted to print it (publish it???).

I'd keep the raw data in nice columns going down the worksheet. It'll make
filters/sorts easier.

David's SnakeCols macro can be found at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top