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.

Step 1 when importing data into Excel by photo is to take a photo of the table. It is better not to include surrounding text. The image section in this example is too large. IDG ...

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 ...