RSS

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.

 

Advertisements
 
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: