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 » View Arrange all horizontal - both spreadsheets commencing in co
View Arrange all horizontal - both spreadsheets commencing in co
Resolved · High Priority · Version 2010
Fri 23 Nov 2012, 16:25Delegate Marta said...
Marta has attended:
Excel Intermediate course
Excel Introduction course
Excel Pivot Tables course
View Arrange all horizontal - both spreadsheets commencing in co
Good afternoon,
I am working with a workspace of two spreadsheets placed horizontally.
When I move along the top spreadsheet tabs, they always appear with the A1 cell in the top right corner, whereas when I move along the bottom spreadsheet tabs it doesn’t happen ( could be A45 or F30 to give some examples).
What can I do to have both spreadsheets having their A1 cell in the top right corner?
Many thanks
Marta
Mon 26 Nov 2012, 10:55Trainer Gary said...
RE: View Arrange all horizontal - both spreadsheets commencing i
Hi Marta
Thanks for getting in touch.
Excel saves the last position of the cursor when I file is saved. In this case it is coincidence. To correct this, you should move the cursor to A1 and save the file. A quick way to navigate to A1 is to press CTRL and HOME keys together.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 3 Dec 2012: Automatically marked as resolved.
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:Missing Field handleIf your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked. |
