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.

Create a powerful macro

Create a powerful macro - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create a powerful macro

“

- [Instructor] If you're looking at this worksheet 2 for the first time, you can imagine it would be 3 really helpful if we knew which cells had formulas in them. 4 We can do that pretty quickly. 5 Make sure you click a single cell first 6 and then on the home tab of the ribbon off to the right, 7 find and select, Choose Formulas, 8 and all the formula cells are highlighted. 9 You can imagine too, it would be helpful to remember 10 where these cells are by applying a background color. 11 So on the left side of the home tab in the font group, 12 the fill color bucket, click the drop arrow. 13 Be sure to choose a light color. 14 And you can get a preview here of this, a light color 15 so you can see the numbers through it, 16 perhaps this color here. 17 Now if you find that useful 18 and you think you'd be using it a lot, 19 why not make it instantly available by way 20 of either a keystroke shortcut and 21 or a new…

Contents