Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting into Excel
Is there a way to export into excel by skiping every other row.
I have a report that i would like to export into excel. It places it on each row. I would like a row between each row of data. I have tried placing an unbound field on my report and that did not work. Any other suggestions? Thanks Chey |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting into Excel
You can add the blank rows after the data is added...
If you have 100 rows, then in an adjacent column fill down numbers from 1 to 100 then continue on down with another fill of 1 to 100. Sort your data including the new column by the new column. Your done. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Chey" wrote in message Is there a way to export into excel by skiping every other row. I have a report that i would like to export into excel. It places it on each row. I would like a row between each row of data. I have tried placing an unbound field on my report and that did not work. Any other suggestions? Thanks Chey |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting into Excel
inmport the list, then you could hold 'ctrl' and slect each row in the list
by turn, then right click one of the row numbers and select insert, this will insert a row in-between each row of data, but if you have a long list it might be time consuming to select each row. "Chey" wrote: Is there a way to export into excel by skiping every other row. I have a report that i would like to export into excel. It places it on each row. I would like a row between each row of data. I have tried placing an unbound field on my report and that did not work. Any other suggestions? Thanks Chey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
Exporting to Excel from a program like Oracle | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting numbers into Excel | Excel Discussion (Misc queries) |