WebAug 17, 2010 · 1- Select Cell B4 2- Click on the VIEW tab on the upper menu 3- In the WINDOW section, choose FREEZE PANES 4- In the Pop-up, again select FREEZE PANES That's it........to unfreeze, follow the same steps except in step 4, in the pop-up, select UNFREEZE PANES hth Vaya con Dios, Chuck, CABGx3 WebNov 17, 2015 · Select the row below the row(s) you wish to freeze. Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. … Your selection will be frozen in place. To split a window to view other columns: 1. Click on the vertical split bar (bottom right of the worksheet) 2.

Research Guides: Using Microsoft Excel: Freezing Panes

WebTo freeze the first column, execute the following steps. 1. On the View tab, in the Window group, click Freeze Panes. 2. Click Freeze First Column. 3. Scroll to the right of the worksheet. Result. Excel automatically adds a … http://dmcritchie.mvps.org/excel/freeze.htm divya abhilash golden shutter vimeo

How to Freeze Panes in Excel Both Horizontally and …

WebOct 3, 2024 · 1. Open your project in Excel. 2. Select a cell to the right of the column and below the row you want to freeze. 3. Click View. 4. Click Freeze Panes. 5. Click Freeze Panes. WebAug 18, 2024 · Click Freeze Top Row or Freeze First Column. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row. To … WebThings to Remember. We can use the “Alt+W+S” shortcut keys to enable the split panes in the worksheet. We must move the active cell to row 1 to split the worksheet vertically into two panes. We must move the active cell to column A to split the worksheet horizontally into two panes. If we select any cell in the middle of somewhere in the ... divya aathresh better