hi,

i often encounter this scenario.

when given a single cell, e.g. B3, i want to select the whole B column,
or the whole of row 3. for example to hightlight the whole row or paste a
formula from the first cell to the whole column.

is the a gd way to do this?
thnks.