Set c = (Target.Cells(1).Row, 1)ĭo While (Not c.Value Like "Summary*") And c. ' go up until find a content like "Summary*" 'get the first cell on the selected row, then Private Sub Worksheet_SelectionChange(ByVal Target As Range) One difficulty is that to scroll up you have to click on one of the rows in the top pane. Alt-W-F brings up the following Freeze Panes drop-down: The three options are: F to freeze both rows and columns based on where your cursor is (this will freeze rows and columns to the right and to the left of your cursor) R to freeze the top row only. Each time the selection changes, it checks upward in the first column for content like "Summary*": if the worksheet isn't already frozen to that row, it will make that adjustment. The Freeze Panes shortcut is an easy left-hander: Freeze Panes Drop-Down: Alt-W-F. Watch the video below to learn more about freezing panes in Excel. Optional: Download our practice workbook. You can try this out (in the worksheet code module). Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, including the ability to freeze panes and split your worksheet. Freeze Panes in Excel 2010, If you set up a worksheet with row or column headings, these headings will not be visible when you scroll down or to the right.
0 Comments
Leave a Reply. |