Copying Cell Contents without Formatting

Summary: Want to copy the contents of one cell to another without copying the formatting? It's easy to do by using the controls on the Home tab of the Ribbon.

If you want to copy the contents of a cell without formatting, you can easily do so by using the Paste Special feature of Excel. Simply follow these steps:

Select the cells whose contents you want to copy.
Press Ctrl+C to copy them to the Clipboard.
Select the cell where you want to paste the contents.
Display the Home tab of the Ribbon and click the down-arrow under the Paste tool. From the options presented, choose Formulas.

Related Tips:

Tremendous Table Tips! We often take tables for granted, but Word includes some very powerful ways you can present your tabular data. Discover how to make your tables better, easier to understand, and more effective. Check out WordTips: Terrific Tables today!

Helpful Links

Newest Tips

Subscribe

Copying Cell Contents without Formatting