I am not sure whethr I have understood you.
if you highlight a cell and righ clcik and click enter
in the <insert window you can click <shift cells down and ok it
in this case only this cell is shifted down other cells in the row remain as
they are.
But if you want the entire row is to be shifted down click in the <insert
window
click <entire row and ok it.
mine excel 2000

"Gee" wrote in message
...
I have a couple of columns in which I am comparing data and a formula that
runs true or false on the right most column. Where it returns false I
have
inserted a blank line to separate that cell entry, but I then need to
shift
cells up or down to run the formula again in the rest of he spreadsheet,
however I am not getting the option when I right click to shift cells -
can
anyone help?