MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find last filled cell in formatted sheet


Posted by Brad Smith on February 26, 2001 12:07 PM

I have a worksheet that is formated from A1 to approx. BC1700. And, I have only used 650 lines for input.

I need to quickly (shortcut key) find the A column cell of the last inputed row. CTRL+END will take me to BC1700. I know that I could just page/scroll down, but that would be to easy !

Any hints appreciated.

Brad


Posted by Faster on February 26, 2001 2:18 PM


ctrl + downarrow

or

doubleclick the bottom of anycell in Column A