To view formulas in a cell, which icon should we select from the formulas tab?
UWU its 100 points PLZ thank moi
Answers
Answered by
3
- Press [F5].
- Click Special.
- Select Formulas. By default, this option selects all formula cells in the current sheet, but you can be more selective by excluding specific suboptions: Number, Text, Logical, and Errors.
- Click OK and Excel selects cells that contain formulas.
Answered by
181
❥Select the cells you want to analyze.
❥Go to formulas tab > formulas auditing > trace dependents.
❥Click on trace dependents button to see the cells that are affected by the active cell.
❥It will show a blue arrow that links the active cells and the other cells related to the selected cells.
Similar questions
Computer Science,
6 months ago
Chemistry,
6 months ago
Math,
1 year ago
English,
1 year ago
Math,
1 year ago