Freeze rows or columns Freeze the first column • Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen. Freeze the first two columns • Select the third column. • Select View > Freeze Panes > Freeze Panes. Freeze columns and rows • Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. • Select View > Freeze Panes > Freeze Panes. Unfreeze rows or columns • On the View tab > Window > Unfreeze Panes. Collaborate for free with an online version of Microsoft Excel. Save spreadsheets in OneDrive. Share them with others and work together at the same time. You want to scroll, but you want to see your top row or left column to stay still. To do this, you use the Freeze buttons on the View tab. If the Freeze buttons aren't.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |