Forum Discussion
Using Copilot in Excel to show additional units of measure
Greetings, This is the fifth in a series of posts that provides examples of what is possible with Copilot in Excel. Today I will continue with the list of major league baseball ballparks from yesterday.
Since I previously created a new center field distance column, measured in feet, I’d like to add a separate column that shows the distance in meters. To accomplish this, I'll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt:
Add a new column that shows the center field distance in meters
Copilot in Excel looks at the content in the table and then suggests inserting a new calculated column that multiples the center field distance by 0.3048 to calculate the distance in meters.
Hovering the mouse cursor over the "Insert columns" button in the copilot pane shows a preview of what inserting the new column formulas will look like. From the preview, it looks like it is doing what I wanted.
Clicking on the Insert Column button will accept the proposed change, inserting a new calculated column formula that converts the center field distance from feet to meters.
Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.