Freezing columns in Excelįor instance, the information in the table has a horizontal direction. There you must always (!) activate the cell under the freeze row. In earlier versions the “Lock areas” tool is located in the “Window” menu on the main page. Note: This method works for 20 Excel versions. Thus, you can fix two, three, four and more rows. When you perform horizontal and vertical scrolling, the cap and the top row of the table remain fixed. This action will help Excel to “understand”, which area should be fixed Select any cell under the line, which we will fix.Doing it is possible and easy, when you follow these steps:
For instance, another row or even a couple of rows must be fixed when scrolling the document. Let us suppose, a user needs to fix not only the cap. Locking several rows in Excel while scrolling Now when you scroll vertically the table cap will be always visible. You will get a delimiting line under the top line. In the menu select the “Freeze Top Row” functions.Go to the “VIEW” tab using the tool “Freeze Panes”. Create the needed table and fill it with the data.To make the cap visible when scrolling, fix the top row of the Excel table, following these actions: Scrolling the page to its beginning to return to the correct cell is absolutely irrational. Working with multipage table blocks is inconvenient when column names are not visible. Meanwhile, this document can have up to thousands of rows. Therefore, the Tabular Processor has possibilities to fix certain areas. Scrolling the page to see the name of the document is not comfortable for any user.
The columns and rows names can be significantly removed from the cells with which the user is working at this time. Most people using PCs work with it constantly. The Microsoft Excel program is designed not only to enter data into the table conveniently and edit it as you need it, but also to view large blocks of information. How to fix a row and column in Excel when scrolling
0 kommentar(er)
