Techsurface

  • Reviews
  • Technology
    • Mobiles
    • Tablet
    • Camera
    • Laptop
    • Home Appliances
    • Accessories
  • Business
  • Science
  • Social
  • Tips & Tricks
  • Follow us on Facebook
  • Follow us on Twitter
  • Follow us on Google Plus
  • Subscribe
x

How to enter same value into Multiple cells Simultaneously in excel

Posted on 14/12/200817/01/2010 by Hari Maurya


Sometimes we need to enter same value in multiple cells, by following mini trick you can do it:
15-12-2008 01-16-23
1. Select the cells into which you want to enter the value.
2. Type the value in the active cell.
3. Press CTRL+ENTER.

Share
Posted in Microsoft Office, Tips & TricksTopics : cell, Excel, how-to, Microsoft, Microsoft Office, multiple, Office, same value, tips, tricks

Latest News

BlackBerry Motion, an All Touch smartphone officially launched at GITEX Dubai

How to enable Cortana in Windows 10 Technical Preview outside US

blank

Samsung Galaxy S5 Now Available

blank

Instagram Down!

blank

Samsung Launches Galaxy Ace Style Smartphone

blank

Microsoft’s new $0 Business Model, free windows for small screen devices

About TechSurface

TechSurface is a Technology dedicated website / blog, covering everything that means Technology including product reviews, Software & Hardware information, Latest Tech Trends, helping with Troubleshooting etc…

We Cover

  • Reviews
  • Technology
  • Business
  • Social Media
  • Science

Site Links

  • About
  • Contact Us
  • Copyright Policy
  • Privacy Policy
  • Sitemap
  • Friends

Connect with us

© 2016 TechSurface.com | All Rights Reserved