Unwanted Cells

B

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

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.)
 
D

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