How to display the active cell in top left in Excel screen?
Sometimes, you just want the active cell displayed in the top left in the Excel screen as below screenshot shown. In general, you may drag scroll bar down manually to finish this job, but here I introduce a VBA code to quickly scroll the active cell to the top left of the Excel screen.
To use VBA code to display active cell in top left of screen, you can do as these:
1. Click a cell you want to display in top left and press Alt + F11 keys to enable Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and copy and paste below code to the blank script.
VBA: Scoll active cell to top left
Sub TopLeft() Application.Goto ActiveCell, Scroll:=True End Sub
3. Press F5 key to run the code, then the active cell has been gone to top left of screen.
Easily merge two tables and update the new items in Excel
|In some times, you may want to merge two tables into one, and update the itmes and add new ones. Kutools for Excel's Tables Merge utility can merge the Main table with the Lookup table into one, and update the main table as the preview shown. Click for 60 days free trial!|
|Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.|
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 5 months agoThank you so much for the info. I have spent 3 hours looking up in books and googling to find a way to get a range of cells sitting at t3 through x42 to appear in the top left (A!) position on a button click. I got every answer but the right one, until now. The scroll did it for me. You are the only one who understands a question properly (or at least my questions). This site is now bookmarked at the top of the list.