Inls161 001 spring 2016 information tools setting up a. Microsoft excel taking the pain out of freezing panes accountingweb.
#Freeze pains excel 2011 mac for mac#
Ms excel 2011 for mac freeze first column. Now when you scroll down, you should still continue to see the column headings. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu. Select the Layout tab from the toolbar at the top of the screen. So, for example, you will see here, I have row one and all the headers, and this split here starts with 2006 in row 14.To freeze the top row, open your Excel spreadsheet. To do that, you select the cell below and to the right of where you want to split the worksheet.Īnd then again on the layout tab of the Ribbon in the Window group, you can click the Split button, which is this button right here. Unfortunately, those two pieces arent on the screen at the same time, so instead of scrolling back and forth, you can split the worksheet into two scrollable areas and work with it that way. When you are ready to undo the freeze, click the Freeze button, and click Unfreeze.Īnd now lets say that you have a huge worksheet, and you have data in two separate pieces of it that you want to work with. In another words by clicking cell B2, if I were to freeze the worksheet right now, wed freeze the top row and the leftmost column, the row above the selected cell, and the column to the left of the selected cell.Īnd just to prove that, we will scroll to the right and scroll down. You can do that, and the way to do so is to click the cell to the right and below where you want to freeze. Now lets suppose that you want to freeze a specific area of the worksheet.įor example, lets say that you wanted to freeze both the top row and the leftmost column. Now when you scroll to the right, that column stays in place. Just go back to the Freeze button and click Freeze First Column. When youre ready to unfreeze the row, you can go back up to the Freeze button and click Unfreeze, and now the worksheet will scroll normally. 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. 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.
#Freeze pains excel 2011 mac how to#
Excel 2011 Ze Row How To Theatrical AndĪs a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Ĭurt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.įreezing a row or a column means that column or row stays in place, regardless of where you scroll in the worksheet.įor 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.