| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double Click to see formula source data? Set up?
Does anyone know how to set your Excel to see the formula source data by
double clicking cell that contains the formula? For example say cell B4 contains the formula =A4 + 10. If you double click cell B4 it takes you back to cell A4 (since its source data). Do you know how to set this up? I got a new computer this week and my Excel isn't coorperating! -- gt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Double Click to see formula source data? Set up?
Toolsoptionsedit, deselect edit directly in cell
Of course if you have it checked you will still get the source highlighted -- Regards, Peo Sjoblom "gt" wrote in message ... Does anyone know how to set your Excel to see the formula source data by double clicking cell that contains the formula? For example say cell B4 contains the formula =A4 + 10. If you double click cell B4 it takes you back to cell A4 (since its source data). Do you know how to set this up? I got a new computer this week and my Excel isn't coorperating! -- gt |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Double Click to see formula source data? Set up?
You could *retain* the "Edit In Cell" functionality, and still move back and
forth between referenced formula cells by using: <Ctrl [ AND <Ctrl ] -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Peo Sjoblom" wrote in message ... Toolsoptionsedit, deselect edit directly in cell Of course if you have it checked you will still get the source highlighted -- Regards, Peo Sjoblom "gt" wrote in message ... Does anyone know how to set your Excel to see the formula source data by double clicking cell that contains the formula? For example say cell B4 contains the formula =A4 + 10. If you double click cell B4 it takes you back to cell A4 (since its source data). Do you know how to set this up? I got a new computer this week and my Excel isn't coorperating! -- gt |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Double Click to see formula source data? Set up?
hi,
i don't (by double clicking) but you have that available to you. toolsformula auditingtrace precedents Regards FSt1 "gt" wrote: Does anyone know how to set your Excel to see the formula source data by double clicking cell that contains the formula? For example say cell B4 contains the formula =A4 + 10. If you double click cell B4 it takes you back to cell A4 (since its source data). Do you know how to set this up? I got a new computer this week and my Excel isn't coorperating! -- gt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double click | Excel Discussion (Misc queries) | |||
| Need to double-click for data to be recognised as date?! | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Double click in a Cell | Excel Discussion (Misc queries) | |||
| Before Double-Click | Excel Discussion (Misc queries) | |||
Hybrid Mode
