GadgetFind.com - The Geek Weekly.

Gadget Menu
  >  Accessories
  >  Accessories
 
Sponsored Ads
 
The Geek Weekly

Blog > Computers

Excel tip: Enter same info for multiple cells

Wednesday, October 21, 2009

Are you a slave to spreadsheets? PC users who rely on Microsoft Excel for work (or, er, for fun) might need to enter the same information on multiple cells. But the most common way to handle this is to type the data into one cell and then copy and paste it elsewhere in the worksheet. Sound familiar?

There's a simpler way to do this, actually. To enter the same data into multiple cells in Excel -- even non-adjacent cells -- simply hold down the Ctrl key and use the mouse to click on the desired cells on the row or column. Now type in the data you want in every selected cell, such as "500" or “Employee,” but don't hit the Enter key. Instead, all you need to do now is click Ctrl + Enter, and voilà, you'll see that data appear in every selected cell.

Now go treat yourself to a latte with that extra time you’ve saved.


#ENDIF
  
Gadgets Stores
Why GadgetFind.com recommends these gadget stores.
GadgetFind recommends Hammacher Schlemmer
GadgetFind recommends SharperImage
GadgetFind recommends CGets
 
Other Stuff
 
Gadgets
Smarthome, Inc.
 
Articles & Reviews
 
Synchronize
GadgetFind RSS Feed
 
Gadget Links
 
 
(c) Copyright GadgetFind.com 2005 - 2008 All rights reserved
Gadget Index   Audio Gadgets  Cell Phones Gadgets  Cell Phone Accessories Gadgets  Computers Gadgets  Computer Accessories Gadgets  Electronics Gadgets  Home Gadgets  Kitchen Gadgets  Miscellaneous Gadgets  Outdoor Gadgets  Remote Control Gadgets  Sports Gadgets  Spy Gadgets  Toys Gadgets  
Gadget Partners    Privacy Policy