This will freeze all rows above the selected cell and all columns to the left of Everything to the left of the line is frozenĪnd will remain in view when you scroll across your worksheet.Ĭlick in a single cell of your worksheet and go to To freeze a column in your worksheet, highlight the column where you wish allĬolumns before, the highlighted column to be frozen or locked, go to Window>Freezeĭown your worksheet. Remain in view when you scroll down your worksheet. Everything above the line is frozen and will ![]() To freeze a row in your worksheet, highlight the row where you wishĪll rows before the highlighted row to be frozen or locked, go to Window>FreezeĪcross your worksheet. ![]() By using Excel's Freeze Panes feature you can freezeĮither columns or rows in your worksheet so that they remain visible whilst you When you have a large worksheet, it is often required that column or row labels View Multiple Sheets of an Excel Workbook Excel: Locking Columns/Rows using Freeze Panes.
0 Comments
Leave a Reply. |