Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete content but not formulas
I was asked if there is a way to remove the content of spreadsheets but to
keep the formulas. I'm not sure why the person wants to do this, but want to give them a correct answer. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete content but not formulas
To remove values only from Excel:
Select all cells on the worksheet, or just one cell. Press F5 (or Ctrl + G or Edit - Goto) Click the "Special" button. Click "Constants" Numbers, Text, Logicals, Errors should be checked. Click OK. Press Del (or Edit - Clear - Contents) Repeat for other worksheets as needed. Or use a macro -- for just the active sheet: Sub RemoveValuesOnly() Dim cell As Range For Each cell In ActiveSheet.UsedRange.Cells If Not cell.HasFormula Then cell.ClearContents End If Next End Sub Or for every worksheet in the active workbook: Sub RemoveValuesOnly() Dim cell As Range, wks As Worksheet For Each wks In ActiveWorkbook.Worksheets For Each cell In wks.UsedRange.Cells If Not cell.HasFormula Then cell.ClearContents End If Next Next End Sub -- Tim Zych http://www.higherdata.com Workbook Compare - Excel data comparison utility Free and Pro versions "Jake F" wrote in message ... I was asked if there is a way to remove the content of spreadsheets but to keep the formulas. I'm not sure why the person wants to do this, but want to give them a correct answer. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete content but not formulas
Use Edit| GoTo Special; specify Constants and tap the Delete key
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jake F" wrote in message ... I was asked if there is a way to remove the content of spreadsheets but to keep the formulas. I'm not sure why the person wants to do this, but want to give them a correct answer. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto delete cell content | Excel Discussion (Misc queries) | |||
How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
DELETE CONTENT ADVISOR??? | Setting up and Configuration of Excel | |||
Delete cell content | Excel Discussion (Misc queries) | |||
Delete rows by content | Excel Worksheet Functions |