Law Practice Management Tip - June 2006

This week’s tip is provided by Paul Murrillo of Business Software Made Easy (512-451-9720). The tips are not meant as legal advice, nor binding on the State Bar of Texas.

You may have been working in a spreadsheet when you try to copy the Data from the spreadsheet and paste in into another only to discover you get either REF errors or a bunch of 0s. This is typically because Excel is pasting the formulas that compute the Data, rather than the Data itself. There is a way to copy and paste only the Data using a feature called Paste Special. Here’s how you use it:
In Excel:
1. Highlight/Select the Data you want to copy
2. Edit > Copy
3. Open a new spreadsheet (or even an existing one)
4. Place the cursor in the Cell where you want the Data to be pasted
5. Edit > Paste Special
6. Select Values
7. Click OK
That’s it!