- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Repeating Data Super Shortcut

Repeating Data Super 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 copy / pasting it everywhere else?

Not a bad way 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.


Of course you are—anyone who works with Excel frequently would be. So let’s take a look.

Ka-boom! All the cells contain the same information.


PS: formulae will adjust for relative references just like they do during a copy / paste.

Even better!