Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |