Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

view arrange all horizontal

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

ResolvedVersion 2010

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

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.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.