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]
