Excel cells have black boxes by default. Sometimes the black boxes need to be removed. The specific steps are as follows: 1、 Tool used: excel 2010 2、 Operation steps: 1. Enter excel 2010, open the document, and the cell is framed by default, as shown in the figure:
2. Switch to the view tab and remove the check in front of "grid line", as shown in the figure:
3. The black box in the table is removed, as shown in the figure:
In an Excel table column, there are both serial numbers and item names. The method to remove the serial number is as follows: 1. Save the file as a txt file
2. Open EXCEL system, click to open TXT format file
3. Select Separator
4. Select Other, enter the corresponding symbol, and click Finish
5. You can divide the serial number and item into two columns, as shown in the figure below. You can delete the serial number by deleting it
