Visit MyParenTime.com Brought to you by MyParenTime.com
 


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



 





| My ParenTime Home | Printable Checklists Home | Privacy | Legal | Disclaimer | Copyright |
| About Us | Site Map | Articles | Child Safety | OPK FAQ | BBT Charting | Breastfeeding Guide |
| Hints & Tips | Online Games | Calculators | Special Reviews | Informative Websites |
| Greeting Cards | Magazines | Shop | Link to Us | Reminder Service | Movie Reviews |
| Search | Our Awards | Twitter | Blog | Advertise | Text Sponsors | Hall of Shame |
| No SPAM! |

Copyright © My ParenTime
No reprints without written permission.
Our Website Community is Proudly hosted by FutureQuest

Other Websites in the My ParenTime Family Community:
| stopsexoffenders.com | jupiterparents.com | printablechecklists.com | funinternetgames.com |