Click View Code in the menu to open the Visual Basic for Applications (VBA) editor window.Right-click on the sheet tab at the bottom right of the screen for Sheet 1.If your focus is in the are that is Static (Fixed/Locked) and try to scroll you will scroll only that pane.
If you do anything else in the Freeze Panes and then Try to Split it will only Give you One Thick Black Line. I did figure it out however, First Split the panes and then move the large black Lines to the rows and columns that you want Static (or Fixed) you can click Freeze panes > Freeze Panes and then click Split or you can just click Split.
For example, you may need to keep the top row of column titles visible at all times.Īdditional Help I found it Very Difficult to figure out how to do this for the Top row and for a couple of Columns. Freeze a Row in Microsoft Excel Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
0 kommentar(er)
