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 |
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 |
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 |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com