This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello! Please help! I have a spread sheet that has the identical data on multiple cells. I want to be able to enter the data on the first cell and have it appear automaticlly on muliple cells to save me some time and lots of typing. I know that I can simply "copy & paste" or I can select ALL the cells that need to have the same data, enter the data & hit CTRL + Enter but that takes too much time as well. Because lets say the amout of cells I need to have the same data is 100...I don't want to have to select ALL 100 cells! Is there a formula out there that can help me achive this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
when you copy-paste instead of paste choose paste-special and choose Paste Link
Now all pasted cells are Links and update automatically
:D glad to help
remember Save often and experiment a bit, Excel is very user-friendly and most things pop on their own... or are there waiting to click on them...
cheers
Oh my goodness it was so simple!! So simple I'm embarrassed that I couldn't figure it out on my own...feeling really silly right about now but happy and exited at the same time! haha! Thank you soooooo much! I have been trying to figure this out since Friday! Thank you, thank you, thank you!!! God Bless you!