|
5/24 |
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 |