ykcpa.com
← Back to blog

Published on Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time) by Josh Krupnick

After I’ve added/deleted/moved/copied… basically, done enough work in an Excel worksheet so that when I hit Control-End, Excel goes to a cell far, far away from any of my work, I do the following to reset the “last cell”

Hit Control-End to see what Excel considers the last cell before you perform the instructions below.

Press Alt-F11

This should open the VBA editor

Press Control-G

This should open a window at the bottom with the title Immediate

Type the following in the Immediate window and then press Enter:

ActiveSheet.UsedRange

Now hit Control-End again and see how Excel jumps upwards and/or leftwards… you’ve done it!

Written by Josh Krupnick

← Back to blog

Recent Blogposts

to blog

  • Markdown Symbols - The key to speaking LLM-ese

    A guide to using Markdown formatting effectively when prompting LLMs, based on how models were trained on structured text.

    Read post →

  • How Do I Find Which Period a Check or Other Item Cleared the Bank

    A workaround to find which reconciliation period a check cleared in QuickBooks when the audit report doesn't show it.

    Read post →

  • How to reset the last cell in an Excel worksheet

    A quick VBA trick to reset Excel's "last cell" when Ctrl+End jumps too far away from your actual data.

    Read post →