When working with a program from Microsoft Office Excel, sometimes you need to hide some columns or rows. The reason for this may be an improvement in the readability of the document or just the desire to hide some calculations or data. In this regard, users of the software tool the question arises: "How to hide columns in Excel and how to return their visibility back?".
Ways to hide columns
To increase the convenience of working in Excel, the program contains functions that allow you to hide a certain range of cells. It does not matter if any information is stored in them or if they are empty. In order to achieve concealment of one or several columns, it is necessary to perform one of the following four action algorithms.
- , , - , . "".
- , "", , "".
- , . "", "", "". "", " ", " ".
- Excel , . , , : "Ctrl" + "0".
, , Excel, .
, Excel. - , , , , , " ". : "Ctrl" + "Shift" + "0".
?
, Excel , . , , Excel. " " " ", : "Ctrl" + "9" "Ctrl" + "Shift" + "9" .
, , Excel. "", " " " ", . , " ", . , , , .
By understanding how to hide rows and how to hide columns in Excel, you can greatly ease your work. The advantage of hidden cells is their lack of printing - thus, it is possible to exclude data that are redundant from paper output, without editing the document itself. Another advantage is the increased readability of data - in this case, by hiding unnecessary columns, you can place significant data next to each other.