Berkeley CSUA MOTD:Entry 34240
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/05/24 [General] UID:1000 Activity:popular
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