microsoft excel courses - How to highlight columns + rows in one go? | Excel forum

Two ways to do this. To select all rows and all columns in a spreadsheet just click on the grey square at the top left of the spreadsheet, at the intersection of the column and row titles. Secondly, if you name the range of cells you want to highlight, by entering a name (e.g. "addresses") in the range bar, you can use the drop down arrow to the right of the range bar to select those cells in the future.

Anthony