| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
Linear Mode
