Enter Same Data in to Multiple Cells

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 Reply

Your email address will not be published. Required fields are marked *