For example: If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row 4 to select it.

Split panes to lock rows or columns in separate worksheet areas. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze. Freeze panes to lock the first row or column in Excel 2016 for Mac. I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in (there never seem to be quite enough hours in the day!). Select the row or column after those you want to freeze. I can guarantee 9 times out of 10, one of my strategies will get you the answer(s) you are needing faster than it will take me to get back to you with a possible solution. I highly recommend that you check this guideВ out before asking me or anyone else in the comments section to solve your specific problem. Only these rows that freeze remain in their. Scroll down until you see the Lotus Compatibility section. In Excel 2010 and later versions display the File tab of the ribbon and then click Options.) Click Advanced at the left side of the screen. Now you can scroll throughout the worksheet without the freeze rows moving. (In Excel 2007 click the Office button and then click Excel Options. This is realized after clicking the View tab on the ribbon. Step 3: Then navigate to the window group of command icons and select the freeze panes command. That's why I want to share with you: My Guide to Getting the Solution to your Problems FAST!В In this article, I explain the best strategies I have come up with over the years to getting quick answers to complex problems in Excel, PowerPoint, VBA, you name it! The following image shows the sales revenue Sales Revenue Sales revenue refers to the income generated by any business entity by selling its goods or providing its services during the normal course of its operations. Step 2: Click the View tab on the Excel ribbon located at the top.

We all have different situations and it's impossible to account for every particular need one might have. How Do I Modify This To Fit My Specific Needs?Д¬hances are this post did not give you the exact answer you were looking for.

How to freeze frame in excel 97