Microsoft Excel Question: Download MS Excel PDF
How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?
Answers:
Answer #1Option A:
1. Choose Edit + Go To (or press Ctrl + F5).
2. Select Special.
3. Select Formulas.
4. Click OK.
Option B:
1. Choose Tools + Options.
2. Select the View Tab
3. In Window Options choose the check box 'Formulas'.
4. Click OK
1. Choose Edit + Go To (or press Ctrl + F5).
2. Select Special.
3. Select Formulas.
4. Click OK.
Option B:
1. Choose Tools + Options.
2. Select the View Tab
3. In Window Options choose the check box 'Formulas'.
4. Click OK
Answer #2No
| Previous Question | Next Question |
| Is there a way to apply the same formatting to every sheet in a workbook in Excel? | How can I printout the formulas in an Excel spreadsheet - rather than the results? |