Excel provides three options for freezing columns and rows so that they don't scroll off the screen as you move through large sets of data. If you want to freeze only the top row of a list in a worksheet, choose Freeze Top Row from the menu. The top row in the visible portion of the worksheet will then. This lesson explains how to freeze rows and columns (officially known as 'Freeze Panes') in Excel 2010 for Windows and Excel 2011 for Mac. Why you might need to freeze rows or columns in your spreadsheet. Imagine you have a spreadsheet that contains sales data for January.
Freezing a Row. Select the row below the row you want to freeze. To select a row, you need to select the entire row on the left side.
With the row selected, click on the “ View” tab at the top, select “ Freeze Panes” and you’ll see several different options you can choose:. “ Freeze Panes” will freeze all rows above your selected row. “ Freeze Top Row” will freeze only the top row no matter what row you currently have selected. Note: If you don’t see the “Freeze Panes” option, it might be because you already have panes frozen.
Select “Unfreeze Panes” to start over. Freezing a Column. To freeze a column, or a set of columns, you need to select the column to the right of the column(s) you want to freeze. With the column selected, click on the “ View” tab at the top, select “ Freeze Panes” and you’ll see several different options you can choose:. “ Freeze Panes” will freeze all columns to the left of your selected column.
“ Freeze First Column” will freeze only the left most column no matter what column you currently have selected. Freezing Columns and Rows Freezing a column and a row at the same time is a bit trickier unless you only want to freeze the left column and the top row, since those options are there all the time.
To freeze a set of columns and rows at the same time, click on the cell below and to the right of the panes you want to freeze. For example, if you wanted to freeze column A and row 1, you would select cell B2 since it’s below and to the right of these columns and rows. With the proper cell selected, select the “ View” tab at the top and click on the “ Freeze Panes” button, and select the “ Freeze Panes” option in the drop-down.
Unfreeze Panes To unfreeze your panes at any time, just click on the “ View” tab and click the “ Freeze Panes” button, then select “ Unfreeze Panes“. Filed Under: Tagged With:, Reader Interactions.
![]()
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 2. Freeze Top Row 3. Freeze First Column I have tried all kinds of work-arounds with no luck. (Placing my cursor several rows down, Highlighting several rows, Merging several rows, etc.) Nothing seems to work.
Does anyone have a suggestion? When is MS going to fix this glitch?
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |