You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet. You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows. To freeze a row (or unfreeze it later) you just need to use the "Freeze Panes" menu. Visit Business Insider's homepage for more stories.
Spreadsheets can get complicated, and frequently you need to be able to compare two different sets of data that are widely separated on your Mac or PC screen. An easy way to do that is to freeze a row (or column), so it stays in a fixed location while the rest of the spreadsheet scrolls up and down (or side to side). There are two ways to do this: You can freeze the first visible row on your spreadsheet, or you can freeze a set of rows. Check out the products mentioned in this article: MacBook Pro (From $1,299.99 at Best Buy) Lenovo IdeaPad 130 (From $299.99 at Best Buy) Microsoft Office (From $149.99 at Best Buy) How to freeze the top row in Excel Keep in mind that this doesn't have to literally be the top row in your spreadsheet — this command lets you freeze the first visible row. 1. Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters. 2. In the menu, click "View." 3. In the ribbon, click "Freeze Panes" and then click "Freeze Top Row."
Now, when you scroll through the spreadsheet, the top row that was visible will remain fixed while the rest of the spreadsheet scrolls under it. How to freeze a set of rows in Excel When you use this option, you're actually freezing all the rows from the top down to the row you want to freeze — you can't freeze a random row in the middle of a spreadsheet without locking everything above it at the same time. 1. Select the row below the set of rows you want to freeze. 2. In the menu, click "View." 3. In the ribbon, click "Freeze Panes" and then click "Freeze Panes."
How to unfreeze a row Once you freeze a row, you can return to the Freeze Panes menu in the ribbon and choose "Unfreeze" to toggle the locked row.
Related coverage from How To Do Everything: Tech:
How to combine two columns in Microsoft Excel without losing data
How to edit a drop-down list in Excel, depending on how you created it
How to copy a formula in Microsoft Excel using a Mac or PC
How to set a print area in Microsoft Excel to print a specific section of your spreadsheet
How to change the date format in Microsoft Excel to make the program write dates in a certain way
SEE ALSO: The best MacBooks you can buy Join the conversation about this story » NOW WATCH: Most maps of Louisiana aren't entirely right. Here's what the state really looks like.
More like this (3)
Summary List Placement While you might be satisfied browsing only other people's Pinterest boards for a while, eventually...Summary List Placement While you might be satisfied browsing only other people's Pinterest boards for a while, eventually you will probably want to create your own pins and share photos with others. If you're new to Pinterest, the process can be a bit confusing because it's not obvious how to get started. Here's how to create your own pins on Pinterest. How to create a Pinterest...
How to forward emails from Outlook to another account by creating a 'rule' that does it for you automatically
You can forward emails from Outlook by creating a rule that instructs Outlook to automatically forward...You can forward emails from Outlook by creating a rule that instructs Outlook to automatically forward email to another person or email account, as long as it's in your Outlook contacts. You can set up forwarding using the Rules button in the ribbon bar. When you set up a forwarding rule, you can forward all the email arriving in a specific email account, from...
To lock your cells in Microsoft Excel, you just need to head into the program's "Protection"...To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which is useful if you're sharing a spreadsheet with precise data. Once you lock a cell, you'll be asked to set a password. Excel will ask you for this...