Super Repeating Data Shortcut

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?

Interested?

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.

Cool!

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

Even better!
**********************************************************************
For starters, make sure the Autocomplete is turned on under Tools\Options.

Also, if you press ALT + Down arrow, it's the equivalent of using "pick from list" on the right-click menu.

It will show everything listed in the column above, and you can just choose from there.

AutoComplete will only match on exact cell entries and not on individual words within a cell.