Forum Discussion
How to lock borders for a sheet while allowing drag and drop?
I have an Excel sheet that is modified daily and would like to lock only the cell borders to their original location. I would like the cell borders to remain in their original location while allowing...
Did not work. Borders still move with drag and drop. Tried twice in different documents with the same result. Thanks for the try.
You can lock cell borders in their original location while allowing the contents of the cells to be dragged and dropped by using the following steps:
- Freeze Panes for Row and Column Headers (Optional):
- If your sheet has row and column headers, you may want to freeze them so they remain visible while scrolling. You can do this by going to the "View" tab and using the "Freeze Panes" option.
- Protect the Worksheet:
- Go to the "Review" tab in Excel.
- Click on "Protect Sheet" or "Protect Workbook" depending on your needs. If you only want to protect the borders on a specific sheet, select "Protect Sheet."
- Set Protection Options:
- In the "Protect Sheet" or "Protect Workbook" dialog box, you will have various options to choose from. You can set a password if you want to restrict access.
- To allow specific actions while protecting the sheet, make sure to check "Allow all users of this worksheet to" and select the following options:
- Format cells
- Format columns
- Format rows
- Uncheck "Select locked cells":
- In the same dialog box, you will see an option for "Select locked cells." Uncheck this option to prevent users from selecting locked cells.
- Lock the Borders:
- Now, go to the cells where you want to lock the borders. You can do this by selecting the cells, right-clicking, and choosing "Format Cells."
- In the "Format Cells" dialog, go to the "Border" tab.
- Apply the desired border styles to the cells, and then click "OK."
- Protect the Sheet:
- After setting the border styles, go back to the "Review" tab, and click "Protect Sheet" again.
- Make sure to enter the password if you set one earlier and confirm the protection.
Once you have protected the sheet with the options mentioned above, users will be able to edit the contents of the cells and drag and drop them, but the cell borders you have styled will remain locked in their original location.
Remember to keep a record of the password used to protect the sheet in case you need to make changes in the future. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.