Techware Labs Header

Forums

Bargains

Home

Links

News Archives

Hardware Reviews

Articles

Guides

Downloads

About TWL

Advertising

The Geek Weekly

Newsletter

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.


Gigabyte GA-EX58-UD3R

Radeon 4890

Conficker Virus

Goliathus Mouse Pad

Hard Drive Destruction

OLPC=The Next Newton?

QPAD Gaming Mousepad

FSP BoosterX 5

Fusion Side Marker

eStarling ImpactV

Itami FiTrainer

Patriot WARP 128GB

Cyber Snipa 5.1

Game Bag 2.1

System Cache

:: Copyright © 2002-2008 Techware Labs, LLC :: All Rights Reserved

Email for spiders