Home > Common Problem > body text

How to fix unable to add new rows/columns in Microsoft Excel

WBOY
Release: 2023-04-13 19:43:07
forward
5940 people have browsed it

Microsoft Excel is used for a variety of things such as calculations, creating models, etc. There are few operations that may require adding rows and columns. But some users face issues like not being able to create new rows or columns in excel. Stop here and read this article which explains different ways to solve this problem. let's start!

Method 1: Remove Cell Protection

Step 1: Open the Excel worksheet you are having problems with. Use the Ctrl A keys to select all cells from the spreadsheet.

Step 2: Click the Format option in the Home tab and select Format Cells. Select Format Cells

How to fix unable to add new rows/columns in Microsoft Excel

from the drop-down list. Step 3: Under the Protect tab, Cancel Check the box next to the Lock option.

How to fix unable to add new rows/columns in Microsoft Excel

Step 4: Click "OK" to save changes.

Step 5: Click the Review tab, then click Protect Sheet.

How to fix unable to add new rows/columns in Microsoft Excel

Step 6: Enter your password to remove protection from the workbook and save it together using the Ctrl S keys.

How to fix unable to add new rows/columns in Microsoft Excel

Step 7: Close Excel and open it again. Now you can add/insert new rows or columns.

Method 2: Unmerge cells

Step 1: Open the troublesome excel worksheet and check whether there are merged cells.

Step 2: If you have merged columns, select the column header and click the Merge and Center option on the Home tab.

How to fix unable to add new rows/columns in Microsoft Excel

Step 3: Repeat step 2 for each merged column.

Step 4: If there are merged rows, select that row and click Merge and Center## in the Home tab #options.

How to fix unable to add new rows/columns in Microsoft Excel

Step 5: Repeat step 4 for each merged row.

Step 5: Use the Ctrl S keys together to save the file.

Step 6:

Close Excel and open it again and check if the error is resolved.

Method 3: Unfreeze Panes

Step 1: Open the troublesome spreadsheet and click the "

View" tab and select "Freeze Window Panes"

Step 2: Select

Unfreeze panes from the drop-down list and use the Ctrl S key to save the file

How to fix unable to add new rows/columns in Microsoft Excel

Step 3: Close and reopen the excel file. Now check if you can add rows/columns.

Method 4: Trusted file source

Step one: Open the troublesome Excel file and click the

File tab in the upper left corner.

How to fix unable to add new rows/columns in Microsoft Excel

Step 2: Then click on

Options and select Trust Center from the window that appears.

Step 3: Click the

Trusted Center Settings option in the right pane.

How to fix unable to add new rows/columns in Microsoft Excel

Step 4: Select

Trusted Locations from the left. Click the Add New Location option.

How to fix unable to add new rows/columns in Microsoft Excel

#Step 5: Browse for the location of your excel file in the window that appears.

Step 6: Click OK

Step 7: Close the excel file and open it again. Now add new rows/columns.

Method 5: Clear Unused Rows/Columns

Step 1: Open an Excel spreadsheet and use the Shift Ctrl key and the right arrow key to select all unused columns until there is data Columns do not include data columns.

How to fix unable to add new rows/columns in Microsoft Excel

Step 2: If you are doing this method on rows, use the Shift Ctrl key and the up/down arrow keys to select all unused rows until the data row is included rows of data outside.

Step 3: In the "Home" tab, click the "

Border" drop-down menu and a list will appear. Select Borderless from the list

How to fix unable to add new rows/columns in Microsoft Excel

Step 4: Click the Theme colors drop-down menu and select No fill.

How to fix unable to add new rows/columns in Microsoft Excel

Step 5: Press the Delete key on your keyboard to delete the incorrectly entered data on the unused columns.

Step 6: You can go to the Edit section in the Home tab.

How to fix unable to add new rows/columns in Microsoft Excel

Step 7: Click the Clear option and select Clear Format

How to fix unable to add new rows/columns in Microsoft Excel

Step 8: Click Clear again and select Clear All.

How to fix unable to add new rows/columns in Microsoft Excel

Step 9: Use the Ctrl S key to save changes. Close the Excel sheet and open it again and check if the problem is resolved.

Method 6: Using How to fix unable to add new rows/columns in Microsoft Excel (Visual Basic for Applications)

Step 1: Open the Excel sheet where you are facing the problem, right click on the worksheet.

Step 2: Click to view Code options.

How to fix unable to add new rows/columns in Microsoft Excel

Step 3: Click Ctrl G to display the Instant window.

Step 4: Enter ActiveSheet.UsedRange and press the Enter key.

How to fix unable to add new rows/columns in Microsoft Excel

Step 5: Select the File tab from the top and click Close and Return to Microsoft Excel

How to fix unable to add new rows/columns in Microsoft Excel

Step 6: Save the file. Close the excel file and reopen it. Now check if you can add rows/columns.

The above is the detailed content of How to fix unable to add new rows/columns in Microsoft Excel. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:yundongfang.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template