98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-course - Viewing page
excel-training-course - Viewing page
Resolved · Low Priority · Version Standard
Wed 16 Jan 2008, 15:21Delegate Katy said...
Katy has attended:
Excel Introduction course
Viewing page
How can you see extensive data and still retain title boxes to corss-reference?
Thu 31 Jan 2008, 10:53Trainer Katie said...
RE: View a large page
Hi Katy,
Thanks for your question.
I think FREEZE PANES will solve your problem.
- 1. Select the first data on top left corner of your table
2. select WINDOW menu > FREEZE PANES
That should fix both top rows & left column, you can then scroll to see other data with the labels remain as the reference.
Let me know if this works.
Regards,
Katie
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. |
Excel tip:How to Remove Duplication's from a selection of data in an Excel 2010 WorksheetIt would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:- |
