After opening Excel and the document you’re working on, switch to the View tab in your Ribbon interface, and make sure that the Normal view is selected. Before you can start freezing and locking, you need to ensure that you’re in the right view mode. Freeze rows and columns in Excel for Mac. To Freeze both rows and columns, select the Cell located to the right of the Column that you want to Freeze and below the Row that you want to Freeze. In certain cases, you may want to Freeze the Row containing Column Headings and also Freeze the first column or few selected columns in the worksheet. Now when you scroll, you should still continue to see row. Click on the Freeze Panes button and click on the Freeze Panes option in the popup menu. Then select the Layout tab from the toolbar at the top of the screen. To freeze the first row and column, open your Excel spreadsheet.
0 kommentar(er)
