![]() ![]() With this shortcut you either set the or you remove the freezing, depending on if it is set already. If you want to freeze the heading rows or columns faster, you might want to memorize this keyboard shortcut: Type Alt –> w –> f –> f one after another. There are also the options of just freezing the top row of the sheet or the first column. Now, the rows above and the left columns of your marked cells are frozen. Its good for someone who have multiple record and when they are scroll. Click again on “Freeze Panes” on the list. Details: In this video i gonna show you how to create freeze header in excel.Select the cell, whose the row above and the column on the left you want to freeze. ![]() Freezing panes helps and keeps the important header row(s) always on top (the numbers are corresponding to the picture on the right hand side): How to make header row follow when scroll down worksheet in Excel This section will introduce the Freeze Panes function of Excel to make header row. ![]() The function in Excel is called ‘Freeze Panes’. Your worksheet is larger than your screen? When you scroll up and down, the header row of your data is invisible? Then let’s take a look at how you can make the header row or a column stick to the top of the screen (or on the left hand side in case of a column). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |