|
Blog > Computers
Excel tip: Enter same info for multiple cellsWednesday, October 21, 2009Are 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. About This BlogWelcome to The Geek Weekly's blog, which is designed to deliver the latest in tech-related news, rumors, reviews and how-tos for your personal and business needs. You can also expect plenty of opinions, rants and tips. I am a syndicated technology journalist and author. I've spent the last 12 years waist-deep in gadgets, gizmos, gear and games. I'm very much living the "digital lifestyle," whether I'm flashing barcodes on my BlackBerry to board a plane, backing up my laptop's data onto a USB memory watch (Ok, so I know it's geeky) or jamming with my three kids in Rock Band. Like you, I love this stuff. So come back every Monday and Wednesday for new entries. --Marc Saltzman
|