FREEZE PANES

FREEZE PANES IN EXCEL.

When we ever work and we move our sheet from SCROLL BAR towards the bottom, then our above HEADING gets removed so that we do not know what the DATA given below is about. So to remove this PROBLEM we use FREESE PANES OPTION to freeze our above ROW or further COLUMN so that it does not move when SCROLL is removed. We can FREEZE or FIX ROW and COLUMN using FREEZE PANES.

In this we are told 3 OPTIONs we will learn to use all these OPTIONS.

01. FREEZE PANES.

02. FREEZE TOP ROW.

03. FREEZE FIRST COLUMN.

01. FREEZE PANES OPTION

Using the FREEZE PANES option, we can easily FREEZE any ROW and COLUMN.

In the below given photo, we have to FREEZE the two ROWs above and FIRST COLUMN given in LEFT is also FREEZE.

STEP -1 # First of all we will do a CELL SELECT below the ROWS we want to FIX.

After that we will select as many COLUMNs as we want to FIX and select a CELL in the COLUMN next to it.

This means that we will do a CELL SELECT above which all ROWS we have to FIX and all subsequent COLUMNS to FIX.

For EXAMPLE we have SELECT B3 CELL here.

FREEZE PANES

STEP -2  #   After this, we will CLICK on the OPTION of FREEZE PANES in VIEW TAB.

FREEZE PANES

STEP -3 #   After this, we see OPTION of FREEZE PANES and will CLICK on it.

After CLICK on the OPZ PANES OPTION, our first COLUMN and first two ROWs are FIX. After this, if we do SCROLL towards the bottom, then our HEADING and FIRST COLUMN does not remove.

So in this way we can easily FIX COLUMN and ROW.

02. FREEZE TOP ROW

If we ever want to FREEZE only the first TOP ROW then we will use this OPTION.

No matter our CELL SELECT stay in it.

FREEEZE PANES

Using this, our TOP ROW becomes FIX, after this, we SCROLL our data below, even then we see TOP HEADING above. And with this we can do our work easily.

03. FREEZE FIRST COLUMN

If we ever want to FREEZE only the first FIRST COLUMN then we will use this OPTION.

No matter our CELL SELECT stay in it.

Using this, our FIRST’s COLUMN becomes FIX, after that we SCROLL our data in RIGHT SIDE, even then we see the HEADING of LEFT. And with this we can do our work easily. We do not have to repeatedly see what we have written in HEADING. And our time is also saved.

So in this way we can easily do our work using FREEZE PANES.

For more information see VIDEO -

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram