Search Not Just Numbers

Tuesday 13 January 2015

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.


Excel Dasboard Course

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".

4 comments:

  1. Glen: I prefer Ctrl/Enter to using Fill. The mindset is then one of entering the same formula throughout a Range rather than one of replicating Cell content. It also means Ctrl/Shift/Enter comes as less of a shock!

    In a sense it is the keyboard equivalent of the VBA Range properties
    Sub myFill()
    [x].Formula = "= Rand()"
    [y].FormulaArray = "= x^2"
    End Sub

    Peter

    ReplyDelete
  2. Glen,

    Just as a general thought...

    What is your opinion of spreadsheets as a part of of a robust financial reporting solution with regards to:

    (1) reliability
    (2) maintenance
    (3) development
    (4) security

    Since there may be some aspects of spreadsheets which may fall short of current software engineering disciplines.

    SARBOX is of course a consideration.

    Kind regards

    ReplyDelete
  3. Best tips to enter same data in multiple cells at once. It is the easy way to enter the data in multiple cell. Thanks for your post.
    SEO Training Institute in Chennai

    ReplyDelete