Subdividing a Row into Multiple Rows

[Robert Lee]

I'm trying to recreate a tax form by copying the entire left hand side of the
form and pasting it into an Excel row. Then, I want to subdivide that row
into separate rows-- so each line from the tax form occupies one line of
Excel spread sheet. Can that be done? I'm running Excel 2007 on Windows XP.

By the way an accountant in Kansas has created Form 1040 on an Excel
spreadsheet. See, http://www.excel1040.com. Does anyone know how it did it?

 

[Luke M]

The more probable method is to start with several rows, and merge/combine the
headers into a "single" row.

 

[Robert Lee]

I can't understand what you mean. I could copy a line of the tax form and
paste it onto a row of the spreadsheet. But that takes alot of effort.
What I want to do is 1) copy the entire left-hand side of the tax form; 2)
paste onto a row of the spread sheet; and 3) split that row into separate
rows. Can you elaborate on the alternative you have in mind.