Advice 1: How to fix header in excel

When creating a spreadsheet it is often important that the column headers always remain visible, regardless of scrolling the page. However, a large number of rows that don't fit on the screen vertically, headers are mostly for top edge together with the upper area of the sheet. In the table editor Microsoft Office Excel provides features that allow you to freeze any number of rows, excluding them from the scroll area of the table.
How to fix header in excel
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
If you want to attach only one header row, then click on the "View" menu of the table editor and open the drop-down list to "Consolidate region". He was placed in command group "Window" and contains three versions of "freezing" of the cells. You need the middle item - "to Fix the top row". The selection of the row you and complete the process of consolidation of the table header.
2
The third paragraph (the"Lock first column") in this drop down in a similar way disables the scrolling of the first column of the table.
3
If you want to fix not only the one or few rows at the top, but also a number of columns in the left part of the table, then the procedure is slightly more complicated. Select the first (upper-left) cell of the scrollable area - all that will remain to the left or above it will be recorded when the document is scrolled. Then in the drop down "freeze panes" on the "View" tab, select top line ("freeze panes").
4
Use this list item if you want to dock more than one of the top lines. To do this, proceed as in the previous step, but do not leave to the left of the selected cell of any column. In the same way fixed and some columns at the left edge of the table - to do this, select the cell in the top row.
5
If you make a mistake or want to cancel made earlier, freeze panes, it will help the same drop-down list. If the page table has a "frozen" a range of cells, then added to the list an additional item - "Remove the freeze panes".
6
In addition to fixing the particular region of the document in Excel it is possible to split the sheet into multiple frames, each of which will have its own scrolling. To split a table into two vertical Windows, hover the cursor over a thin strip, is placed above the vertical scroll bar between the up arrow button and the formula bar. The cursor will change its appearance - it will become bi-directional vertical arrow. Press the left button and drag this bar down to the desired height of the top of the frame. Similarly, you can split the table vertically.

Advice 2: How to fix a row in Excel

Microsoft Excel has an extensive set of tools for working with spreadsheets, particularly to create viewports on the sheet. This can be done through consolidation of certain rows and columns.
How to fix a row in Excel
You will need
  • computer;
  • - program Microsoft Excel.
Instruction
1
Perform the split or freeze panes sheet to get the opportunity to view two panes or lock rows or columns of one of them. When docked Windows can be selected individual columns or rows that will be displayed on the screen at the time of the scroll sheet.
2
For example, you can fasten the field sheet, leaving on the screen only the row and column headers. When you split the window, in this case the creation of separate regions that can scroll independently from each other, and then the inactive pane will remain on the screen.
3
Highlight the row on the sheet, under which to run the separation sheet. This action will consolidate the selected line on the screen. To block the lines and columns, click the cell to the right and below which you want to divide the sheet.
4
Go to the mode tab, then in the function group Window click the "freeze panes", then select the desired option. Similarly, you can remove the pinning rows and columns. This command is designed to consolidate selected areas in Microsoft Excel 2007 and later.
5
Do the freeze panes in Microsoft Excel earlier versions. To do this, open the desired spreadsheet, select the rowyou want to freeze. Then go to menu "Window". Select "freeze panes".
6
To lock the field and to split the window into multiple parts, place the mouse pointer on the scroll bar next to the line to change it to a bidirectional arrow. Drag the splitter down to the required position. This will allow you to view two parts of a spreadsheet and to fix a few lines in different parts of the document.

Advice 3: In Excel how to freeze a column

When working with tabular data in Microsoft Office Excel there is often a need to display the headers of the columns or rows in each moment, regardless of the current scroll position of the page. Operation that captures the specified columns or rows in the spreadsheet called Microsoft Excel freeze panes.
In Excel how to freeze a column
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".
Search
Is the advice useful?