Inset Columns to the right of my active cell

[FilleFrella44]

Hello,

I'm currently having an issue with inserting columns to the right of my active cell. When I click insert I only get the option to shift the cells to the right, but not to the left.

I wonder if there is any way to insert columns to the right of the active cell like the functionallity shown in the customize ribbon bu for Table.

Regards,
FilleFrella

 

[Legacy 143009]

Simply, Excel can't add columns in backwards. Nither to left, nor top. It cannot create -B column before A
Also, it can not drag column A out of view like it does for XFD column.
Surprisingly it can not push XFD column out of the sheet if it contains any value.
In other words, Excel also won't allow you to add cells to the right if you have data at the very last column or push cells down if you have data at the very bottom.

 

[Alex Blakenburg]

I'm currently having an issue with inserting columns to the right of my active cell. When I click insert I only get the option to shift the cells to the right, but not to the left.

I wonder if there is any way to insert columns to the right of the active cell like the functionallity shown in the customize ribbon bu for Table.

I suspect that the functionality shown in the customize ribbon is not what you think it is.
When you are in a table the option to insert a column to the right only comes up if you are in the last column of the table.
The option on the customize ribbon is only slightly different to that in that it allows you to be in any cell in the table when you access the command BUT it still will only insert a column after the last column that exists in the table (expanding the table), not to the immediate right of the active cell.

 

[FilleFrella44]

Hi and thanks for the quick replies. Not quite sure what I'll do here, should I mark the thread as "solved" since there seems to be no way of solving it? Perhaps this could be done with VBA instead, creating a column in +1 relative position to the active column/cell, or create it the "normal" way with ALT+H+I+I then moving that new column to the right of original one?

 

[Legacy 143009]

Yes, that is what I was also thinking of.

 

[Alex Blakenburg]

You obviously have some specific in mind that you are trying to do.
Most people would simply move the cursor 1 cell to the right before inserting the column where they want it.

Once you move the cursor to the right then for a worksheet column
• Ctrl+Shift (selects the column)
• Ctrl+<+> (Ctrl+Plus - Inserts column)

For a Table only column insertion
• Ctrl+Shift (selects column data range)
• Ctrl+Shift a second time (selects table column) - Basically keep holding the Ctrl key down and hit the spacebar twice.
• Ctrl+<+> (Ctrl+Plus - Inserts column)
(You can obviously also use the mouse to select the column)

Much more direct than moving the column after the insertion.