hodu.com Your Gateway to Better Communication Skills
Home   Everyday Social Skills  Business Communication   Resource Guide   About Azriel   Videos  Blog

COMMUNICATION
IN EVERYDAY LIFE
Assertiveness skills
Body language
Communicating with
your children

Conversation skills
Difficult People
Emotional Maturity
Enhancing your marriage
Family Life
Interpersonal relationships
Speaking skills
Writing skills

BUSINESS COMMUNICATION
Business ethics
Business etiquette
Business writing
Communication in
the workplace

Cross-cultural communication
Conflict resolution
Creative thinking
Crisis management
Customer relations
Effective meetings
Job-hunting skills
Management strategies
Marketing communication
Negotiating skills
Networking in business
Presentation skills
Team building
Technology and communication
Telephone marketing


SITE
UPDATES


Sign up to receive updates by email of new articles added to this site.
To subscribe, click on the button below:



We're proud of our ethical standards and take your privacy seriously

SEE SAMPLE ISSUE




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