Q. If I write A1:A10 in Excel, I know that includes all the cells in the A row from 1 to 10. But how can I refer to multiple columns or rows, such as all the columns between C and G or all the rows between 2 and 7?
A. If you want to refer to columns C through E, the address is C:E. And if you want to refer to rows 2 through 9, the address is 2:9.