![]() ![]() The value you set for the split row is the number of the top rows below which the screen will be split. ![]() You can use SplitRow to split panes by rows. 'select the row that you want to freeze based on To freeze a pane, make the selection of the range that you want to freeze based on, whether it’s rows, columns, or a cell, then use FreeePanes = True Sub Freeze_Panes() This duplicates the Excel sheet into multiple panes as shown below. Other than freezing panes in Excel, you can also split panes. In other words, the top-left corner cell of the range will remain unfrozen. If you want to freeze both rows and columns, select a single cell where the rows you want to freeze are above it and the columns you want to freeze are below it. Of course you can use ‘ Freeze First Column’ if you only want to freeze the first column. Similarly, you can apply the same method if you want to freeze a column or a number of columns, enabling you to keep them visible as you scroll to the right.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |