1. column
  2. TECHNOLOGY Q&A

Identify Multiple Rows and Columns in Excel

BY STANLEY ZAROWIN

Please note: This item is from our archives and was published in 2002. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

No Results

TOPICS

    Uncategorized Article

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.