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 …

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.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

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 …

This means that the cells are ready to be locked when you protect the workbook or worksheet. On the Review tab in the ribbon, in the Changes group, select either Protect Sheet or Protect …

If you've used access keys to save time on Excel for desktop computers, you'll find access keys very similar in Excel for the web. In Excel for the web, access keys all start with Alt+Windows …

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 …

By splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. To split this worksheet as shown above, you select below the row where you want …

If your data includes formulas, Excel automatically updates them to match the new placement. Verify these formulas use absolute references—if they don't, you can switch between relative, …

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 …