A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @Engineer,
Thank you for reaching out to the Microsoft Q&A forum.
What you’re describing sounds more like a limitation / behavior change in Excel for the web rather than a setting in your workbook.
Excel Online does not always handle partial text selection inside a cell the same way the desktop app does, so in some cases it may copy the full cell value instead of only the highlighted portion. Microsoft also mentions that copy/paste behavior in Office for the web can differ from the desktop apps due to browser limitations.
Reference: Copy and paste in Office for the web
A few things you can try:
• Double-click the cell first (or press F2), then highlight only the text and use Ctrl + C
• Test in InPrivate/ Incognito mode
• Disable browser extensions temporarily
• Sign out and back in
• Use Open in Desktop App when you need to copy only part of the text inside a cell
If this was working normally before and only changed recently, then it may be a service-side change in Excel for the web rather than something you can fix locally. In that case, the best next step would be to send feedback from Excel for the web or have your Microsoft 365 admin open a support ticket with Microsoft.
For now, the desktop app would be the most reliable workaround for this specific workflow.
I hope this helps.