| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way of viewing the formula of a locked cell?
Thanks!
"Elkar" wrote: To the left of the Formula Bar, you should see the "Name Box". Type the cell name that you want to view the contents of in here. Then press Enter. Your desired cell should now be selected, and the formula should be displayed in the formula bar. HTH, Elkar "td" wrote: As above does anyone know if it is possible to view a cells formula when the cell is locked and sheet protected? Idea is to still see where the number is linked to but not be able to make any changes? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula viewing format | Excel Worksheet Functions | |||
| viewing all words in a cell | Excel Discussion (Misc queries) | |||
| Formula in Cell changes even if it's locked | Excel Discussion (Misc queries) | |||
| Viewing LOCKED cells | Excel Discussion (Misc queries) | |||
| Excel 2003 when closing Excel after having opened a project locked for viewing.. password prompt??? | Excel Discussion (Misc queries) | |||
Threaded Mode
