Jun 01 2020 08:55 AM
How do you just freeze just A1 - A15 where when you move A1 -A15 is always on my spreadsheet.
Thanks,
Carter
Jun 01 2020 09:03 AM
Jun 01 2020 09:13 AM
When I do that it keeps rows 1-15 frozen and I want just A 1-15 to be frozen.
Jun 01 2020 09:39 AM
Solution@CarterDRH Yes, if you want A1-A15 frozen then yes it will freeze the top 15 rows and the first column. If you want you only freeze Column A then you can do that. but Excel will not let you "float" A1-A15 while you scroll around the sheet. I suppose you might be able to do it through VBA by creating an object or form and continuously adjusting the location of the object based on the present worksheet cell location.... but beyond what I can offer in this help here.
Jun 01 2020 09:39 AM
Solution@CarterDRH Yes, if you want A1-A15 frozen then yes it will freeze the top 15 rows and the first column. If you want you only freeze Column A then you can do that. but Excel will not let you "float" A1-A15 while you scroll around the sheet. I suppose you might be able to do it through VBA by creating an object or form and continuously adjusting the location of the object based on the present worksheet cell location.... but beyond what I can offer in this help here.