Copy a SharePoint List Value to Selected Items in the Same Column
Question details
Copy a value from one SharePoint list item to selected items in the same column.

- Product
- SharePoint Lists
- Device & OS
- not provided
- Scenario
- A user wants to reuse one item's field value in the same field of other selected list items.
- Observed behavior
- A SharePoint calculated column cannot reference a specific list item like an Excel formula references a cell.
Identify the source item, the target items, and the column you want to update. Make sure you have permission to edit the list and that the target column is editable.
Copy and paste the value in SharePoint grid view
Use grid editing when you only need to update a few selected items.
Open the list in SharePoint and select Edit in grid view.
Select the source field in the column and copy its contents using your keyboard or the context menu.
Select the corresponding field in each target item and paste the value. Repeat for each item you want to update.
Select Exit grid view and check the updated items in the list.

Use Power Automate to copy a value to marked items
Use a flow when you need to repeat the update for many items.
Work with Excel-style tables in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to bring existing files across. WPS does not change how SharePoint list formulas work.

Frequently Asked Questions
Can a SharePoint calculated column reference another list item?
No. A calculated column works with values in the current item and does not provide Excel-style cell references to a specific different list item. Use grid editing or a flow to copy the value instead.
How do I copy a value to a few list items?
Open the list, select Edit in grid view, copy the source field, and paste it into the same column for each target item.
Can I automate updates to only certain items?
Yes. Mark the target items with a Yes/No column, then use Power Automate Get items to retrieve the marked items and Update item inside an Apply to each loop.
Will changes to an Excel table automatically update a list created from it?
No. Exporting an Excel table to a new SharePoint list does not create an ongoing data connection. Later edits to the Excel table are not automatically reflected in the list.




