many of these are not the optimum method...
because they rely on you scanning for and clicking each relevant cell
Much better selecting by using Go to, Special... or Find and Replace (my favourite for this example as it's easily undone or repeated and won't lose your current position/view or empty the clipboard)