The B is disappeared while A column is still in the view. You can see, the A column is appearing and the next column is C as I scrolled to the next column. Press the “ Freeze First Column” menu item as shown below:Īn example sheet is shown below with the first column frozen: Locate the “Freeze Panes” button and open its menu. In order to freeze the first column, follow this: Similarly, your headings may be contained in the left or first column of the workbook.
#Short cut key for freeze panes excel mac how to#
Using the shortcut for freezing the top rowįor unfreezing the top row: How to fix the first column example Press this button and top row should be unfrozen. As you open its menu, you should now see “ Unfreeze Panes”.
#Short cut key for freeze panes excel mac free#
If the top row is locked then again go to the View and free panes button. MS Excel should show a dark grey line that indicates the frozen pane. Locate the “Free Panes” icon and open its menu and press the “Freeze Top Row” option as shown below: No need to select the row, just go to the “ View” menu in the ribbon. Generally, it’s the top row that you would like to freeze in order to keep the headings in view all the time.įor fixing or freezing the top row, follow these simple steps: The shortcuts for freezing the top row and left column are given below with their examples. In MS Excel, press the “View” in the ribbon (top menu bar) and find the “Freeze Panes” icon in the toolbar as shown in the graphic below:įor locking the cells or panes, you may use the following shortcut form the keyboard: In this tutorial, I will show you the ways of freezing the panes top row, any other row, and column etc. To keep certain row or column, especially the top row or left column always in front of you can be achieved by using the “Freeze Panes” feature of MS Excel. For example, the top row contains the headers of the workbook and while entering data or analyzing it, you may lose the focus that what record belongs to which header. Freezing the rows or columns while working in a long workbook can be really useful.
0 kommentar(er)
