unlocking sheets

  1. D

    cell location is locked cannot format it

    Hi Everyone, Someone got into my spreadsheet and locked a cell so I cannot format it. How can I find out how they did it and how can I unlock it? cell G1 has the date January 1,2017 in cell G2 I have (=G1) and custom formatted to "d" to show the day only but it shows January 1,2017. No...
  2. T

    Locking/Unlocking Sheets for a Shared Workbook while its Shared

    Hello Everyone, I am trying to setup a shared workbook where each user of the shared workbook will have their own worksheet which they can lock and unlock without unsharing the workbook. Is there anyway to do this in Excel. I need the workbook to be shared so that multiple users can have access...

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