ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I delete data from a worksheet without deleting the formul. (https://www.excelbanter.com/excel-discussion-misc-queries/13584-how-do-i-delete-data-worksheet-without-deleting-formul.html)

Jack February 17th 05 12:41 AM

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?

Gord Dibben February 17th 05 01:25 AM

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 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com