Freeze columns and rows to keep them in view while you scroll through your data. Select the cell below the rows , and to the right of the columns you want to freeze . Then, by selecting a row below row 4 and scrolling up, you no longer see rows 5 through 9. Also, you don't see columns D through F. This brings a tight focus onto Q4 and the YTD totals in columns G and H. To undo a split, simply click View > Window > Split again. If you scroll down your worksheet but always see the same top rows , they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows . How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.
