SOLVED

How to Freeze A1 - A15

%3CLINGO-SUB%20id%3D%22lingo-sub-1431322%22%20slang%3D%22en-US%22%3EHow%20to%20Freeze%20A1%20-%20A15%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431322%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20you%20just%20freeze%20just%20A1%20-%20A15%20where%20when%20you%20move%20A1%20-A15%20is%20always%20on%20my%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3ECarter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1431322%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431331%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Freeze%20A1%20-%20A15%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431331%22%20slang%3D%22en-US%22%3ESelect%20cell%20A16%20and%20click%20on%20Freeze%20Pane.%3CBR%20%2F%3E%3CBR%20%2F%3EThats%20all%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431348%22%20slang%3D%22en-US%22%3ERE%3A%20How%20to%20Freeze%20A1%20-%20A15%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431348%22%20slang%3D%22en-US%22%3Esounds%20like%20you%20want%20to%20%22Freeze%20Panes%22%20an%20option%20under%20the%20%22View%22%20menu.%20You%20have%20a%20few%20options%20there%20to%20freeze%20top%20row%20(not%20what%20you%20want)%2C%20freeze%20first%20Column%20(that%20might%20work%20for%20what%20you%20want%20but%20I%20don't%20think%20so)%2C%20or%20just%20freeze%20panes.%20By%20clicking%20on%20cell%20B16%20and%20then%20clicking%20on%20the%20%22Freeze%20Panes%22%20Drop%20Down%20and%20then%20%22Freeze%20Panes%22%20again%20it%20will%20'freeze'%20column%20A%20and%20'freeze'%20rows%201-15%2C%20so%20the%20top%20left%20corner%20will%20always%20stay%20A1-A15.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431376%22%20slang%3D%22en-US%22%3ERE%3A%20How%20to%20Freeze%20A1%20-%20A15%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431376%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EWhen%20I%20do%20that%20it%20keeps%20rows%201-15%20frozen%20and%20I%20want%20just%20A%201-15%20to%20be%20frozen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431470%22%20slang%3D%22en-US%22%3ERE%3A%20How%20to%20Freeze%20A1%20-%20A15%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685691%22%20target%3D%22_blank%22%3E%40CarterDRH%3C%2FA%3E%26nbsp%3B%20Yes%2C%20if%20you%20want%20A1-A15%20frozen%20then%20yes%20it%20will%20freeze%20the%20top%2015%20rows%20and%20the%20first%20column.%26nbsp%3B%20If%20you%20want%20you%20only%20freeze%20Column%20A%20then%20you%20can%20do%20that.%26nbsp%3B%20but%20Excel%20will%20not%20let%20you%20%22float%22%20A1-A15%20while%20you%20scroll%20around%20the%20sheet.%26nbsp%3B%20I%20suppose%20you%20might%20be%20able%20to%20do%20it%20through%20VBA%20by%20creating%20an%20object%20or%20form%20and%20continuously%20adjusting%20the%20location%20of%20the%20object%20based%20on%20the%20present%20worksheet%20cell%20location....%26nbsp%3B%20but%20beyond%20what%20I%20can%20offer%20in%20this%20help%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431474%22%20slang%3D%22en-US%22%3ERE%3A%20How%20to%20Freeze%20A1%20-%20A15%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431474%22%20slang%3D%22en-US%22%3EOk.%20Thanks%20for%20your%20help.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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

 

Thanks,
Carter

4 Replies
Highlighted
sounds like you want to "Freeze Panes" an option under the "View" menu. You have a few options there to freeze top row (not what you want), freeze first Column (that might work for what you want but I don't think so), or just freeze panes. By clicking on cell B16 and then clicking on the "Freeze Panes" Drop Down and then "Freeze Panes" again it will 'freeze' column A and 'freeze' rows 1-15, so the top left corner will always stay A1-A15.
Highlighted
Spoiler
 

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

Highlighted
Best Response confirmed by CarterDRH (Occasional Contributor)
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.

Highlighted
Ok. Thanks for your help.