Protect a column from row inserts or deletes

[pmolsen]

Is it possible to make a column of a worksheet remain static even if I insert or delete rows please?

For example say column A contains the letters from A-Z in rows 1-26. If I delete row 3 then I want it to delete that row from columns B, C, D, E etc. but not from Column A, such that column A still has the letters from 1-26, and all the values in columns B, C, D... for rows 4 onwards have shifted up one row relative to column A.

Likewise if I insert a new row after row 3 then I want it to insert a new row in columns B, C, D... but not in column A.

To do it manually I have to do the following if I delete a row:
- Delete row 3
- Right click on the new cell A3 which has shifted up from A4 and now contains "D"
- Select Insert
- Change the radio button to select Shift cells down
- Re-enter the letter C in cell A3



A similar process if I insert a row.