The solution to the occurrence of pound sign in excel form

This article mainly introduces the solution to the occurrence of pound sign in excel table, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The table appears pound sign because the column width is not enough, the recovery method is: first open the table file, then select all the columns where the pound sign appears, and finally point to An and B or any other two columns to drag to the right.

Display # is usually due to insufficient column width, which can be solved by adjusting the column width, as shown in the figure:

Adjust column width solution: select all columns where the # sign appears-just drag to the right at the junction of An and B or any two other columns

After adjustment:

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the solution content of the pound sign in the excel form. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!