Shift Cells Up

G

Gee

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?
 
B

bob777

Could you put conditional formatting on the first 2 columns so that when
column 3 indicates false, the cells in cols 1 and 2 are coloured red....
 
G

Gee

No because I the rest of the data is out of zinc to run the formula. I need
the option to shift cells up so the data is aligned again ro run the formula.
I've done this before but am just not getting the option shift cells.
 
W

wasim

:

in a cell when i give the slanted lines from borders it skips some space
above and they donot fit to corners
 
Top