copy and paste this google map to your website or blog!
Press copy button and paste into your blog or website.
(Please switch to 'HTML' mode when posting into your blog. Examples: WordPress Example, Blogger Example)
Lock or unlock specific areas of a protected worksheet To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet
Lock cells to protect them in Excel - Microsoft Support On the Home tab, in the Alignment group, select the Alignment Settings arrow to open the Format Cells popup window On the Protection tab, select the Locked check box, and then select OK to close the popup
Protect a worksheet - Microsoft Support To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password
Lock cells to protect them in Excel for Mac - Microsoft Support To prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can lock cells and protect them Locking cells takes two steps: adding the Lock formatting to the cells, and then turning on protection of the sheet
Protection and security in Excel - Microsoft Support You can protect the Excel file by specifying two passwords: one to open, and the other to modify You can later share the appropriate passwords with the team depending on the access they should be given
Freeze panes to lock rows and columns - Microsoft Support To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet
Protect controls and linked cells on a worksheet To prevent users from changing the protections on the cells and controls that you have set, protect both the worksheet and the workbook For more information, see Protect a workbook
Display or hide formulas - Microsoft Support Make cells display the formulas they contain, instead of the formula results Protect cells so that formulas cannot be displayed or changed
Split panes to lock rows or columns in separate worksheet areas You can also split on both a row and a column by selecting the cell below and to the right of where you want the split—then click Split In the figure below—because D5 was chosen—columns to its left (A-C) and rows above it (1-4) are frozen by the split