That's why skipping rows is a very bad layout. You should reconsider
deleting all the blank rows first by selecting a column that always has data
in it. Then hit Edit--Go to--Special--Blanks. Then hit Edit--Delete and
tell it "entire row". Then, you can make the row height higher instead of
using extra rows for spacing.

However, if you must, put the formula in 3 of the cells. Select those 3
cells, plus one blank cell beneath each of them. Then copy down. It should
copy the formulas only to the appropriate ones and the blanks to the
appropriate ones.
*******************
~Anne Troy

www.OfficeArticles.com


"eenstudent" wrote
in message ...

--------------------------------------------------------------------------
------

I have a formula I want to place in exactly every other (vertical)
cell. Is there a simple way to skip every other row without copying and
pasting (I have to enter some 8000 data points!!).

Thanks in advance,

eenstudent


--
eenstudent
------------------------------------------------------------------------
eenstudent's Profile:
http://www.excelforum.com/member.php...o&userid=25192
View this thread: http://www.excelforum.com/showthread...hreadid=387641