Aug 19 2019 12:58 PM
Aug 20 2019 08:49 PM - edited Aug 21 2019 01:13 PM
Are you sure that you are selecting the whole column?
If you want to replace values in a specific column, you need to select the whole column and to select the whole column, click on the column header (i.e. click on column letter)
Or if you want to replace values in a selected range, select all the cells where you want to replace a value and then invoke the replace window by pressing Ctrl+H.
But if only one cell is selected on the sheet, Replace All will replace all the values from all the cells on the sheet.
Oct 27 2022 04:46 AM
I realise that you will have solved your problem by now but, as I was looking for an answer, I post this in case anyone finds it useful.
I had this problem but knew that it ought to work as the respondents said - it does but only if you have the search looking By Columns, not By Rows.
Jan 06 2023 09:00 PM