Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I open an Excel file with a large number of cells, I want it to focus the last modified cell, i.e., the last cell in which I entered/changed data the last time I used Excel.

How can I automatically make Excel focus the last modified cell when opening an Excel file?

share|improve this question
Do you want this to happen for a specific file or for all files you open in Excel? – Excellll Aug 13 '12 at 13:25

Assuming that you've saved your work (and do not select other cells or worksheets before closing), Excel already does what you're asking.

Otherwise, you will need to have a macro-enabled workbook to store a variable with the address of the last modified cell. Then, in the code for your workbook (default: ThisWorkbook in VBE), select the range referenced by the variable in the Workbook_Open() function.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.