SharePoint Document Issues

Copy a SharePoint List Value to Selected Items in the Same Column

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

Copy a value from one SharePoint list item to selected items in the same column.

Copy a SharePoint List Value 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.
Before you start

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.

Solution 1Recommended

Copy and paste the value in SharePoint grid view

Use grid editing when you only need to update a few selected items.

1
Open grid editing

Open the list in SharePoint and select Edit in grid view.

2
Copy the source value

Select the source field in the column and copy its contents using your keyboard or the context menu.

3
Paste into target items

Select the corresponding field in each target item and paste the value. Repeat for each item you want to update.

4
Finish editing

Select Exit grid view and check the updated items in the list.

Copy and paste the value in SharePoint grid view
Free Microsoft Office alternative

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.

Copy values between spreadsheet cells or use cell-reference formulasOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for everyday spreadsheet tasksMove existing Office files into a lightweight workspace
microsoft office alternative - wps office

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.