I am always intrigued by questions like this. Assuming your start cell is A1, enter the following formula in A2 and drag it down: =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+1;"")
Joe Conner wrote: > > Yes. In cell A1 enter 1. > In cell A3 enter =A1+1 > Click on cell A2. > Holding down the shift key, > press the down arrow 2 times. > This will paint cells A2, A3. > Copy (CTRL C). > Click on cell A4. > Hold down the shift key. > Press CTRL and Down Arrow > Paste (CTRL V). > There you have it. > > Joe Conner, Poulsbo, WA USA > > > > Kirill S. Palagin wrote: >> Hello. >> >> Is there a (non-macro) way to generate fill series skipping every second >> row with increment >1? >> That is I want result to be like "1, blank, 3, blank, 5, blank, 7". >> >> Thanks a lot. >> WBR, >> K. Palagin. >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Calc---Fill-series---filling-every-second-row-with-increment%3E1---tf3551502.html#a9915546 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
