First, copy the worksheet then on copied sheet hit F5>Special>Const

In excel,how to clear the values of the cell without
removing the formula?

Question Posted / krishna sharma

2 Answers
5670 Views
I also Faced
E-Mail Answers

Answer Posted / krishna sharma

First, copy the worksheet then on copied sheet hit
F5>Special>Constants

Uncheck what you want to keep, like "text" for titles and
OK

Edit>Clear>Contents or just hit the delete key.

Krishna Sharma
P.M.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you know if you have a microsoft account?

983

Explain why do we use option explicit?

980

How do I stop microsoft teams from running at startup?

1023

What is an example of a microsoft account?

1105

What is refactoring?

1025

How do I permanently delete microsoft teams?

1015

Where will i get Microsoft Office 2010 with License Key free download ?

1750

What is the relationship between xaml and jts/jta? : xaml

998

Can you explain about namespace?

1069

procedure is for backing up Windows SBS 2008 to a Network attached Storage device

2068

What is xaml? : xaml

1092

How do you interact with git in visual studio?

981

What are the different refactoring options in visual studio?

1024

Does microsoft have a virus protection?

938

What is UPS (Uninterruptible Power Supply)

2057