98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Katy has attended:
Excel Introduction course
Viewing page
How can you see extensive data and still retain title boxes to corss-reference?
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:- |