Question about Excel (SS8SATAS5128400R)

1 Answer

Prevention of delition of cell which has a formula

Hai sir,
i want to make a cell which is non-deletable in excel
plz any body can help me?

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 788 Answers

If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.

Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.

Posted on Jun 16, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

7 Answers

E1081t sim trey jumpar


sir mujhe samsung 1081 ki sim tray track nahi mil rahe hai plz help me

Jan 29, 2011 | Cell Phones

1 Answer

Sir i want know about the basic of the excel $ how to use thw formula of plus and minus plz rply me Thank you Regards shambhu pandey


1. Make sure you have entered the numbers you'll need in necessary columns
2. Go to the column you would want the results to appear in
Guide: + (addition); -(subtraction); *(multiplication); /(division)
3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on
4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

1 Answer

MS excel issue


Using a time format for the data cells and data that looks like 12:00:10 AM the result you want is displayed no matter which formula is used. If the date portion of the data cell is not deleted then the result is 00:00:00. Delete the date portion of your data cells to get the result you want. (For example: When I enter 10 into a cell that is formated for time xx:xx:xx it shows 1/11/1904 12:00:00 AM in the formula bar and 00:00:00 in the cell. When I delete 1/11/1904 in the formula bar and show only the 12:00:10 the cell shows 00:00:10. Then it makes no difference which formula you use.)

Sep 19, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

When I create a formula in a cell, hit enter, I get #VALUE. How do I get the actual result to appear, instead of #VALUE?


#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

1 Answer

Master code pls


Sir yesa koi softwar aata hai kya jise ki mobail ka pata kiya jaa sake kyun ki mere bahut se seat kho chuke hai agar sir yesa koi bhi softwar hoto hume softwar kaa name bata sakte hai kya plz.... sir rikuyeste hai mi mail is esh_242@yahoo.co.in

Apr 02, 2008 | Nokia 3110 Cellular Phone

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

90 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

3014 Answers

Bill Boyd

Level 3 Expert

34217 Answers

Lala

Level 2 Expert

34 Answers

Are you an Excel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...