From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Create on-screen warnings and reminders with comments or data validation messages

Create on-screen warnings and reminders with comments or data validation messages - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create on-screen warnings and reminders with comments or data validation messages

“

- Providing documentation 2 for Excel worksheets is not something 3 that every Excel user is interested in, 4 and yet you can provide valuable information 5 for anybody using this worksheet, 6 or another worksheet, by using either what we call comments 7 or possibly a feature in data validation. 8 It doesn't have a formal name. 9 I'm using the term reminders here, 10 but let's explore these opportunities 11 to provide more information. 12 On this particular worksheet here, 13 as you're looking at this, 14 maybe it's the first time you're seeing it, 15 you might notice the red triangle in cell I7, 16 as I slide the mouse over that cell, there's a pop-up. 17 See Jennifer for more details on this unusual formula. 18 Well, you'll click that cell perhaps, 19 or look in the formula bar, 20 and maybe that raises some questions, 21 you'll call Jennifer, maybe not. 22 Slide off the cell, the pop-up tip disappears. 23…

Contents