Types of data hiding in Excel - Part 2: How to hide cells, overflow text
In life and work, there are always secrets that we want to keep a secret, want it to be hidden, and so is in Excel. To continue part 1:
TipsMake will show you how to hide cell (cell) and overflow text (text overflow cell) in this part 2.
1. Hide cells
Basically, Excel cannot 'hide' a cell or a cell base in the same way as comments, rows and columns are hidden.It means you will make it disappear until you make it appear again. Excel can only obscure cells with spaces like the example below, because if you 'hide' it as rows and columns, what will those cells be replaced with?
To help you understand TipsMake better will give an example you want to hide two cells I5 and I12 in which the words 'largest', 'smallest' as in the picture below, you need to follow these steps:
Types of data hiding in Excel - Part 2: How to hide cells, overflow text Picture 1
- Step 1: You press and hold Ctrl and then left click on the two cells I5 and I12 . Continue to press ' Ctrl + 1 ' to enter Format Cells.
- Step 2: At the ' Number ' tab, select the ' Custom ' section at the bottom. Then enter the three-character ' Type ' text box ;;; '(without the quotation marks'') as shown in the picture, then press' OK ':
Types of data hiding in Excel - Part 2: How to hide cells, overflow text Picture 2
And this is the result:
Types of data hiding in Excel - Part 2: How to hide cells, overflow text Picture 3
==> As you can see above, the data in cells I5 and I12 have been replaced by spaces, but it still appears in the Formular Bar when you click to select. To display the same, simply go back to Format Cells and select its original format ( Number, Text, Date and Time, .).
==> Note : If you do not select the original format for the hidden cells, no matter how you replace the data in that cell, the cell is still displayed as a space .
2. Hide overflow text (overflow text)
In Excel, when you enter too many words into a cell, those extra words will overflow to the adjacent cells , this is called ' Overflow Text '. For example, in the screenshot below, the text in cell A1 is flooded with adjacent cells:
Types of data hiding in Excel - Part 2: How to hide cells, overflow text Picture 4
This is the default of Excel and sometimes will make you feel a bit inconvenient, but you can completely change this by:
- Step 1 : Select the cell to be changed, right-click and select ' Formart Cells '
- Step 2 : In Format Cells , select the ' Alignment ' tab, then select ' Fill ' in the ' Horizontal ' section as shown below, then press ' OK ' to finish.
Types of data hiding in Excel - Part 2: How to hide cells, overflow text Picture 5
==> And here is the result:
Types of data hiding in Excel - Part 2: How to hide cells, overflow text Picture 6
Part 2: How to hide cells, overflow text in the series 'Instructions on all types of hidden data in Excel extremely useful' here is over. If you find this article useful for the community, don't be afraid to share it via facebook! TipsMake wish you success and see you in the following sections, promising many interesting things.
You should read it
- How to hide and hide sheets in Excel and show them again
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- Hide the contents of any Cell in Excel
- Ways to hide data on Excel
- Types of data hiding in Excel - Part end: Hide Excel Files
- Instructions to delete 0, hide 0 in Excel
- Hide value 0 in Excel
- How to hide formulas in Excel
- Instructions on all types of data hiding in Excel are extremely useful
- Instructions for using Hide My Ass to hide IP
- Hide / show the Formula Bar in Excel
- How to hide and show Sheet in Excel
May be interested
Types of data hiding in Excel - Hide pictures, graphs, rows, columns
Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
Types of data hiding in Excel - Part end: Hide Excel Files
How to convert Powerpoint files to PDF, Word
How to Create a signature for Gmail and insert photos, links, Anchor Text into Gmail signatures
How to create drop down list to select in excel