Hardly anyone will ever use them to the limit, but if your worksheet contains tens or hundreds of rows, the column headers in the top row disappear when you are scrolling down to view lower entries. These tips work in all modern versions of Excel 2016, 2013, 20.Īs you probably know, the recent versions of Excel 2016, 20 allow using more than a million rows and over 16,000 columns per sheet. How To Freeze Rows In Excel 2013 The tutorial demonstrates quick ways to freeze panes in Excel. If your focus is in the are that is Static (FixedLocked) and try to scroll you will scroll only that pane. If you do anything else in the Freeze Panes and then Try to Split it will only Give you One Thick Black Line. I did figure it out however, First Split the panes and then move the large black Lines to the rows and columns that you want Static (or Fixed) you can click Freeze panes Freeze Panes and then click Split or you can just click Split. Note that under the Freeze Panes command, you can also choose Freeze Top Row, which will freeze the top row thats visible (and any others above it) or Freeze First Column, which will keep the leftmost column visible when you scroll horizontally.īesides allowing you to compare different rows in a long spreadsheet, the freeze panes feature lets you keep important information, such as table headings, always in view.Īdditional Help I found it Very Difficult to figure out how to do this for the Top row and for a couple of Columns. If you want to unfreeze the rows, go back to the Freeze Panes command and choose Unfreeze Panes. You can tell where the rows were frozen by the green line dividing the frozen rows and the rows below them. In this example, we want to freeze rows 1 to 6, so weve selected row 7.Īs you can see in our example, the frozen rows will stay visible when you scroll down. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. Select the row right below the row or rows you want to freeze. How To Freeze Rows In Excel 2013 How To Freeze Rows In Google Sheets There are two quick steps to freezing or locking rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |