- Feb 5, 2006
- Office Version
Good day. I am running Excel out of Office365 (updated recently) in Windows 10 Home. After all the Macros and Formulas that I have created, I am having trouble with a simple Freeze Pane function. I have a worksheet that has over 125 Columns and over 200 Rows of data. The first four Rows of the worksheet are rows containing Totals of the data under them and I would like to freeze Rows 1 through 4 so that I can see the totals while I scroll down through the other rows that contain the data making those totals. I was able to freeze rows 1 through 4 manually, but I can't seem to make it work in a Macro. I appreciate any help with this.