Hiding Freezing And Splitting Columns

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

Hiding, Freezing, and Splitting Columns

Hiding and Revealing Columns

When working on a list, you don’t always need all columns displaying all the time. You can hide a column whose presence is not required at a particular time. In Microsoft Excel, you can hide one or more columns.

To hide one column:

  • Right-click the column and click Hide
  • Click the column header. On the Ribbon, click Home. In the Cells section, click Format, position the mouse on Hide & Unhide, and click Hide Columns

Hide Columns

When a column has been hidden, its letter disappears from the sequence and the line between the previous neighbors is thicker than the other dividing lines:

To hide many columns, select the columns. Then:

  • Right-click one of the column headers or inside the selection and click Hide
  • On the Ribbon, click Home. In the Cells section, click Format, position the mouse on Hide & Unhide, and click Hide Columns

To reveal the hidden columns:

  • Right-click any column header and click Unhide
  • On the Ribbon, click Home. In the Cells section, click Format, position the mouse on Hide & Unhide, and click Unhide Columns

Practical Learning: Hiding a Column

  1. Right-click Column E and click Hide
  2. Save the document

Freezing One or More Columns

If you have a list wider than the Microsoft Excel area can show, you can scroll to the right to see hidden columns. While you are scrolling to the right, some columns would be disappearing from the left section of the Microsoft Excel interface. If you want, you can freeze a column so that, when you scroll to the right, a column or some columns would be fixed and would not move. Also, the column(s) from the left of the frozen column would not move either.

To freeze a column, click the column header of the column that will lead the moving columns. On the Ribbon, click View. In the Window section, click Freeze Panes, and click Freeze Panes.

Practical Learning: Freezing a Column

  1. Open the RTHS2 file
  2. Click Column Header E
  3. On the Ribbon, click View
  4. In the Window section, click Freeze Panes
  5. Press Ctrl + Home
     
    Spreadsheet
  6. Scroll to the right. Notice that Column D and its left columns are not moving
     
    Frozen Column
  7. In the Window section of the Ribbon, click Freeze Panes and click Unfreeze Panes

Splitting the Columns

An alternative to freezing is to split the group of columns into two sections. Just as done for the freezing, you can choose a column to use as reference and scroll the columns from its side. To split the group of columns in two, click a column header. On the ribbon, click View. In the Window section, click Split. This would display a bar:

Split Columns

The similarities between the freezing and splitting are as follows:

  • The columns are divided in two groups
  • The user can scroll the columns from the right side of the divider

The differences between the freezing and splitting are as follows:

  • If you freeze a column, you can scroll the columns on the right side of the frozen line but you cannot scroll the columns from the left side of the frozen line. If you split the columns, you can scroll the columns from either the left or the right side of the splitting bar
  • If you freeze a column, you cannot move the freezing line to another column (you would have to unfreeze the column, then re-freeze). If you split the columns, you can move the splitting bar to the left or the right
  • If you freeze a column, to remove the frozen line, you use the Ribbon. If you split the columns, to remove the splitting line, you can double-click it or, in the Window section of the View tab of the Ribbon, you can click the Split button

Practical Learning: Splitting the Columns

  1. Click Column Header I
  2. In the Window section of the Ribbon, click the Split button
  3. Press Ctrl + Home
  4. Position the mouse on the split bar
     
     Split
  5. Scroll in the left frame
  6. Scroll in the right frame
  7. In the Window section of the Ribbon, click the Split button
  8. Close Microsoft Excel. If asked whether you want to save, click No