Breaking

Monday 21 May 2018

How to freeze panes in Excel

Freeze Top Row 


                                        1. Click the View Tab
_________________________________________________________________________________

                                         2. Select Freeze Panes
_________________________________________________________________________________

                                         3. Select Freeze Top Row
________________________________________

Freeze First Column


                                        1. Click the View Tab
_________________________________________________________________________________

                                         2. Select Freeze Panes
_________________________________________________________________________________

                                         3. Select Freeze First Column

________________________________________


Freeze Panes

1. You will want your cursor to be below the row(s) you want to  freeze and to be right of any column(s) you want to freeze. 
E.g. you wants to freeze Row 1 & Column A,B. In this case you have to select cell C2.

_________________________________________________________________________________

                                         2. Click the View Tab
_________________________________________________________________________________

                                         3. Select Freeze Panes
_________________________________________________________________________________

                                         4. Select Freeze Panes
________________________________________


No comments:

Post a Comment