Subdividing a Row into Multiple Rows
 

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?

Subdividing a Row into Multiple Rows
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Robert Lee" wrote:

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?

Subdividing a Row into Multiple Rows
 

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.

"Luke M" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Robert Lee" wrote:

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?