Set data validation If you want to insert different task priorities (High, Medium, or Low) and Status (Pending, Ongoing, Skipped, Completed) in your Excel sheet, you need to use Data validation.

Figure E Use Excel’s BYROW () to evaluate by rows. As with Excel’s BYCOL (), you could do this with several MAX () functions, but that would require 11 functions and would return 11 result values.

If you come across data you want to add to an Excel spreadsheet, but copying and pasting it doesn’t work (or seems like too much work), you can also take a screenshot of the table. Then, you can ...