Microsoft Excel is a spreadsheet program. It is convenient to make calculations, process a large amount of data, analyze available information and perform many other actions in it.
Necessary
Computer with Microsoft Excel
Instructions
Step 1
Hiding Rows is a special Excel feature that allows you to hide some data from view. This makes it much easier to work with a large table without getting confused by unnecessary information. In addition, by removing some lines, you can print only the necessary ones without redoing the entire table.
Step 2
When you are finished working with the table, display the rows hidden during the work. To do this, select the adjacent lines (one at a time), click on the designated area with the right mouse button and select "Show" from the menu that appears. The hidden information will return to its original position.
Step 3
You can restore hidden lines in another way. Select similarly closely spaced lines, click on the "Format" tab on the toolbar, move the mouse cursor over the item "Hide or show" and select "Show lines" from the context menu that appears. After that, the removed stitches will appear.
Step 4
If there are hidden lines all over the table, do not torment yourself looking for missing numbers. Just select the entire table, right-click on it and select "Display" from the menu that appears.
Step 5
To find out where the hidden information is, look carefully at the line numbers in the table. In the place where they go astray and start to go out of order, there are hidden lines. And the dividing line between such numbers is thicker than the others.
Step 6
Similar actions apply to hidden columns. Only for their display it is necessary to select two adjacent columns. And you can find out the place of hidden information by letters that are not in alphabetical order.
Step 7
Use this feature when working with a large amount of data, plotting graphs from a portion of a table. And also when you need to remove any information from prying eyes.
