If you ’ve ever worked with an enormous Excel spreadsheet , you ’ll know just how daunting all those row and columns can be . Once you ’re over 10 or 15 unlike values and labels , it can get somewhat hard to give ear onto any info you ’ve gleaned from these former cells . fortuitously , there ’s a mere means to lock those little rectangular corner of information .
The name of the game is “ freezing , ” and the instruction execution is about as Earth’s surface - level as the countersign . Youuse Microsoft Excel ’s build - in function to freeze specific rowing and newspaper column ( often dustup or column header ) , so when you ’re scroll through , these cellphone remain stationary on the page .
Here ’s our footmark - by - step template to instruct you how to start freezing today !
How to freeze a row in Excel
Step 1 : Pick out the row or row you need to freeze . These will be the rows that will stay with you as you scroll through the spreadsheet . take the row forthwith below the row you want to freeze . So if you want to freeze dustup 1 - 3 , you involve to select row 4 .
Step 2 : Then take theViewtab from the typewriter ribbon card at the top of the screen .
Step 3 : From the fall - down menu that appears , selectFreeze Panes .
Alternatively , if all you want to do is freeze the top row of your spreadsheet , you do n’t have to select any row beforehand . you could just press theViewtab and thenFreeze Panes > Freeze Top Row .
stride 4 : To unfreeze your frozen rows : Go to theViewtab again , selectFreeze Panes , and then chooseUnfreeze Panesfrom the bead - down bill of fare .
How to freeze a column in Excel
Step 1 : Pick the columns you want to freeze . Then pick out the pillar that is immediately to the right of the pillar or editorial you want to freeze . For example , if you need to freeze column A , B , and C , you should take column D.
Step 2 : Then select theViewtab from the ribbon menu at the top of the screen . Then chooseFreeze Panes .
Step 3 : From the drop curtain down carte that appears , selectFreeze Panes .
Alternatively , if all you desire to do is freeze the first column of your spreadsheet , you could just cluck on theViewtab , and then selectFreeze Panes > Freeze First Column .
Step 4 : To thaw your flash-frozen columns , just sink in on theViewtab , and selectFreeze Panes > Unfreeze Panes . Note that if you require toadd a editorial to Excel , it will be immobilize if added within a group of already frigid column .
Freezing rows and columns with keyboard shortcuts
you may also freeze Excel rows and pillar with keyboard shortcuts . Here ’s a small tilt of the most popular commands :
Step 1 : Freeze both rows and columns : PressAlt+W+F+F , with each key rap taking spot after the last . Once you ’ve selected a cell in Excel , this bidding freeze the rows and columns before the play up cell .
dance step 2 : suspend the top row : push Alt+W+F+R. Regardless of the cell that ’s pick out , this command will always immobilize the first row in your spreadsheet .
Step 3 : Freeze the first newspaper column : PressAlt+W+F+C. Regardless of the cell that ’s selected , this command will always freeze the first ( leftmost ) column in your spreadsheet .
How do you freeze rows and columns in Google Sheets?
like to Excel , Google ’s own spreadsheet package has freeze - unfreeze options for you to mess up around with . Here ’s how to access these stage setting :
Step 1 : Open a new spreadsheet in Google Sheets .
Step 2 : Choose the row or column you ’d like to freeze or unfreeze . Then , clickView > Freezeat the top of the page .
Step 3 : Now just choose how many row or pillar you ’d like to freeze . To unfreeze , clickView > freeze out > No rowsorNo column .
If you think this method sound easy , you might think aboutconverting your Excel file to apply Google Sheetsinstead .
How do you freeze rows and columns in MacOS Numbers?
While Apple ’s first - company spreadsheet software does n’t in reality have the same variety of freeze - unfreeze capabilities as Excel or Google Sheets , you could still freeze header row , header tower , or both . Here ’s how :
Step 1 : Open a Numbers spreadsheet and flick any area of the table . Then , clickTableat the top of the page .
Step 2 : ChooseFreeze Header Rows , Freeze Header Columns , or both . you may also selectHeader RowsandHeader Columnsto choose how many dustup or column to suspend .
While you might have saved a band of scroll through your Excel spreadsheet , it ’s a good idea to protect important data from inadvertent fixing . Learnhow to lock cubicle in Microsoft Exceland maintain the integrity of your information .
