Ask Experts Questions for FREE Help !
Ask
    gweboy's Avatar
    gweboy Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 20, 2006, 03:11 AM
    Protected worksheets
    When you protect a worksheet in excel but unprotect certain cells, why can't you change the format of the cells or insert comments?
    colbtech's Avatar
    colbtech Posts: 748, Reputation: 66
    Senior Member
    		  
    #2

    Oct 20, 2006, 05:43 AM
    because you have protected the worksheet. You may have unprotected the cells but the worksheet is prevented from changing the format. You can change the cell values but not the format. That's the way it works!
    ahmed kamal's Avatar
    ahmed kamal Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Oct 26, 2006, 03:48 AM
    . I have 2 sets of data (x and y), I want to count the data less and more than a given data (for x or y) that below that value and also (less and more than) the given data above that value. What is the proper function I can use. Many thanks
    colbtech's Avatar
    colbtech Posts: 748, Reputation: 66
    Senior Member
    		  
    #4

    Oct 26, 2006, 04:28 AM
    Countif is the function
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Worksheets within the same workbook [ 21 Answers ]

Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

Protected Storage Server [ 1 Answers ]

I have Win98 with this PSTORES.EXE on it when I click on display active tasks in the winpatrol program. What is it, what does it do or protect and is the program needed on the computer? If not needed how do you OR should you get rid of it?

Destination file is write protected [ 0 Answers ]

Hello, I'm trying to install a program and I'm getting this error message Warning - Can not copy file D:\temp\SETUP1.EX_ since the destination file is write protected I click Ok then another message appear Invalid command-line parameters. Unable to continue Then Setup wasn't complete...

View more questions Search