How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

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 …

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 insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …

Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the …

If a worksheet spans more than one page, you can print row or column headers or labels (also called print titles) in the first row or mutliple rows on every page.

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.

When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.

Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the following: When you are moving rows or columns, select …

If you have files that you use often, you can pin them in the Recent page and get to them quickly. Pin a file to the top of your list. When you open Word App, you see a list of your recent files. In …