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.|