Microsoft Excel is designed specifically for data processing. With its help, you can carry out statistical analysis, solve problems, build graphs and diagrams. And for the convenience of working with large tables, there is also a special function that allows you to hide certain rows or columns.
Instructions
Step 1
Open a Microsoft Excel document with a spreadsheet that needs to hide some of the rows. Or create such a table by opening a new workbook in the program.
Step 2
Highlight these lines. Left-click on the first of them and, without releasing the button, drag the selection to the last line. For example, it can be the first three lines out of ten.
Step 3
Then right-click on the selected area and select the "Hide" tab in the context menu that opens. After these actions, the selected lines will be hidden, and the table will start from the fourth line.
Step 4
You can hide the lines in another way. Select the ones you need, go to the "Format" tab in the main menu and move the cursor over the inscription "Hide or show". In the context menu that appears, select Hide Rows.
Step 5
You can notice the place with hidden lines by their numbers, which are now out of order. The first three digits are replaced by the number "4".
Step 6
To bring back hidden lines, select the lines adjacent to them in the same way. In this case, it will be one - fourth. Right-click on it and select "Display" from the menu. The lines will appear again.
Step 7
Likewise, in Microsoft Excel, you can hide not only rows, but also columns. The letters at the top, which are the names of the columns, will help you to notice hidden columns. Once hidden, they will not be in alphabetical order.
Step 8
If there are many hidden rows and they are located in different places in the table, you can display them all at once. To do this, select the table completely, open the context menu and select "Show".
Step 9
Thanks to such actions in Microsoft Excel, it is possible not only to greatly facilitate the work of processing data in large tables, but also to print not the entire table, but certain information. Hidden places just won't get printed.
