MICROSOFT EXCEL CANT INSERT NEW CELLS HOW TO

If you clear all the contents and formatting of the columns outside of your dataset, the last column of your dataset will be totally blank and you will be able to insert a new column. Clear All the Columns Outside of the Dataset Now, I will show what you can do to solve the problem when you cannot Insert a column in Excel.ġ. What to Do When You Cannot Insert Column in Excel? Read More: Excel Fix: Insert Column Option Greyed out (9 Solutions) That means you cannot insert a column in this protected worksheet. You will see the Insert option is greyed out. Now, if you uncheck the box Insert columns and click on OK, you won’t be able to insert a new column in the sheet. ➤ Right-click on the sheet name and click on Protect Sheet.Ī new window named Protect Sheet will appear. If you turn on Protection for your worksheet, you won’t be able to insert a column in the protected sheet. Cannot Insert Column for Sheet Protection

MICROSOFT EXCEL CANT INSERT NEW CELLS HOW TO

I’ll show you how to find out if your datasheet has conditional formatting for the entire sheet and how to remove it when I will discuss the solutions. If you accidentally apply conditional formatting for the entire worksheet instead of the cells of your dataset, you won’t be able to insert a new column in this worksheet. Conditional Formatting to the Entire Sheet If you have panes in your worksheet, you won’t be able to insert a new column.ĥ. Read More: Combine Texts from Two Columns in Excel (6 Easy Tips)Ĥ.

Now, if you try to insert a new column, the error box will appear implying that you cannot insert a new column in this datasheet. ➤ Go to the Home tab and click on Merge and Center in the Alignment ribbon. ➤ Select all the cells of row 3 by clicking on the row number. Let’s merge all the cells of the 3rd row of the following datasheet and see what happens. If you merge all the cells of a column in your datasheet, you cannot insert a new column in the datasheet. Now, if you try to insert a new column an error message box will appear and you won’t be able to insert the new column.ģ. ➤ Go to Home > Borders and click on Outside Borders to add borders outside of your entire datasheet. ➤ Select the Entire sheet by clicking on the top left corner of your worksheet where the row number intersects with the column number. If you add outside or all borders by selecting the entire sheet you won’t be able to insert a new column in this sheet. Outside or All Borders to the Entire Sheet You cannot also shift non-blank cells in this case, you can know about that from this article.Ģ. So, when you have a non-blank last column you cannot insert a new column in your dataset. Delete enough rows or columns to make room for what you want to insert and then try again”. These non-empty cells might appear empty but have blank values, some formatting, or a formula. Now, if you try to insert a new column an Error message box will appear saying, “Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet. Suppose, you have the following text in the last column of your Excel worksheet shown in the image. If you have any content in the last column of your Excel worksheet, then you cannot insert a column in this worksheet. When You Cannot Insert Column in Excel? 1.

Microsoft excel cant insert new cells