| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Viewing formulas
I need to find a formula that's on the sheet I'm working on - I don't know
what it is or where it is and it's causing problems. How can I display all formulas on the sheet I'm working on? -- Lynne Mawson Manchester |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Viewing formulas
Touching CNTRL ~ will toggle the display to shows formulas as opposed to
values in the cells. -- Gary's Student "Lynne Mawson" wrote: I need to find a formula that's on the sheet I'm working on - I don't know what it is or where it is and it's causing problems. How can I display all formulas on the sheet I'm working on? -- Lynne Mawson Manchester |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Viewing formulas
Hi Lynne,
CTRL` (accent grave) toggles formula view You can also look at ToolsFormula editingTrace errors -- Kind regards, Niek Otten Microsoft MVP - Excel "Lynne Mawson" wrote in message ... |I need to find a formula that's on the sheet I'm working on - I don't know | what it is or where it is and it's causing problems. How can I display all | formulas on the sheet I'm working on? | -- | Lynne Mawson | Manchester |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Viewing formulas
Hi Lynne
Type Ctrl + ` that is hold down Control and the key to the left of the number 1 at top left of your keyboard. That is a toggle to switch back and forth between normal view and formula view. -- Regards Roger Govier "Lynne Mawson" wrote in message ... I need to find a formula that's on the sheet I'm working on - I don't know what it is or where it is and it's causing problems. How can I display all formulas on the sheet I'm working on? -- Lynne Mawson Manchester |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Viewing formulas
Edit / Find / =
will take you to the formulas -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) "Lynne Mawson" wrote: I need to find a formula that's on the sheet I'm working on - I don't know what it is or where it is and it's causing problems. How can I display all formulas on the sheet I'm working on? -- Lynne Mawson Manchester |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Cell Formulas | Excel Discussion (Misc queries) | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| Moving worksheets into viewing area | Excel Discussion (Misc queries) | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
