choose
edit / goto and click on the special button
choose constants (there's some tick boxes you can play with too) and then
click ok
now only the "values" will be selected in your worksheet
now press your delete key
PS always try something like this on a copy of your workbook, just in case
it doesn't work as planned
1. Select one cell on the relevant worksheet.
2. Press F5 and select "Special"
3. Select "Constants" from the dialog box.
4. Select "OK"
5. Hit the "Delete" button on your keyboard.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
