Can you freeze first 4 columns and top 7 rows?

%3CLINGO-SUB%20id%3D%22lingo-sub-3118103%22%20slang%3D%22en-US%22%3ECan%20you%20freeze%20first%204%20columns%20and%20top%207%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118103%22%20slang%3D%22en-US%22%3E%3CP%3ETitle%20is%20pretty%20self%20explanatory.%20I%20want%20the%20first%204%20columns%20to%20remain%20frozen%20all%20the%20way%20down%20and%20the%20first%207%20rows%20to%20remain%20frozen.%20Is%20this%20possible%3F%20When%20I%20do%20the%20normal%20method%20whenever%20I%20scroll%20down%20the%20data%20below%20the%207th%20row%20moves.%20When%20I%20scroll%20sideways%20it%20stays%20though.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3118103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3118160%22%20slang%3D%22en-US%22%3ERE%3A%20Can%20you%20freeze%20first%204%20columns%20and%20top%207%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118160%22%20slang%3D%22en-US%22%3Eyes.%20put%20cursor%20in%20cell%20E8%20and%20select%20Freeze%20Panes.%20It%20will%20freeze%20all%20rows%20above%20and%20columns%20to%20left%20of%20the%20selected%20cell%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3118368%22%20slang%3D%22en-US%22%3ERE%3A%20Can%20you%20freeze%20first%204%20columns%20and%20top%207%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3BWhen%20I%20scroll%20down%20the%20rows%20below%207%20aren't%20frozen.%20I%20want%20to%20freeze%20the%20first%204%20columns%20down%20to%20row%2030.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Title is pretty self explanatory. I want the first 4 columns to remain frozen all the way down and the first 7 rows to remain frozen. Is this possible? When I do the normal method whenever I scroll down the data below the 7th row moves. When I scroll sideways it stays though.

 

Thanks,

4 Replies
yes. put cursor in cell E8 and select Freeze Panes. It will freeze all rows above and columns to left of the selected cell

@mtarler When I scroll down the rows below 7 aren't frozen. I want to freeze the first 4 columns down to row 30.

 

Thanks,

Hello,
What version of Excel do you have? is it Excel 2016 or 2019
Select cell E8 then from View tab --> in the window group click on Freeze Panes --> choose Freeze Pane from the menu.
So I'm confused what you want. When you Freeze Panes, you get essentially 4 panes. The upper left will be the Rows & Columns less than your selected location and those will be Frozen. The upper right pane will have the Rows less than your selected location and the lower left pane will have the Columns less than your selected location. Those upper right and lower left panes WILL move to align with the lower right pane. So the lower left will always show the same frozen Columns but the Rows in that pane will move so they always alight with the rows in the lower right pane. So IF you want to 'lock' that lower left pane to show only rows 1-30 while you scroll down further., the answer is no.