You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
Run the table editor, open a file with the table and navigate to the desired page of the document.
2
If you are using Microsoft Excel version 2007 or 2010, and to consolidate need the left-most column of the current worksheet, just click on the View tab. Expand the dropdown list to "Consolidate region", which is placed in the job command Window. You need the bottom line of the list - "Lock first column" - click on it with the mouse or select by pressing the key with letter "y".
3
If you need to fix not only the first column , select the column located to the right of the last column of the anchoring group. To do this, click with the left mouse button the title of this column, ie, cell over-the-top string when you hover over that, it changes form and becomes a black arrow pointing down.
4
Open the "freeze panes" tab on the "View" menu of the table editor, but this time select the top most line is "freeze panes". This menu option may fail if the worksheet is already enshrined in other region. In this case, its place in the list will be a command to "Remove the freeze panes" - select it first, and then expand the list and select returning to the scene the item "freeze panes".
5
In the 2003 version of the table editor menus are arranged differently, so selecting the column, following the anchoring, expand "Window" and select "freeze panes". This team is one for all the variants of fastening.
6
If it is necessary to consolidate not only speakers, but also some number of rows, highlight the first cell of the floating region, i.e. the upper and the left of the scrolled area of the table. Then, in Excel 2007 and 2010 repeat the fourth step and in Excel 2003 select "freeze panes" from the "Window".