Unwanted Cells
 

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

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

If by using you mean selected, then the only way I see is to
use a macro. If you just want the best way to color everything
but a specific area then I think you already have the easiest to
implement answer.

You can invoke the macro with an assigned shortcut,
with a toolbar button, or from a shape. More information
on installing and using a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Sub gray_unselected()
Cells.Interior.ColorIndex = 15
Selection.Interior.ColorIndex = xlNone
End Sub

Obviously using does not mean the used range, but I guess it
could imply the current range Ctrl+Shift+asterisk
then you would use either answer accordingly.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"billy2willy" wrote in message
...

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