how to freeze multiple panes in excel different sheets

If you see inaccuracies in our content, please report the mistake via this form. Thirdly, select ‘Freeze Panes’ from the ‘Choose commands from’ Then click ‘Add’ and OK to include it in the toolbar. Secondly, select ‘More Commands’ from the drop-down menu. If we have made an error or published misleading information, we will correct or clarify the article. STEPS: Firstly, go to the ‘ Customize Quick Access Toolbar ’ icon in the up-left corner of the screen. Finally, to freeze multiple rows or columns of your data, you must start by highlighting the row or column that you wish to freeze.

Our editors thoroughly review and fact-check every article to ensure that our content meets the highest standards.

Our goal is to deliver the most accurate information and the most knowledgeable advice possible in order to help you make smarter buying decisions on tech gear and a wide array of products and services. ZDNet's editorial team writes on behalf of you, our reader. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers. Neither ZDNet nor the author are compensated for these independent reviews. This helps support our work, but does not affect what we cover or how, and it does not affect the price you pay. When you click through from our site to a retailer and buy a product or service, we may earn affiliate commissions. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. Similarly there is a small bar on the right side of the horizontal scroll bar, placing your mouse pointer on it will show a similar two headed arrow effect now. You cannot, for instance, freeze the third column and nothing else around it.ĭownload the spreadsheet that accompanies this tutorial to see this feature in action in Excel.ZDNet's recommendations are based on many hours of testing, research, and comparison shopping. You can only freeze the rows starting from the top and the columns starting from the left. Go to the View tab and click Freeze Panes and, if there are any frozen panes in the worksheet, you will see the first choice in the list titled Unfreeze Panes, click that. Unfreeze/Unlock Columns and Rows in Excel Using this method, you can freeze the first two rows, the first two columns, the first two rows and the first 2 columns at the same time, basically whatever you want. Now, I can scroll down and to the right and the first column and row will remain in place.

Go to the View tab and click the button Freeze Panes and click the first option Freeze Panes:.

If I wanted to freeze Column A and Row 1, then I would select cell B2 because it is just below Row 1 and just to the right of Column A. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

Select the cell that is just to the right and to the bottom of the rows and columns that you want to freeze. To Freeze a row in Excel follow these easy steps: Select the row below the row (s) you wish to freeze.

Use this method to lock multiple rows or columns at the same time or to lock rows and columns at the same time. Steps to Lock Multiple Rows/Columns in Excel at the Same Time However, the first column and the first row cannot both stay frozen together unless you use another method, explained below. The first column now stays the same when I scroll to the right or left. If I chose to freeze the first column, then it would look like this:

Step 2: In the View tab, click the freeze panes drop-down under the window section. This is because the first four columns are to be frozen. Now, when I scroll, you can see that the first row never changes: The steps for freezing multiple excel columns are listed as follows: Step 1: Select the cell E1. I will select Freeze Top Row to lock the first row in place. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen.Go to the View tab and click the Freeze Panes button.Notes Steps to Lock Rows/Columns in Excel This allows you to keep header rows and columns in place so you can tell what each column or row is for no matter where you are in the worksheet. Prevent specific rows or columns from moving when you scroll through a spreadsheet in Excel.

How to freeze multiple panes in excel different sheets