Excel and Word - Overwrite Cell option

Lisa0721
NewLounger
Posts: 1
Joined: 28 Jul 2024, 17:29

Excel and Word - Overwrite Cell option

Post by Lisa0721 »

I have a customer who copies a cell in Excel and uses “paste special” in Word to paste into a Word cell. She doesn’t always have the overwrite cell option available. Anyone know why that would be? Is it unreliable? Is there something missing from the Excel cell or the Word cell where it doesn’t allow that option to appear? Just need to see if I can fix it in some way. Thank you.

User avatar
HansV
Administrator
Posts: 79321
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel and Word - Overwrite Cell option

Post by HansV »

Welcome to Eileen's Lounge!
This appears to be a quirk/bug in Word. When I try this, the 'Overwrite Cells' option is displayed if I right-click a cell in any column except the first one. It does not appear if I right-click in the first column.
As a workaround, paste into another column, then copy again. The 'Overwrite Cells' option should then appear in the first column too.
Best wishes,
Hans