wps table can not insert columns for a variety of reasons. Generally when inserting columns, excel will prompt: "To prevent possible data loss, non-blank cells in the worksheet cannot be removed. Please press ctrl+end, locate the last non-blank cell, and then delete or clear everything in the cell between the cell after the cell and the end of the data."

Here are a few common symptoms and solutions for wps tables that can't insert columns and rows.

excel2003 rows can not be greater than 65536 rows, columns can not be greater than 256 columns, if there is data in 65536 rows or 256 columns, in front of the insertion of rows or columns that will cause overflow.

excel can not insert one of the columns:

Press ctrl + end to locate the last blank cell, the implementation of the Edit-Clear-All, check.

excel can not insert the columns of the second:

Find the entire row or column formatting of the region, remove the formatting, or only have data in the region to set the format, save and open the file.

excel can not insert columns of three:

Copy the data area (only the data area) to a new table, save and try. As for the reason, usually caused by unreasonable operation process.

Excel can not insert the fourth column:

Excel worksheet there is a merged cell, just insert the location of the column in the merged cell, cancel the merger and then insert the column.