The top panel of the program allows you to edit the contents of the spreadsheet. By default, the panel is secured and is displayed along with all tabs and icons that you need to complete a particular task. To undock the panel and to hide it, you can use the special pointer-arrow, which is located in the lower right part of the panel.
To return the region to the deployed fixed as you can click on the button downward, to again show the need to manage the interface elements.
For fastening only the tabs bar and remove the icons you can click on the icon of the window up arrow, which is located in the upper right corner of the interface, left of the button for minimizing the window. This will increase the usable space of the editable document on the screen. Select the option "Show tabs" or "auto-hide ribbon" to change the display settings.
In addition to the top bar, you can pin the selected line of the table that will be displayed when you scroll the document. Select a line that needs to be fixed on screen when scrolling. To do this, click on the corresponding line pointer in the left panel of the program.
Go to the tab "View" where you click "freeze panes" located in the "Window". You can also freeze a column for horizontal scrolling. To do this, select "Lock first column". To leave visible only one line, select "pin to top line". The panels are Excel complete.
For removing the fixed region again, go to menu "View" "Window" "freeze panes". Click "removing the frozen panes" and click "OK".
The fixing of the elements of the table should run on each document separately.
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.
You will need
- - program Microsoft Excel.
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.
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.
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.
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.
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".
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.
You will need
- Spreadsheet editor of Microsoft Office Excel.
Run the table editor, open a file with the table and navigate to the desired page of the document.
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".
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.
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".
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.
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".