changing the way Excel displays selected cells

P

P Boric

Is there a way to change the way Excel displays selected cells? I'm
interested in viewing all the selected cells highlighted (with light blue for
instance), but by default excel highlights all the cells but not the first one
the same occurs when you define a range with no adyacents cells
 
B

Bryan Hessey

Your definition of the display is not quite correct.

Excel highlights the current cell, Excel also highlights a selecte
range.

The currently selected cell is generally the first of a range, bu
press enter and the current cell changes and becomes the second, the
third etc in the range.

You cannot have a cell not currently selected, which is what you ar
indirectly asking for in your colour display
 
Top