Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
There are many ways that you can use Excel's tools to fill out various cells in a worksheet. One of the most common tools is to copy a cell (or cells) and then paste them into other cells. The only problem with this approach is that when you copy cells, you also copy the format of the original cells into the target cells. What if you just want to copy the values from the original cells, but retain the formatting already applied in the target cells?
You probably already know that you can use the Paste Special option from the Edit menu, and then choose the Values option to paste just the values. If the target cells are right next to the original cells, there is an even easier way to accomplish the same task. Simply follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2490) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!