Microsoft KB Archive/64651

{| = Excel: Cannot Insert Column with Hidden Column Selected =
 * width="100%"|

Last reviewed: November 30, 1994

Article ID: Q64651

SUMMARY
In Microsoft Excel, if you select a column that has a width of zero (a &quot;hidden&quot; column) and choose Insert from the Edit menu, a new column will not be inserted.

If you select cell or group of cells within a hidden column and choose Insert from the Edit menu, the default option in the Insert dialog box is to Shift Cells Down. If you select Shift Cells Right, the command is ignored and a new column is not inserted.

In a macro, the INSERT command will be skipped if a hidden column is selected.

MORE INFORMATION
This does not occur when you select a hidden row or when you move cells down.

Note: This information also applies to Microsoft Excel for Windows and OS/2, versions 2.x and 3.0.
 * }