Advice 1: As in Excel to display hidden rows

Microsoft Excel is a program for working with spreadsheets. It is convenient to make calculations, processing large amounts of data, analyse existing information and to perform many other actions.
As in Excel to display hidden rows
You will need
  • Computer with Microsoft Excel.
Instruction
1
Hiding a row is a special Excel function that allows you to remove some data from the form. Due to this it is much easier to work with a large table without getting lost in unnecessary information. In addition, by removing some rows, you can print only those that you need, without rewriting the entire table.
2
After working with the table display hidden in the process line. To do so, select adjacent lines (by one), click on the designated area with the right mouse button and select in the ensuing menu "Display". Hidden information will return to its original position.
3
Restore hidden lines can be the other way. Scroll to similarly close the lines, click on the toolbar, the Format tab, point your mouse cursor to the item "Hide or display" and select in the appeared context menu the "Display line". Then removed from the point will appear.
4
If hidden - line is across the table, do not torture yourself tangled search numbers. Just highlight the whole table, click the right button and select "Display" in the menu that appears.
5
To find out which location is hidden from the eyes of the information, look closely at the line numbers in the table. In the place where they get off and begin to go out of order, there are hidden rows. And the dividing line between these numbers more oily compared to the rest.
6
Such actions are applicable and to the hidden columns. Only for display it is necessary to allocate two adjacent columns. And to know the place of hidden information by letters are not in alphabetical order.
7
Use this function when working with large amounts of data, constructing graphs on the basis of the table. And when you need to remove from prying eyes any information.

Advice 2 : How to sum in Excel

Excel refers to Microsoft Office, supplied with the software company Microsoft. It is a table editor that allows you to perform various actions with the data. With this program you can perform various mathematical operations, processing of large amounts of data, presented in tabular form, building them on the basis of graphs, charts, to analyze the obtained results.

How to sum in Excel
You will need
  • - computer
  • - Microsoft Office Excel.
Instruction
1
Log in. To do this, click "start" in the lower left corner of the monitor. In the window that opens on the left look for the name Microsoft Office Excel 2007.

Figure 2007 is the year in which was released the version installed on your computer. Release year may be 2000, 2003, 2007, etc. When you find the program, open it.
2
If such a program is not listed, then in the same menu "start" select "All programs." Here you should find the tab "Microsoft Office", and in it already - Microsoft Office Excel 2007.
3
You'll get a sheet composed of cells-cells. Each cell can make a variety of actions, including to set formulas and do calculations.
4
To summarize in Excel means to lay down the given numbers. For this there are different ways.
5
Stand on any cell where you want to be specified of the result. Put a sign "=". This means that the cell you will perform arithmetic operations and working with formulas. After "=" write through "+" the number that you want to add. At the end press "Enter". The cursor drops to the cell bottom or to the right, and the cell will affect the result of the addition. To view the numbers that you summarized, put the cursor on a cell. At the top below the toolbar there is a long line to the left of where it says "fx". Here will be reflected in the number that you put.
6
Now consider the option "autosummary". Usually it is the toolbar and is denoted by "∑". Option allows one to sum the numbers written in different cells. Cells must go after each other in a column or line, to be able to select the rectangle. Write down the numbers that you need to add a column in the cells below each other. Then position the cursor on the cell after the column and click the icon "∑". Appears a shimmering frame. It allocates a range of numbers that need to be folded. The boundaries of this frame can be changed. To do this, click on the left mouse button and drag the lower right corner of the frame. When you set boundaries, press Enter. Further, all the same. Only in the formula bar will indicate the formula used in Excel to sum the numbers region.

Advice 3 : How to Excel collapse rows

In Microsoft Office Excel, you can hide columns and rows in the table. This is useful in cases when it is necessary to increase the visibility complex tables, displaying only the most important data, or hide confidential information.
How to Excel collapse rows
Instruction
1
When you minimize linesdisappear and the corresponding headers, consequently, anyone opening the Excel workbook it will be easy to guess that if after line 3 is line 5, then line 4 is hidden. Keep this in mind, making the data on the sheet.
2
To roll of the line, move the cursor to the column name strings in the left part of the window. Click with the left mouse button on the line which will start a selection. Holding it down, move the cursor to the line where the selection ends. Release the mouse button.
3
If the rows are not adjacent, press Ctrl and while holding it, select with the mouse the desired line. In this mode, do not use the mouse wheel to move through the sheet, as the Ctrl key is responsible for the page zoom. Use the scroll bar. If you still want to move around the worksheet using the mouse, hold at the time of the scroll hot key.
4
Select the desired range, click the right mouse button on the selection. In the context menu select "Hide" by clicking on it with the left mouse button. The selected rows will be collapsed. To perform this task, you can use the buttons on the standard toolbar.
5
Highlight the rowsthat need to be undeployed and click the Home tab. On the toolbar find the "Cell". Click on the "Format". In the drop-down menu, select the group the "Visibility" and "Hide or display". Unfold the submenu. Choose "Hide line".
6
To return the display collapsed rows, select two adjacent rows, between which hidden data and click on the selection with the right mouse button. In the context menu select "Display". Another option: do not select rowsand cells that meet the specified conditions. On the toolbar in menu "Format" select the "Display string" from the group "Hide or show".
Is the advice useful?
Search