Excel help

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?

 

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

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

cool!