Good Afternoon.

How has been your day?

Today, I will like to teach you how to freeze rows or columns on MS Excel.

What do I mean by the word freeze?

Freeze means to make something or someone stops functioning (not moving, working, walking).

For instance: If an engine or lock freezes, it stops working because its parts have become stuck and can no longer move

When you need to keep the top row or left column in view as you work with a large amount of data, you can Freeze it so it’s always visible on the screen (note – this does not affect printing).

1.Go to View/Freeze Panes

2.Select either Freeze Top Row (freezes row 1) or Freeze First Column (freezes column A)

steps-12

Note: To unfreeze, Follow step (1) and click on and select Unfreeze Panes.

 

Your questions are welcome.

Thank you.