What is the reason that Excel cannot insert columns
The way to insert a column is simple, right-click the column label, choose Insert from the pop-up menu, or use the plus sign on CTRL + KEYPAD to quickly insert the column.
But the file I met today, when I insert a column, pops up a warning dialog box like this, and there's no way to insert a column.
What's the reason? You can use Ctrl+end, this is the way Excel records your editing area, whether to end is according to your largest editing range to identify, you mouse to the place where Excel thinks you edited, ctrl+end you will find that your table has been positioned to the last column. That is, the last column has been edited, of course, can not add columns.
How to solve this problem, run once the following macro can be
Sub DD () MsgBox ActiveSheet.UsedRange.Address End Sub.
But there is no simpler way, in fact we can choose the last column. Selecting the Clear All command under the Edit menu also makes it easy to solve the problem