| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
F2 Edit Key
I have 2 screens. Sometimes, when I have one excel sheet on one screen, and
another in the same workbook on the other screen, hitting F2 on a formula will highlight the dependent cells on each screen (i.e., in each worksheet). Other times, it only highlights the dependent cells on the sheet on which my formula exists. It is quite helpful to see the depedent cells on in all sheets. Any thoughts? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
F2 Edit Key
tools
formula auditing Trace precedents Check the precedents and then delete the lines with tools formula auditing Remove all arrows "dr" wrote in message ... I have 2 screens. Sometimes, when I have one excel sheet on one screen, and another in the same workbook on the other screen, hitting F2 on a formula will highlight the dependent cells on each screen (i.e., in each worksheet). Other times, it only highlights the dependent cells on the sheet on which my formula exists. It is quite helpful to see the depedent cells on in all sheets. Any thoughts? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
F2 Edit Key
Thanks - I'm looking for the way to do it without trace precedents, as doing
so creates the reference box to another sheet, whereas I'm looking to see the boxes immediately highlighted. But appreciate the suggestion! thx "Leo Rod" wrote: tools formula auditing Trace precedents Check the precedents and then delete the lines with tools formula auditing Remove all arrows "dr" wrote in message ... I have 2 screens. Sometimes, when I have one excel sheet on one screen, and another in the same workbook on the other screen, hitting F2 on a formula will highlight the dependent cells on each screen (i.e., in each worksheet). Other times, it only highlights the dependent cells on the sheet on which my formula exists. It is quite helpful to see the depedent cells on in all sheets. Any thoughts? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
F2 Edit Key
Thanks - I'm looking for the way to do it without trace precedents, as doing
so creates the reference box to another sheet, whereas I'm looking to see the boxes immediately highlighted. But appreciate the suggestion! thx "Leo Rod" wrote: tools formula auditing Trace precedents Check the precedents and then delete the lines with tools formula auditing Remove all arrows "dr" wrote in message ... I have 2 screens. Sometimes, when I have one excel sheet on one screen, and another in the same workbook on the other screen, hitting F2 on a formula will highlight the dependent cells on each screen (i.e., in each worksheet). Other times, it only highlights the dependent cells on the sheet on which my formula exists. It is quite helpful to see the depedent cells on in all sheets. Any thoughts? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
F2 Edit Key
tools
formula auditing Trace precedents Check the precedents and then delete the lines with tools formula auditing Remove all arrows "dr" wrote in message ... I have 2 screens. Sometimes, when I have one excel sheet on one screen, and another in the same workbook on the other screen, hitting F2 on a formula will highlight the dependent cells on each screen (i.e., in each worksheet). Other times, it only highlights the dependent cells on the sheet on which my formula exists. It is quite helpful to see the depedent cells on in all sheets. Any thoughts? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit? | Excel Discussion (Misc queries) | |||
| Edit hyperlink | Excel Discussion (Misc queries) | |||
| fx-edit | New Users to Excel | |||
| fx instead of "=" on formula edit bar | Excel Discussion (Misc queries) | |||
| Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel | |||
Hybrid Mode
