how do I delete data from a worksheet without deleting the formul.
I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right? |
Jack
Select all cells with CTRL + A(twice in 2003) OR possibly you don't want to touch titles so select just the range to clear. F5SpecialConstants. Check or uncheck what you want to find/keep and OK. EditClearContents. Gord Dibben Excel MVP On Wed, 16 Feb 2005 16:41:03 -0800, "Jack" wrote: I am trying to clear just the data from a large sheet, and I want to keep the formulas. This has to be possible, right? |
All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com