How can I select cell in Microsoft Excel if I have the list of cell numbers. For example, if I have a list of cell numbers, [A1, B22, C43, D12, E9,......], and I want to select only these cells at once, how can I do so?
I tried to search online for answers, but no hint was there for this.
CodePudding user response：
- From HOME tab select Find & Select then Go To.
- Input your preferred ranges in
Referencesseparating by comma to select discontinuous ranges.
CodePudding user response：
You can just use =A1, B22, C43, D12, E9 to select the cells
