Overwrite cells not always available.

Question

Hi. I'm trying to move a group of data (names and numbers) from an excel spreadsheet to a word document in order to print out some labels. Normally I create the spreadsheet (from another program), then copy the cells I want to make labels for. I open a word doc, start a mail merge, and select the template for the labels I want to print.

If I paste the clipboard to any cell other than the top-left cell, I have the option to "overwrite cells" which fits one name to a cell so I can print one name to a label. Easy and pretty much exactly what I want.

Unless I want to start at the beginning. If I select the top left cell, I cannot use the "overwrite cells" option. It simply does not show up as available. This means I have to start not at the beginning, but use the right half of the page before flipping the sheet over, which is just weird and makes it harder to print large sets because I have to run each page twice.

Is there a way to find the "overwrite cells" option for the first cell that I'm not looking at? The only thing I can see are the icons below "Print Special" but there are no other places I can find to select different paste options. he options menu doesn't have anything like this listed that I can find.

Answer 1

Having the some problem as you. Here is how I deal with it:

1. Copy cell from Excel
2. Paste these cell into Word table somewhere else other than top-left using overwrite cell
3. Copy same cell from Word table you used in step 2
4. Now you can paste into top-left cell using overwrite cell function. 

Hope it helps.

Replying to a year old post.

This is the only answer. I dont know why MS support does not reply to unconventional workarounds.

I had this problem, found the solution before finding out this post.

Answer 2

Having the some problem as you. Here is how I deal with it:

1. Copy cell from Excel
2. Paste these cell into Word table somewhere else other than top-left using overwrite cell
3. Copy same cell from Word table you used in step 2
4. Now you can paste into top-left cell using overwrite cell function. 

Hope it helps.

Answer 3

This question has still not been answered.

Answer 4

http://imgur.com/a/rTJl0

Here's a set of screenshots and another attempt to explain the problem. It's fairly straightforward: the overwrite cells option does not exist for all cells, which is annoying and means I have to print everything by halves.

Answer 5

Hello Jeffrey,

I would need more information to assist you with the issue:

Does the Worksheet contains cells that are protected?

If yes, then you may unprotect the cells and try again.

You may also provide a screenshot of the issue for better suggestion.

Provide necessary information to better help you.

Thank you