Operate a small thing in Excel

xiaoxiao2021-03-05  49

Today help the MM next door to make a resume. She has a very much word in a cell, and the word is displayed, and this word will run to some of the cells next to it.

The result is that the word on the right side, the word is displayed, and the word is displayed in the left cell, so I call me to help her.

The first reaction is a merged unit, and the left and right cells are not good. But who knows that there is no form in her Excel, I can't add it in the toolbar. I don't know why this is. This is constant, I started to play a single element. The right side is displayed, and the left is displayed, is it special for the attribute of a cell. So, I compared the three cells of the left middle and found that it was exactly the same, and some attributes were changed, and it was still desperate. At this time, I keep the left and right keys in the left and right cells, actually this is a habit where I have no time. The miracle happened, I found the cells on the left, the cursor moved in this unit; in the cell, the cursor, the cursor runs to the cells. Ah! It turns out that there is a space character in the left cell! Excel discovers that there is a space character in the cells on the left, then prioritize the space; no characters in the right cell, then Excel transparent display exceeded the word! It's that simple!

Ha, a little thing, but reminds me of many times to adjust the experience, do you feel the same? ?

转载请注明原文地址:https://www.9cbs.com/read-36712.html

New Post(0)