How to Fix Move Excel Column Error

Introduction

If you are having trouble moving columns in Excel, you are not alone. Many users have encountered this issue and have been unable to find a solution. Fortunately, there are a few simple steps you can take to fix the move column error in Excel. In this article, we will discuss how to troubleshoot and fix the move column error in Excel. We will also provide some tips on how to prevent this error from occurring in the future. By following these steps, you should be able to quickly and easily fix the move column error in Excel.

How to Fix Move Excel Column Error

1. Check the column width: If the column width is too narrow, the data may not fit in the column and cause an error. To fix this, select the column and adjust the width to fit the data.

2. Check the data type: If the data type of the column is not compatible with the data, it may cause an error. To fix this, select the column and change the data type to the appropriate type.

3. Check the formula: If the formula in the column is incorrect, it may cause an error. To fix this, select the column and check the formula for any errors.

4. Check the cell references: If the cell references in the formula are incorrect, it may cause an error. To fix this, select the column and check the cell references for any errors.

5. Check the data: If the data in the column is incorrect, it may cause an error. To fix this, select the column and check the data for any errors.

How to Fix Move Excel Column Error

Microsoft Excel is one of the most used spreadsheet software in the world. This spreadsheet software provides users tools to write and interpret data accurately. However, users may stumble while working on an Excel workbook. Often, users may find scratching their heads to understand ways to resolve how do you move cells in table on a worksheet, or excel can’t insert new cells errors. Move excel column errors can usually be fixed by using various Excel tools and settings as discussed in this guide.

How to Fix Move Excel Column Error

How to Fix Move Excel Column Error

There can be various reasons for move Excel column issues to appear such as:

  • Pre-existing formatting in the cells of the Excel workbook
  • Graphics in the workbook, including hyperlinks
  • Improper selection of Excel options
  • Incorrect settings in the Comment Property

The upcoming sections will provide you with methods to fix excel can’t insert new cells issues.

Method 1: Clear All Extra Rows and Columns

You may receive this error if one formula has been applied to the entire worksheet. Hence, one of the first methods you can try to fix this issue is to clear all first rows and columns as follows:

1. Click the heading cell on your worksheet.

2. Press Ctrl + Shift and then press the right arrow key to select the entire row as shown.

Press Ctrl + Shift and then press the right arrow key to select the entire row. excel can't insert new cells

3. From the Home tab, click on the Clear option shown highlighted below.

Navigate to the Editing menu in the Home tab and click on the Clear option. excel can't insert new cells

4. Click on Clear All to remove the entire row.

Click on Clear All to remove the entire row. How to Fix Move Excel Column Error

5. Following the instructions in step 2, select all rows right below your data and clear these as well.

Press Ctrl + Shift and then press the down arrow key, to select all the rows.

This method should remove all the formatting and formula in the entire sheet; you should not receive an error while adding new rows and columns. If the problem continues, try the next method.

Also Read: How to Freeze Rows and Columns in Excel

Method 2: Remove Hyperlinks From All Graphics

If you have pictures and other graphics in your worksheet, you can try to resolve the move excel column error by simply removing the hyperlinks from the graphics. You can follow these simple steps to remove the hyperlinks from your worksheet:

1. Right-click on the picture that you have inserted in the worksheet.

2. Navigate and click on the Remove Link option as shown.

Excel right click picture select Link option to remove hyperlink

3. Save the Excel worksheet by pressing Ctrl + S keys together and close the window.

4. Relaunch Excel and continue the project. Right-click on pic and select Link option to add hyperlink again.

Excel right click picture select Link option to attach remove hyperlink

Method 3: Modify Advanced Excel Options

If  you are still confused about how do you move cells in table on a worksheet, you may want to change the Excel Options manually and safely as follows:

1. Click on the Office Button at the top-right corner.

Click on the Office Button at the window's top-right corner. How to Fix Move Excel Column Error

2. Now locate and click on the Excel Options as shown.

Now locate and click on the Excel Options at the bottom-left corner of the window.

3. From the left-side menu, click on the Advanced option.

From the left-side menu, click on the Advanced option.

4. Scroll down and locate Display options for this workbook menu.

Scroll down and locate Display options for this workbook menu. how do you move cells in table on a worksheet

5. Under For objects, show: option, select All as illustrated below.

Under For objects, show: options select All. How to Fix Move Excel Column Error

6. Finally, click OK.

Click OK How to Fix Move Excel Column Error

Also Read: How to Copy and Paste Values Without formulas in Excel

If the previous methods do not fix the Excel column error, you can also try to resolve excel can’t insert new cells error by changing the comment property of the workbook by using the Selection Pane. You can follow these simple steps to use the Selection Pane tool:

1. In the Excel window, from Home tab, click on Find & Select drop-down.

Navigate and click on Find & Select drop-down. how do you move cells in table on a worksheet

2. Click on Selection Pane

Click on Selection Pane. How to Fix Move Excel Column Error

3. Lastly, click on Show All button to show all the comments in your workbook and resolve these.

You can use Macro code to see all the comments on your workbook as well. A Macro adds a new sheet to the workbook, with the list of comments showing the cell address and the position settings.

You can simply copy and paste the following Macro code:

Sub AllCommentsListProperties()

Application.ScreenUpdating = False

Dim rngCmts As Range

Dim c As Range

Dim wsA As Worksheet

Dim wsN As Worksheet

Dim i As Long

Dim lPos As Long

Dim myPos As String

Set wsA = ActiveSheet

On Error Resume Next

Set rngCmts = wsA.Cells _

.SpecialCells(xlCellTypeComments)

On Error GoTo 0

If rngCmts Is Nothing Then

MsgBox "no comments found"

Exit Sub

End If

Set wsN = Worksheets.Add

wsN.Range("A1:B1").Value = _

Array("Address", "Position")

i = 1

For Each c In rngCmts

With wsN

i = i + 1

On Error Resume Next

lPos = c.Comment.Shape.Placement

Select Case lPos

Case 1

myPos = "Move/Size"

Case 2

myPos = "Move Only"

Case 3

myPos = "No Move/Size"

End Select

.Cells(i, 1).Value = c.Address

.Cells(i, 2).Value = myPos

End With

Next cws 

N.Range("A1:B1").EntireColumn.AutoFit

Application.ScreenUpdating = True

End Sub

Also Read: Fix Microsoft Office Not Opening on Windows 10

If you are still figuring out how do you move cells in table on a worksheet, you can also try manually changing the Comment Property by following the steps below.

1. Right-click on any cell in the Excel workbook.

2. Click on the Show/Hide Comments option shown highlighted below.

Click on the Show/hide comments.

3. Navigate the cursor to the corner of the comment. Right-click and choose Format Comment… option as illustrated below.

Click the Format comment option. how do you move cells in table on a worksheet

4. Navigate to the Properties tab.

Navigate to the Properties tab. How to Fix Move Excel Column Error

5. Select Move but don’t size with cells option and click OK.

Select, Move and size with cells or Move but don't size with cells. How to Fix Move Excel Column Error

Frequently Asked Questions (FAQs)

Q1. Why do I get errors while using Excel?

Ans. There can be various reasons for errors to occur with Microsoft Excel. Some reasons include pre-existing formulae and formatting of the values in the workbook and graphics, if any.

Q2. How can I fix Excel errors?

Ans. There are many ways to fix Excel errors primarily by clearing all formatting of Excel workbook.

Q3. How to change comment options in Excel?

Ans. You can change comment options by going to Show/hide comments options by right-clicking on a cell.

Recommended:

How to Fix Move Excel Column Error

If you are trying to move a column in Microsoft Excel and you get an error message, it can be frustrating. Fortunately, there are a few steps you can take to fix the issue and get your spreadsheet back up and running.

Step 1: Check the Column Width

The first thing you should do is check the width of the column you are trying to move. If the column is too wide, it may be causing the error. To check the width, right-click on the column header and select “Column Width” from the menu. If the width is greater than 255 characters, you will need to reduce it before you can move the column.

Step 2: Check for Hidden Columns

Another possible cause of the error is hidden columns. If there are any hidden columns between the column you are trying to move and the column you are moving it to, the move will not work. To check for hidden columns, select the entire sheet by clicking the triangle in the upper left corner of the sheet. Then, right-click and select “Unhide” from the menu. If any columns are hidden, they will be displayed.

Step 3: Check for Merged Cells

The last possible cause of the error is merged cells. If there are any merged cells between the column you are trying to move and the column you are moving it to, the move will not work. To check for merged cells, select the entire sheet by clicking the triangle in the upper left corner of the sheet. Then, right-click and select “Unmerge Cells” from the menu. If any cells are merged, they will be unmerged.

Step 4: Try Moving the Column Again

Once you have checked the column width, hidden columns, and merged cells, you should be able to move the column without any errors. To move the column, select the column header and drag it to the desired location. If the move is successful, the column will be moved and the error message will no longer appear.

Conclusion

Moving a column in Microsoft Excel can be tricky, but with a few simple steps, you can fix the error and get your spreadsheet back up and running. Check the column width, hidden columns, and merged cells, and then try moving the column again. With a bit of patience, you should be able to move the column without any issues.

Jaspreet Singh Ghuman

Jaspreet Singh Ghuman

Jassweb.com/

Passionate Professional Blogger, Freelancer, WordPress Enthusiast, Digital Marketer, Web Developer, Server Operator, Networking Expert. Empowering online presence with diverse skills.

jassweb logo

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet, and extranet products.

Contact
San Vito Al Tagliamento 33078
Pordenone Italy
Item added to cart.
0 items - 0.00
Open chat
Scan the code
Hello 👋
Can we help you?