In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to find and delete all data but keep formulas (Microsoft Excel)...
Tame your computer - a formula for success
Have you ever had the need to keep your formulas in a worksheet, but get rid of all the other data? For example, you might want to create a new sheet for the new tax year, containing exactly the same headers and formulas, but not the data from the previous tax year.
- Select the rows and/or columns that contain the formulas. (Remember the quick way to select a range of cells?)
- On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. (Or press CTRL + G and click on the Special button.)
- In the Go To Special dialog box, click the Constants radio button.
- Click OK.
- Press the Delete key on your keyboard.
This will delete all the data, but leave the formulas, ready for next year’s tax year. (Thanks for the inspiration, Melissa.)
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing email@example.com - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
29 April 2014
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at http://www.roem.co.uk
Please note: Cambridge Network and Learning Collaboration members have the opportunity to book places on Roem Ltd courses at a reduced rate.