How to change just a few fows in a field in table datasheet view

[twgonder]

Okay, it's early, I'm not fully awake yet,


for five minutes I thought I was going crazy.

I see that I'm not understanding something that seems pretty obvious, but it's not.
(One might say, before trashing my data, I should have seen what was going on in the preview, but I like to keep my eye on the ball and not the back rows of the stadium, and as I said, it's still a bit early.)

I'm cleaning up some stuff, working in the datasheet view of a table and need to replace one field in certain rows,
in the example below, I need to change the 1 to 2 in the highlighted "cells"



However, when I finish, the entire field (column) was replaced, not just the selected cells.
Looking in the Find and Replace, Replace tab, Look In: I see current field, but not current selection (which I wrongly assumed
would be by default, since that's what selections are normally for--can you imagine Word changing the entire document with a replace,
not just what you selected? WTF Access?).

Some of the selections might be a couple hundred records, so I don't want to sit there are press Replace each time.
I just want to replace all in the selection. Obvious and simple, no?

So, what am I missing here (I've tried everything I can think of)? How do I mass replace just the selected "1"s and not all the "1"s in the field?

Finally, as I don't see a sub-forum dedicated to tables, is this the correct place for this question?

[ranman256]

filter the records you do want to change,
then do global replace.

[twgonder]

filter the records you do want to change,
then do global replace.

Yea, thanks, that makes MS sense. Silly me for trying to do it the simple way.
Beyond the example given (to KISS for those that like to troll), I have to do multiple sorts to get it all aligned (which I still haven't figured out how to do in datasheet view of a table), we might as well make it a complicated query.
Since I have to do this dozens of times, we can make a whole day endeavor of the otherwise simple task.