Select all columns and rows

Hello.

I need when I select a cell, the entire column of that cell and also the entire row of that cell will be highlighted.
How can I do this?
Thank you.

Click on the letter above the column.
Then click with CTRL + the number of the row.

84958 HB Screenshot

1 Like

Maybe @afshin only needs to highlight, not to select (as the title say). There is a similar question a few months ago, and I think that the answer included macros.

I found these ones:

1 Like