Option to insert cut (or copied) cells is among the things that can be turned on and off in advanced options. Click the File tab, and then click Excel Options. Click the Advanced tab. Click to clear/unclear the Show Insert Options buttons check box in the Cut, copy, and paste section, and then click OK.

how do you shift cells up in Excel? Move or copy rows or columns Drag the rows or columns to another location. Hold down OPTION and drag the rows or columns to another location. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.

Correspondingly, how do I cut cells in Excel?

Select the cell(s) you want to cut. Click the Cut command on the Home tab, or press Ctrl X on your keyboard. Select the cells where you want to paste the content. The cut cells will now have a dashed box around them.

Why cant I insert cells in Excel?

Microsoft Excel cant insert new cells because it would push non-empty cells off the end of the worksheet. These cells might appear empty but have blank values, some formatting, or a formula. Delete enough rows or columns to make room for what you want to insert and then try again.