Excel Tip: Enter the same data in multiple cells at once

Before I get into this week's post, I'd like to let you know that Mynda Treacy's very popular Excel Dashboards course is once again open for enrolment. If you haven't already taken this course, I'd highly recommend it, and you can get 20% off if you enrol by 22nd January. I'll also throw in my Introduction to Excel PivotTables course free of charge, just enter FEECHAN in the Coupon Code field in the Cart or Checkout.

Anyway, on with this week's post. Just a quick one this time.

In the comments of last week's post, Bill Simpson of Texas mentioned a simple little tip that I hadn't seen before. We're all still learning!

I thought I'd share it with you all too.

If you want to enter the same thing into multiple cells, you can enter it into one and copy it into each of the other cells, however a quicker solution allows you to enter the same thing into all of those cells at once.

Just take the following steps:

• Highlight all of the relevant cells (you can use the mouse to highlight a range, or click on each of the individual cells while holding down the Ctrl key)
• While they are all highlighted, type what you want to
• Instead of hitting Enter, hit Ctrl + Enter, the information will appear in all of the selected cells.

That's it. Don't forget to take a look at Mynda's course while you can get 20% off.

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".