First row to display

[JungleJim74]

I have the window panes frozen so that I get my header and my leftmost colum
(which is the Month/Year) frozen.

Is there a way to set it so that the current Month/Year are the topmost row
that is displayed? In my worksheet for my "Budget" I have rows for each Month
in 2009 but I want it to display the row identified as "May09" at the very
top and not to display the rows "Jan09" through "Apr09". I want those months
out of sight.

Then next month I want it to display the row "Jun09" at the very top.

Thank you in advance for any response. JungleJim74

 

[David McRitchie]

Not clear if you are looking for a VBA (automated) solution, which would
best be asked in the programming group.

Not clear if you are looking to position the first visible row at a row,
or are actually want to hide rows from row 2 to the row before the
first to be shown. If you hide the rows, you would only copy (Ctrl+C)
or print from the non-hidden cells.

Manually, working from a selection
Format, rows, hide/unhide
Format, columns, hide/unhide

To unhide all cells use Ctrl+A to select all cells
Excel 2003 you will have to use Ctrl+A at least twice
Excel 2007 you will have to use Ctrl+A at least three times
Or, you can use the select all cells button at the intersection of the
column and row headings instead, but that will select the cell in
the upper left corner which is not at all the same as use of Ctrl+A.
Then Format , columns, unhide (shortcut for Format is Ctrl+1)