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 freeze multiple columns (starting with column A), select the column to the right of the last column you want to freeze, and then tap View > Freeze Panes > Freeze Panes.

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 column …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Lock or unlock specific areas of a protected worksheet Protect a worksheet …

If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages …

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 number of …

To solve this problem, in step 3 of the Text Import Wizard, click the column containing postal codes, and then, under Column data format, click Text. Click Finish to finish importing your data.

In a worksheet that will take more than one page to print, you can print column headers on each page so the column headings can be seen on each page. On the Page Layout tab, in the Page Setup group, …

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.

To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total population, or Time …