selecting non-contiguous cells
 

In EXCEL 2007,trying to select multiple non-contiguous cells. Unlike in Excel
2003, where holding down the CTRL key enables selection of non-contiguous
cells, that method does not work. How can I do this in Excel 2007.

selecting non-contiguous cells
 

Works exactly the same in Excel 2007 as in 2003.

Maybe because the color is so washed out you don't clearly see the
selections.

Try SHIFT + F8 to get into Add mode then select non-contiguous cells.

Any difference?


Gord Dibben MS Excel MVP


On Mon, 1 Feb 2010 13:43:01 -0800, facinadr
wrote:

In EXCEL 2007,trying to select multiple non-contiguous cells. Unlike in Excel
2003, where holding down the CTRL key enables selection of non-contiguous
cells, that method does not work. How can I do this in Excel 2007.