I don't have an answer to (1) - highlighting the range first has
always worked for me.

As regards (2) - once you have highlighted the cells that you want to
change, just press the <delete key. If you want to use Find &
Replace, just leave the Replace With box completely blank.

Hope this helps.

Pete


On Jul 13, 12:50 am, JG14 wrote:
I have two questions, PLEASE HELP:

1) I need to find & replace values within certain columns only, for the
entire workbook. I've tried selecting those columns before pressing CTRL + H,
but it still replaces values outside of the range. I've also tried each
setting of the advanced options, nothing works.

2) I need to replace values with a blank cell, I've tried "", and that
actually places "" in the cell, I also don't want to just enter a space,
because that's not actually blank, the space would be a character.

Thanks!