I've spent 2 days trying to find out if my issue had already been answered. So if I missed it somehow, I'm sorry.

Here's my issue:

I use 2 Excel spreadsheets. 1 is a list certain big jobs and the other is an employee timesheet. I change info in the cells themselves but NEVER the formatting. Light lines marking each cell with a heavy boarder on the outside of the entire working area.

Is there a way to lock the formatting ONLY?

Example: On the time sheet, I will drag the date from the top to bottom when the week changes. But that also drags the thick board with it which causes me to have to redo the boarders. I hope that made sense.

I'm running Excel 2013

Stacy