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

simon

ResolvedVersion 2007

Paul has attended:
Excel Advanced course

Simon

Does the man in the window wear CK's or M&S????

RE: Simon

Paul

We cannot commit ourselves to advertise approvals.

Does it matter?

Welcome to the forum - did you know you now have 12 months support.

regards

Best Team

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

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.