Unwanted Cells

[billy2willy]

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.

[Sloth]

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
>
>

[David McRitchie]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>