Excel 2007: Copy and Paste Values Without Formulas

Posted on Nov 19, 2007 under Office Tips |

How to copy and paste the values from fields in Excel 2007 without copying the formulas.

1. Select the cells or ranges you wish to copy.

2. On the Home tab, under Clipboard, select Copy.

3. Select the top left cell you wish to paste your values to.

4. Click the lower half of the large Paste button; from the extended menu that appears, select Paste Special, and then Values. Click OK.

Outlook 2007: Send a Vote Email (Apr 29, 2008)
Outlook 2007: Check Who Accepted Meeting Invite (Apr 29, 2008)
Outlook 2007: Enable AutoArchive (Apr 22, 2008)
Word 2003: Divide Page Into Columns (Apr 22, 2008)
Word 2007: Divide Page Into Columns (Apr 22, 2008)

Leave a comment