Enter Same Data in to Multiple Cells

11 Apr

Here is a quick Excel tip to kick start your time.

Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.

  1. Select all the cells where you want to enter the same data.
  2. Type the data
  3. Press CTRL+Enter
  4. Done!

Method 2

  1. Copy the cell
  2. Drag up to the cell you want
  3. Press Ctrl+D

Hope this helped you. Stay tuned to know more.


Leave a comment

Posted by on April 11, 2012 in MS Excel, My Home


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: