From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Display and highlight worksheet formula cells

Display and highlight worksheet formula cells - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Display and highlight worksheet formula cells

“

- [Instructor] On this worksheet, we've got a bit of a mess. 2 We're trying to locate the formulas. 3 We know some are there, we found one or two. 4 We'd like to find all of them. 5 We'd also like to be able to annotate this worksheet, 6 keep track of what's happening with formulas as well. 7 There are three different techniques you should be aware of. 8 The first one involves a command 9 that also has a keystroke shortcut. 10 In any worksheet at any time, 11 if you go to the formulas tab in the ribbon 12 off to the right, there's a formula auditing group. 13 Click the choice show formulas, 14 and immediately what happens is 15 all column widths are doubled. 16 But more important than that is the fact that 17 wherever there is a formula, like in cell B7, 18 we see the formula. 19 We're not seeing the results of the formulas, 20 we're seeing the actual formulas. 21 And the reason the width of the columns has been…

Contents