Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Microsoft Related >> Microsoft Related AllOther
  2. Suggest New Category

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

Question Posted / krishna sharma

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 to restore deleted OU in DC ?

1937

How do I access my microsoft account?

1088

What is UPS (Uninterruptible Power Supply)

2127

What are the microsoft apps?

1027

How do I sign in without a microsoft account?

1093

What is Splitter?

2342

What microsoft programs can I uninstall?

1093

What is the purpose of krne32.dll?

1109

Do I need microsoft visual c++ 2005 redistributable?

1090

difference between windows 98, windows 2000 and windows XP

2953

What is the cycle of Installing patches.....

2280

What is Spam ?

2193

What is the purpose of OLE Automation?

1079

What are the four microsoft programs?

1028

What is the functionallity difference between radio/option buttons and a drop-down list box besides appearence? i.e. When it is better to use one instead of the other?

2099