I have an Excel spreadsheet that I need to lock the formatting of a range of cells, I know how to protect cells, the sheet, etc unless there is a step I am missing in this area I don’t believe that I can accomplish what I need with this function.

What I need to do is….

I have a range of cells (say its B:5 – H:52) this block of cells has a boarder around in and the data within the range has lighter boarders. When I delete a row of data the entire block shift up making the formatted cell range change to B:5 – H:51. I need to be able to delete said row of data BUT keep the formatting boarders intact for thoriginalal cell range.

Is this possible?

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I am able to follow the simple instructions regarding protecting specific cells within a worksheet. Once I protect these cells, it seems to lock up the formatting for the respective rows and columns. I would like to allow the user to be able to adjust row and column size, but not adjust the formulas. Is this even possible?

I understand that Access may be easier, but I am not very good in Access and it is not widely used in my office.

Thanks in advance for any help that you can provide!

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

What I’m trying to do is add times on a spreadsheet exported from Crystal Reports. They are in some custom formatting that appears to behave as text. I can unlock the cells but I cannot change the format to anything other than the original (which will not let me add the times). Any ideas?

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software