WebbYou want to scroll, but you want to see your top row or left column to stay still. To do this, you use the Freeze buttons on the View tab. If the Freeze buttons aren't available on the … WebbControl + Fn + Left Arrow Key Go to Cell A1 (Top of the Page) Using the Name Box Trick Another quick and easy way to quickly go to the top of the page in Excel is by manually …

How to Lock Rows in Excel (6 Easy Methods) - ExcelDemy

Webb3 nov. 2016 · Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim MyPicture As Object Dim MyTop As Double Dim MyLeft As Double Dim BottomRightCell As Range '----- '- bottom right cell With ActiveWindow.VisibleRange r = .Rows.Count c = .Columns.Count Set BottomRightCell = .Cells(r, c) End With '----- '- position picture Set … WebbSelect View > Freeze Panes > Freeze Panes. Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select … how to help someone with money problems

how do I keep first line viewable when scrolling down in excel?

Webb28 sep. 2012 · The correct way to do this is to use something like: Application.ActiveWindow.ScrollRow = range.Rows.Count. Just to say that the accepted answer is wrong, this is the right answer. Just to say, the accepted answer works perfectly for Excel 2010 in my case. Webb23 juni 2024 · 2. In my Excel, I want to pin several rows. You see the first three rows: enter image description here. when I scroll up, the first three rows will be hidden: enter image … WebbThere's a short explanation with screenshots here; in more recent versions of Excel, there's a Freeze Panes button under the View segment of the ribbon. And the Excel 2007 version of that tutorial is here. This works for Excel 2013 too. Another way to do this, is there's a bar in the upper right corner that you can drag down for a horizontal ... how to help someone with motivation