Question about Business & Productivity Software

1 Answer

Need help i have entered data in particular cells, except that i want to lock the remaining cells.. could any one please help me in this.... Mahesh

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 113 Answers
Re: Need help

Highlight cells you want locked.
Click format on the menu bar
click on cells
click on the tab labeled "protection"
check the box marked "lock"

Posted on Oct 25, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

Excel cell replacement

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)
This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

1 Answer

I want to know how I can to apply the formula where the excell find one data and multiply for one data of other cell, what formula can I apply for my question?

Enter data the number 10 on cell A1. Enter data the number 20 on cell B2. Mouse click on cell C3. Press equal sign, press left arrow, press *, press left arrow twice, press enter. Mouse click on cell C3. You'll see your formula on the address bar. Hope this helps.

Mar 06, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Locating provinces per area

You can return the Province using a LOOKUP function either V or H depending on how your have sorted your data of towns per province.

Feb 09, 2009 | Microsoft Office Standard for PC

5 Answers

Have a problem in tally 7.2

Dear Archana,

If you are using tally legal. Please check whether the date & time are correct. If correct then check the data folder file permission (readonly, hidden, system attributes) are removed. If not while starting tally press Ctrl + Alt + R for and select company which one is getting error. It will rewrites the data of that particular company. Then close tally and open again check it. If this doesn't work u should contact tally support with u r licence key and product id.

Thanks & Regards
Nanda Kishore

Nov 13, 2008 | Business & Productivity Software

2 Answers


Highlight the cells you want to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab.

Make sure protect sheet is enabled. To activate it, press the review under the menu options and select protect sheet (if its on sheet) or workbook for more than one sheet.

Sep 15, 2008 | Microsoft Excel for PC

4 Answers


generally phone lock-unlock code for chinese phones is: 1122

Sep 07, 2008 | Handmark Software MobileLists (950142) for...

3 Answers

How to protect a single cell in excel from modification

Found on the internet and it seems to work:

The default setting for each cell is for them to start locked. So, you first need to highlight ALL cells in the sheet, right click, choose format, go to the Protection tab and take the tick out of the Locked box.

Now no cells are locked.

Now you need to select the one cell you want locking. Right click, choose format cells, Protection tab and then put a tick into the Locked box.

Locking the cells does not take place until you have locked the sheet. So go to Tools, Protection and Protect Sheet. Add a password of your choosing, and put a tick into every option available to you, EXCEPT the very top option. "Select locked cells" should NOT have a tick in it.

OK that to confirm, and hey presto, that cell can no longer be selected, edited or erased unless you unprotect the sheet by entering the password you chose.

May 23, 2008 | Microsoft Excel for PC

1 Answer

Data validation in excel

instead of validation use conditional formating (under format menu). If c1<1 format cell as red. It does not have the attention getter that validation does not require the active cell event. Every other option requires the cell become active for a test.

Apr 13, 2008 | Business & Productivity Software

2 Answers

Duplicacy in excel sheet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

5 Answers

Formula required

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.


Dec 04, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

30 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides