automatically add borders to a cell after entry is complete
 

I've seen this done before. I would like to format the cells in my
spreadsheet to automatically add a border to seperate one cell entry from the
next after I'm finished with the entry. In other words after I tab out of the
cell.

Thanks,
BKD

automatically add borders to a cell after entry is complete
 

you can set a conditional formatting.
Highlight the area you will input numbers

go to format-- conditional Formatting-- cell value is change to not equal
to 0
click on format, select border-- choose one with all borders around it,
click ok and ok again. now if you input any number except 0 you will see the
borders.

hope it help

Nikki

"BKD" wrote:

I've seen this done before. I would like to format the cells in my
spreadsheet to automatically add a border to seperate one cell entry from the
next after I'm finished with the entry. In other words after I tab out of the
cell.

Thanks,
BKD

automatically add borders to a cell after entry is complete
 

Thank you, so simple I didn't think about coditional formatting.

BKD

"Nikki" wrote:

you can set a conditional formatting.
Highlight the area you will input numbers

go to format-- conditional Formatting-- cell value is change to not equal
to 0
click on format, select border-- choose one with all borders around it,
click ok and ok again. now if you input any number except 0 you will see the
borders.

hope it help

Nikki

"BKD" wrote:

I've seen this done before. I would like to format the cells in my
spreadsheet to automatically add a border to seperate one cell entry from the
next after I'm finished with the entry. In other words after I tab out of the
cell.

Thanks,
BKD