Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight cells that are included in calculated cell
I have a cell with a calculation in it. I want to hightlight the cells that
are included in the calculation. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight cells that are included in calculated cell
click on the cell and touch CNTRL+[
-- Gary''s Student - gsnu201003 "Cell Calculation" wrote: I have a cell with a calculation in it. I want to hightlight the cells that are included in the calculation. |
#3
|
|||
|
|||
Quote:
option 1: To do it manually, press the F5 key to bring up the GoTo dialog. Click the Special Cells button. On the next screen, select Formulas (it's an option on the right). Excel will select all of the cells that match. Now it's just a matter of applying formatting. option 2: Excel has a built in feature of "Trace Dependents" (which shows arrows to show you the calculated cells) Select the range containing your data. Excel 2007 - Formulas - Trace Dependents all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does picking an cell highlight two cells? | Excel Discussion (Misc queries) | |||
If this cell is highlighted, then also highlight these cells | Excel Discussion (Misc queries) | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Cells not included in formulas | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |