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?
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
Download MS Excel Interview Questions And Answers
PDF
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? |