Home  >  Article  >  Topics  >  How to hide text that is too long in excel

How to hide text that is too long in excel

尚
Original
2019-12-19 15:46:2151917browse

How to hide text that is too long in excel

How to hide text that is too long in excel:

1. Select the cell, right-click the mouse, and select "Format Cells"

2. Select "Align", horizontally align and select the "Fill" option

3. After completion, the text beyond the cell will be hidden. When the mouse double-clicks the cell, all text content will be displayed and occupy other cells. Cell position

4. If you want the content of the cell to be displayed according to the width of the cell, you can set automatic line wrapping.

5. Select the cells you want to adjust, right-click and select "Format Cells"

6. Select "Align" and check "Automatic Wrap"

7. Double-click the cell, and the text that exceeds the width of the cell can be automatically wrapped and fully displayed according to the width of the cell.

The above is the detailed content of How to hide text that is too long in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn