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

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.

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!

~ April