![]() Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. If the data you want to keep stationary takes up more than one row or column click the column letter or row number after those you want to freeze. On the View tab in the Window group click Freeze Panes. ![]() ![]() If youd rather freeze the leftmost column instead click the View tab. Click View Freeze Frames.Īpply formatting Format as table Freeze rows Add print title Apply formatting We can make the first row as header by changing the format of the first row of data in order to make its appearance distinct from the other cells. How To Troubleshoot Excel Freeze Panes Not Working Issue Excel Fix It Workbook Overview of formulas in Excel. You should get a new menu with your 3 options. You will learn how to quickly lock header row orand the first column.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |