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 …

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

Suppose you want to protect an entire workbook, but also wants to be able to change a few cells after you enable that protection. Before you enabled password protection, you can unlock …

Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first …

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 …

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the …

Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.

If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers …

First, insert a temporary column next to the column that contains the text you want to convert. In this case, we've added a new column (B) to the right of the Customer Name column.

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 …