• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Excel help

A

actuary.jk

Member
Is there a way you can shift your active cell to the last active cell in Excel?

We have such equivalent in MS Word, Shift+F5
and in Adobe reader Alt+Left arrow.

When we are comparing spreadsheets it is easy to Alt+Tab but when you have to compare worksheets(Tabs) within a single spreadsheet is kinda tough.

Will be grateful to know if we can shift between activecell now and the previously active cell.
 
Try <Ctrl>+<End>.

This takes you to the bottom right corner of a box that surrounds all of the non-empty cells.

<Ctrl>+<Home> is the top left corner.

Alternatively you could try pressing <End>, then one of the arrow keys to move around. Bit difficult to explain, but it moves to the next cell in the direction you pressed, which is the start/end of a continuous block of non-empty cells in that row/column.

To compare different worksheets within the same file, you can cycle through them using <Ctrl> + <Page Up> (or <Page Down>)

Does this help?
 
Last edited by a moderator:
Is there a way you can shift your active cell to the last active cell in Excel?
Click to expand...

First thought that you meant bottom or right by "last active cell".

It just occured to me that you may have meant previous active cell in which case I don't know if there is such a shortcut in Excel.
 
do something minor to a cell adjacent to your "previous active cell", say highlight it yellow.
repeat the same with an adjacent cell to your "new active cell", say again highlight that cell yellow.

pressing Ctrl+Z twice and Ctrl+Y twice will toggle you between the two cells, so that you may compare them..

once done, of course, you may want to reset the original highlighting colour of both the adjacent cells.

did that help? yeah this is bit long procedure in itself, but i couldn't think of anything better...
 
Try "File - new window" - then you can Alt+TAB between them. Make sure that each window has one of the two sheets you are interested in.

There's also F5 - special - last cell, but that only seems to work within the same sheet (not a different tab).
 
definitely much better... thanks :cool:

in summary:
"ALT+TAB" bw different workbooks
"New Window" bw different worksheets within same workbook
"Split" bw different locations within same worksheet

cool!
 
You must log in or register to reply here.
Back
Top