On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

Click the source menu to take you to the sheet with parameters. Select the values you want to assign and click ok. Thats it. You can now see a drop-down menu appearing under the Task Priority column.

Excel drop-down lists are ideal for fields like Material Type, Print Status, or printer names. Excel’s data validation can restrict entries to predefined lists, preventing typos and inconsistencies.