Protected worksheet - copy/insert copied cells no longer keeping format

jodijl8

New Member
Joined
Oct 8, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Good morning, I have a protected worksheet whereas some cells are locked and some are not (users are allowed to do everything except select locked cells; the locked cells are a template which cannot be altered due to company requirements) - up until approx. two days ago I was able to copy a row and insert copied cells above/below it and the new row kept all the formatting, most specifically merged cells were still merged. Merged cells are no longer staying merged when I copy/insert copied cells now, any ideas? It is important to note that the copy/insert copied cell function does work as it should (keeps cells merged) when the worksheet is unprotected, just no longer while the worksheet is protected (I have made no changes on my end)! Also important to note that there are no tables or formulas within my worksheet.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,224,823
Messages
6,181,183
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top