![]() I selected the row 44 and choose Freeze pane option but its freezing row 10 instead of row 43. Im sorry but your task is not entirely clear.Could you please describe it in more detail. I thank you for reading and hope to see you on our blog next week. The detailed instructions can be found here: Print row and column headers on every page. When you scroll within one area, the cells in the other area(s) remain fixed.įor more information, please see How to make a table in Excel. Please remove the workbook protection first, and then freeze rows or columns. If some of the rows are out of view, such rows will be hidden after freezing.įor more information, please see How to avoid frozen hidden rows in Excel.įor instance, to lock top row and the first 2 columns, you select cell C2 to freeze the first two rows and the first two columns, you select C3, and so on. You just click View tab Freeze Panes and choose one of the following options, depending on how many rows you wish to lock. Ze An Area In Excel 2008 How To Thank You.
0 Comments
Leave a Reply. |