To freeze columns, select the column to the right of the column or columns that you want to keep visible when you scroll.To freeze rows, select the row below the row or rows that you want to keep visible when you scroll.This means that if your table has column headings – or even row labels – you can freeze them in place so that you can always see them when you scroll.ĭepending on what you want to freeze, do the following: When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet. How do you remember what each number means? This problem becomes exacerbated when you have a large number of columns and the data in each is of a similar size. If you have a large table of data in Microsoft Excel and you scroll down, it can be hard to remember what each column represents.
0 Comments
Leave a Reply. |