I have a worksheet that was emailed to me. It has a cell in it in which I would like to change the format, but when I click on it, nothing happens. I have checked the protection, and there is none. how can I make it so I can change the format.
cell protection
-
-
-
-
When you say "nothing happens" do you mean that the cell is not even outlined with the black border like when you select another cell? - or you just can't change the formatting of that cell?
Also, which cell is it?
-
Cell J35 is one cell that does this.
When i right click on it, i can't format, just want to know how to unlock the cell so that I can change the format.
-
Click on the "35" (on the left of the screen) to highlight the whole row. Then click on Edit / Clear / Formats. That will wipe out all formatting in that row and allow you to change the formats. Some cells were formatted as a group previously.
Hope this helps
.....Ralph
-
-
I have downloaded your Workbook and selected J35. With no alterations to any Protection or settings I have added text, formatted the background, text colour, size and Font type. I would suggest you check your settings or see if you have this problem on any other Workbooks
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!