Microsoft Excel Question:
Download Questions PDF

How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?


Answer #1
Option 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

Answer #2

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext 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?