Donna has attended:
Excel Introduction course
Excel Intermediate course
How to highlight columns + rows in one go?
Thanks
Donna
RE: How to highlight columns + rows in one go?
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