Excel: Keep Headings in View Whilst Scrolling

A question I've been asked a few times is how to keep headings in view when you scroll down or across a large spreadsheet.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtWUF4T08I/AAAAAAAAEt8/PGuFYZ3YIAQ/s1600-h/20090619a.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348963885608326082" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtWUF4T08I/AAAAAAAAEt8/PGuFYZ3YIAQ/s400/20090619a.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>Here I've got a spreadsheet that records the number of views my photos get daily at my <a href="http://www.flickr.com/photos/bispham2/">Flickr account</a>. Every day I look at the stats on my account and in the spreadsheet I enter the number of views per day and the number of photographs I have stored there. From these two pieces of information the spreadsheet can work out the total number of views by adding the total from the previous day to the daily number of views and the average views per photo by dividing the total views by the number of photos.<br /><br />However over the course of a year or two there are so many entries (days) that the column headings would normally disappear off the top of the screen when you scroll down.<br /><br /><a href="http://4.bp.blogspot.com/_i9xWjDR4D-E/SjtXlevVcXI/AAAAAAAAEuE/znGhpeXcGIg/s1600-h/20090619b.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348965283850973554" src="http://4.bp.blogspot.com/_i9xWjDR4D-E/SjtXlevVcXI/AAAAAAAAEuE/znGhpeXcGIg/s400/20090619b.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>To stop this happening I've used the <em>Freeze Panes</em> function of Excel to stop the top two rows from scrolling. Those two rows contain the headings and remain on screen whilst the rest of the rows scroll.<br /><br />To start, select the cell underneath and to the right of the rows and columns you want to keep in view. In my example I only want to freeze the top two rows, not any columns at the left, so the cell I've selected is A3.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYaVyCBrI/AAAAAAAAEuM/V3x7Q0iok2c/s1600-h/20090619c.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348966191979431602" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYaVyCBrI/AAAAAAAAEuM/V3x7Q0iok2c/s400/20090619c.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>Then I select the <em>View</em> tab from the menus at the top.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYruk1jII/AAAAAAAAEuU/5PmDXltGF6A/s1600-h/20090619d.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348966490692750466" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYruk1jII/AAAAAAAAEuU/5PmDXltGF6A/s400/20090619d.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>Finally I select one of the options from the <em>Freeze Panes</em> icon.<br /><br />Note that once you have frozen some headings, the options change to include an <em>Unfreeze</em> option.<br /><br />Now I can scroll down as far as I need to and can still see the column headings.

Diposting oleh Abdullah Syafii