Super Repeating Data Shortcut

When working in MS Excel, do you ever find yourself repeatedly entering the same formula or data?

What do you do?

Do you type it again and again and again into each cell?

Maybe you save some time by entering it once then copying and pasting it everywhere else?

That’s not a bad way to do it, but what if you had a faster way?

Let’s say, a way that would allow you to enter the data or formula only once and it’s everywhere you need it instantly. How does that sound?


Of course you are! Anyone who works with Excel frequently would be. So, let’s take a look.

  • The first thing you need to do is select all the cells that the data item or formula should be in.
  • Next, type the data or formula.
  • Finally, hit Ctrl + Enter.

Kaboom! All the cells contain the same information.


P.S. – The formula will adjust for relative references, just like they do during a copy / paste.

Even better!

~ April