Microsoft Excel 2013's Home tab includes options in the Cells group to insert a blank sheet column and to delete unwanted sheet columns. The row of alphabetical column headings stay in the same ...

Click the "Home" tab again, navigate to the "Cells" section, and click "Delete Sheet Rows" from the drop-down menu. You can repeat a similar process to remove blank columns from your spreadsheet.

Delete enough rows or columns to make room for what you want to insert and then try again. Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet ...

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.