Is this possible to do by some kind of delete special. I want to feed new data in the sae columns but wish to erase the old data only entirely yet keep the formulae etc so that i do not have to (think) and rewrite them again ??
Is this possible to do by some kind of delete special. I want to feed new data in the sae columns but wish to erase the old data only entirely yet keep the formulae etc so that i do not have to (think) and rewrite them again ??
Hi,
1. Hit the F5 key
2. Click Special
3. Choose Constants
4. Click OK
5. Hit the delete key
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks