Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training company borough high street london - Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel training company borough high street london - Excel
Resolved · Low Priority · Version Standard
Reply Fri 9 Nov 2007, 16:59Delegate Teresa said...
For upcoming training course dates see: Pricing & availability
RE: Excel
Dear Teresa
Thank you for attending our Advanced Excel Course.
If I understand your question correctly then you want to know how to freeze a a group of rows as well as freeze group of columns simultaneously!!
If this was your question then the solution is as mentioned below:
please remember that when you apply freeze pane from the Window menu then any column to the left and any rows above get frozen.
for example, if D9 was the active cell and Window Freeze panes was selected then rows 1 through 8 (Rows above) will get frozen as well as Columns A, B and C (Columns on the left) will get frozen.
If this is not what you were asking then another feature which can be used is called Split window which can help you to divide your spreadsheet into four separate windows.
You will observe that you have two Horizontal and vertical scroll bars. You can use these to navigate a large spreadsheet.
Hope this helps!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor
|