Worksheets OF A Workbook

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Working With the Worksheets of a Workbook

Freezing a Row

In Lesson 2, we saw that you could use a column as a basis to freeze a group of cells on a vertical line and prevent them from moving to the left or right when you scroll the other section. In Lesson 3, we saw that you could freeze a row so that the cells above that row would not be scrollable. You can combine these two features and apply them to one particular cell.

To freeze the cells above and on the left side of a cell, click that cell. On the Ribbon, click View. In the Window section, click Freeze Panes, and click Freeze Panes. When you do this, the cells in the column from the left and the cells from the other left columns would be fixed. The cells in the row above and the cells from the other top rows would be fixed.

To remove the freezing, on the Ribbon, click View. In the Window section, click Freeze Panes, and click Unfreeze Panes.

Practical Learning: Freezing a Row

  1. Open the RTHS4.xlsx workbook
  2. Click Cell D6
  3. On the Ribbon, click View
  4. In the Window section, click the Freeze Panes button and click Freeze Panes
  5. Press Ctrl + Home
     
    Freezing a Cell
  6. Scroll down to be able to see Row 54:
     
    Frozen Cells
  7. In the Window section of the Ribbon, click Freeze Panes and click Unfreeze Panes

Splitting the Interface

In Lesson 2, we saw how to use a column to divide the groups of cells in two vertical sections. In Lesson 3, we saw how to divide the cells into two horizontal groups. In both cases, the division made it possible either to scroll from one of the sections or even to move the dividing bar itself to make one section bigger than the other. Instead of dividing based on the columns or rows, you can use a cell and split the cells into four scrollable groups.

To split the cells into four groups, click a cell. On the ribbon, click View. In the Window section, click Split. This would display two bars crossing each other. The user can scroll in one of the groups. To increase the width or the height of some sections, you can position the mouse on one of the bars or on the intersection of the bars, then click and drag in the direction of your choice until you get the sizes you want. Then release the mouse.

To remove the splitting bars, double-click one of the bars or their intersection.

Practical Learning: Splitting the Rows

  1. Click Cell E12
  2. In the Window section of the Ribbon, click the Split button
     
  3. Position the mouse on the intersection of the split bars
  4. Click and drag up and left
     
     Split
  5. Scroll in the top-left frame
  6. Scroll in the bottom-right frame
  7. In the Window section of the Ribbon, click the Split button
  8. Save the file