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

Repeating Data Super Shortcut

Posted By On November 19, 2004 @ 3:02 PM In MS Excel | No Comments

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.

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

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!

Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/repeating-data-super-shortcut/