Here’s an Easier Way to Copy and Paste Repetitive Data in Excel

News
By published

Copy and paste works great, if you’re selecting data that’s in the same column, or row. If the data is disjointed, there’s a much better way to organize it than copy and pasting each instance, column, or row individually. It’s not the only way to do this, but it’s certainly the fastest and easiest to pick up in minutes.

1. Start typing the same text in multiple columns.

2. CTRL + Click each instance of the name. You’ll only need two or three instances for Excel to recognize the pattern, so you won’t need to do this for long.

3. Continue CTRL + Clicking the empty spaces the name will go.

4. Once done, type the name one last time and press CTRL + Enter. You’ll see the name has now been filled in each empty column you selected.

5. Repeat these steps for additional names or titles.

Microsoft Excel Tips

Bryan Clark
Latest in Work & Collaboration Tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.
I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction
Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
The 39.7-inch Dell UltraSharp monitor beside a Laptop Mag deals icon in front of an orange and yellow background
Top 5 Dell UltraSharp monitor deals: Save up to $300 on the ultimate productivity monitor!
The Logitech MX Creative Console seen from above on a white table
Logitech MX Creative Console review: Is this alternative stream deck a creative game changer?
Google Search
Google Reverse Image Search: How to search with an image in Google
docs in proton drive
What is Proton Docs? Why you might want to give the privacy-focused Google competitor a chance
Latest in News
WWDC 2025 could mark the beginning of the end for certain iPhone users
Error when installing Google Chrome on the Asus Vivobook 16 Flip, on a white desk against a blue background.
"This app can't run on your PC": Google's Chrome Installer broke on Windows, but there's a fix
Nintendo Switch 2 handheld gaming console
Nintendo Switch 2 preorder date: It might be a lot closer than you think, say tipsters
Microsoft Surface Laptop (7th Edition, 2024)
Windows-on-Arm woes: Amazon warns customers about Surface laptop returns
Apple Watch Series 8
Siri is the biggest obstacle to making the Apple Watch an AI hit
The Lenovo Legion Go S in hand running Death's Door in front of a wood table
The Lenovo Legion Go S is a Z1 Extreme trap you'll want to avoid — Here's why
More about work collaboration tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.

I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction

Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
The unbelievably compact form of the Mac Mini M4, seen in this animated GIF that shows how heat dissapates through its body, is made possible by the power-efficient performance of Apple silicon combined with an all-new innovative thermal architecture.

The Mac Mini desktop PC is the hipster's choice for best PC. And it's on sale.
See more latest