Here is one way. I don't know if it is the best way.

Highlight Column K
Ctrl+Shift+(right arrow key)
This will select Every column except A-J

Then hold ctrl and select row 11
Ctrl+Shift+(down arrow key)
This will select every row except 1-10 (you will still have the columns
selected from the previous step.)

"billy2willy" wrote:


When using a spreadsheet what is the best way to highlight everything
else except the data that you are using. ie turn everything grey except
a1:j10.


--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=471186