How to fix the line in Excel

When working with large tables in Microsoft Excel There is a need to fix on the screen of a particular line so that it is not lost sight of when viewing the contents of any section of the table. This function is especially convenient, for example, when working with various catalogs, when it is necessary to fix the line with the names of the columns. Consider how to do this in various versions of Microsoft Excel.

Take the product catalog for example. In Excel 2003, the work algorithm is extremely simple: having determined the area for consolidation (in our case, the 2nd line), we highlight any cell per line below it (for example, C3) and in the “window” menu, click the “fix the regions”.

In Excel 2007, the principle of operation is the same. Having indicated the area of \u200b\u200bconsolidation with a cell below it, we go into the “View” tab on the upper toolbar, click “Fix the areas” and the point of the same name in the falling menu.

The instruction will be absolutely identical for the next versions of Excel 2010 and Excel 2013 . Please note that the program provides for automatically fixing the upper line or first column. In this case, the location of the selected cell does not matter.