| ||||||
| 5/18 |
| 2004/10/19-21 [Computer/SW/Languages] UID:34240 Activity:low |
10/10 Does anyone know how to "double space" a sheet in Excel?
My "double space" I mean to insert a blank row after each
filled-in row? Thanks.
\_ I don't know, but why would you want to do that?
\- cat foo.xls | sed G
\_ In Sheet2, use this:
=IF(MOD(ROW(),2), INDIRECT(CONCATENATE("Sheet1!","R",ROUNDUP(ROW()/2,\
0),"C",COLUMN()),FALSE), "")
copy it around to taste |