Fri 3 Jul 2009, 16:23Delegate Marya said...
Marya has attended:
Excel Intermediate course
Freezing panes
how do you freeze panes both vertical and horizontal together?
Mon 6 Jul 2009, 13:53
Edited on Mon 6 Jul 2009, 13:54Trainer Carlos said...
RE: freezing panes
Hi Marya
To freeze panes both Horizontal and Vertical together you first decide which columns and rows are to be frozen (Eg Column A and rows 1-5).
Then, in the above case, you select cell B6 because the system freezes above and to the left of the selected cell
Hope this helps
Carlos
