Curt Frye is a freelance course developer and writer. He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press. In addition to his writing and course development, Curt is a popular conference speaker and entertainer.

One thing that you may have learned to do (in older Excel versions) is keep data relevant by maintaining the visibility of row-header (left column) and column-header (top-row) title information by using the Excel option freeze panes from the window menu. I just signed up for the latest MS Office 365 Business Edition for my MAC through my ISP, Go Daddy. I assume it's 2016. I am unable to freeze several rows because the 'View' drop down menu only allows you 3 choices: 1. Unfreeze Panes. Freeze Top Row. Freeze First Column. I have tried all kinds of work-arounds with no luck. To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Panes option in the popup menu. Now when you scroll, you should still continue to see row 1 and column A.

His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show. By: Alicia Katz Pollock course • 3h 38m 3s • 853 viewers • Course Transcript Excel worksheets can contain a lot of data, but what do you do if you need to use data in two different parts of the worksheet at the same time?

Or, what you do if you have a data list, and you want to keep the headers on the screen, regardless of how far down or to the right you scroll? In this movie, I'll show you how to handle both of those situations by freezing rows and columns, and by splitting worksheets.

First, we will talk about freezing. Freezing a row or a column means that column or row stays in place, regardless of where you scroll in the worksheet.

For example, I have a column of data here, and it would be very useful, regardless of how far I scroll down, to keep these headers on the screen the entire time. If you want to do that, go to the Layout tab of the Ribbon, and then in the Window group, click the Freeze button, and then you can select Freeze Top Row. When you do, Excel draws a gray line, indicating that the top row has been frozen, and now when you scroll down, instead of having row number one scroll off the screen, you will see that it remains in place and the rest of the data on the worksheet scrolls. You move down through the rest of the rows. If you scroll back up, it's still there.

When you're ready to unfreeze the row, you can go back up to the Freeze button and click Unfreeze, and now the worksheet will scroll normally. If you want to freeze the first column, you can do that.

Just go back to the Freeze button and click Freeze First Column. Set up uf email for mac. Now when you scroll to the right, that column stays in place. So unfreeze, click the freeze button, and click Unfreeze. Now let's suppose that you want to freeze a specific area of the worksheet.