Let's say you've got too much vertical data in your spreadsheet. Combine this with countless columns of data and you may very well forget the labels for each set. No worries! Select the row beneath the one you'd like to lock into place, then click Window | Freeze Panes. This will allow you to scroll up and down without having to refer back to each column's designation. You can do the same thing horizontally. Remember, to select an entire range of cells, single click the appropriate letter or number.