Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Sat, 28 Oct 2006 11:30:01 -0700, Gary''s Student
wrote: If you have a worksheet with a mixture of data and formulae and want to clear out the data, but leave the formulae alone then: Edit Go To Special... and click Constants and then OK this selects the data, but not the formulae Edit Clear All clears out the data Thanks! The others who replied pointed out a flaw in my thinking, but you've actually given me what I was looking for. Thanks again! Tom -- remove .spoo to reply by email |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |