Forum Discussion

CarterDRH

Copper Contributor

Jun 01, 2020

Solved

How to Freeze A1 - A15

How do you just freeze just A1 - A15 where when you move A1 -A15 is always on my spreadsheet. Thanks, Carter

excel

Excel on Mac

mtarler
Jun 01, 2020
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.

CarterDRH

Copper Contributor

Jun 01, 2020

Spoiler

When I do that it keeps rows 1-15 frozen and I want just A 1-15 to be frozen.

mtarler

Silver Contributor

Jun 01, 2020

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.

CarterDRH
Copper Contributor
Jun 01, 2020
Ok. Thanks for your help.