close
What is the quickest way to delete all the data but save the formulas?
Dean
CTRL a(twice in 2003) to select all cells.
F5gt;Specialgt;Constantsgt;OK
Editgt;Clear Contents.Gord Dibben MS Excel MVP
On Fri, 3 Feb 2006 03:48:15 -0800, quot;Deanquot; gt;
wrote:
gt;What is the quickest way to delete all the data but save the formulas?COPY, select another range or wks, EDIT, SPECIAL, FORMULA.
quot;Deanquot; wrote:
gt; What is the quickest way to delete all the data but save the formulas?
Dean
CTRL a(twice in 2003) to select all cells.
F5gt;Specialgt;Constantsgt;OK
Editgt;Clear Contents.Gord Dibben MS Excel MVP
On Fri, 3 Feb 2006 03:48:15 -0800, quot;Deanquot; gt;
wrote:
gt;What is the quickest way to delete all the data but save the formulas?COPY, select another range or wks, EDIT, SPECIAL, FORMULA.
quot;Deanquot; wrote:
gt; What is the quickest way to delete all the data but save the formulas?
全站熱搜
留言列表
