Excel will insert new columns to the left of the selected columns. The keyboard shortcut for this task is also Ctrl + Shift + +. This works with multiple rows but not non-contiguous selections.

Excel doesn’t save hidden rows or columns or groups with a sheet view. However, if you save a grouping, the ability to collapse and expand will be immediately available to other collaborators.