123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

How To Fix “cannot Add New Cells In Excel” Issue On Excel?

Profile Picture
By Author: Veronica Medlin
Total Articles: 319
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Source : https://zmsoffice.com/how-to-fix-cannot-add-new-cells-in-excel-issue-on-excel/

Delete Cell Protection

Follow the steps given below:

Hold the ‘Ctrl + A’ keys to choose all the cells.
After that, select the drop-down of Format.
Then choose the Format Cells beneath the Protection on the lower side of the menu.
Once you launch the screen, select the Protection section, and untick the Locked option.
Select the OK button.
Navigate to the Review section and select the Protect Sheet or Protect Workbook.
Input the password to clear protection through the workbook or sheet.
Now, hold the ‘Ctrl + S’ keys altogether over the keyboard to store the file.
Close the screen and then launch it once more.

file ...<br />
<script async src= ... then check" src="https://1.bp.blogspot.com/-wqd_tNyqM18/XwwPTfVj8aI/AAAAAAAABFE/CZuoM_Xi-IwAFEjMxYEZ7Bks3C2h1bGVgCLcBGAsYHQ/s640/How%2Bto%2BFix%2B%25E2%2580%259CCannot%2BAdd%2BNew%2BCells%2Bin%2BExcel%25E2%2580%259D%2BIssue%2Bon%2BExcel.jpg" width="500px" />

Unfreeze the Frozen Panes

Here are the steps you need to follow:

Navigate to the View section.
After that, select the drop-down of Freeze Panes.
You should click on the Unfreeze Panes through the menu.
Then store the file by holding the ‘Ctrl + S’ button over the keyboard.
Now, relaunch the file then check whether the issue has been solved.

Copy the Data to a Fresh Sheet

Follow the steps mentioned below:

Launch the problematic sheet.
After that, select all data by holding the ‘Ctrl + A.’
You should select the File section.
Then choose the New option and choose ‘Blank Workbook.’
Select the Create option.
Choose the drop-down of Paste into the Home section.
Select the ‘Paste Special’ option.
You have to choose the ‘Values’ option then select the OK button.
Now, store the fresh file and shut it.
Relaunch the file then check if the issue you are troubling has been fixed.

Select a Shorter File Path

Follow the steps mentioned below:

Launch the problematic file.
After that, select the File section and choose the ‘Save as’ option.
Once launch the section, choose the Desktop as the place for the file to be stored then select the button of Save.
Later, shut the workbook.
Now launch the freshly stored file.

Use Office Online

Here are the steps you need to follow:

Navigate to the browser and sign in to the One Drive.
Then choose the button of Upload.
Go to the Files option.
Reach the location wherever the doubtful file of Excel is saved.
Click on the file.
Select the Open option.
Later, attempt adding new columns or rows to the sheet.
In case successful, you should then download the file to the PC.

Cynthia Strickland is a creative person who has been writing blogs and articles about cybersecurity. She writes about the latest updates regarding office.com/setup and how it can improve the work experience of users. Her articles have been published in many popular e-magazines, blogs, and websites.

More About the Author

About Me: Hii I am Angel Smith. my residential spot “North Carolina” United State.I like to mostly write content related to technology-based and including trending news content in the technical field. This is a better site for all technology lovers.

Total Views: 400Word Count: 1810See All articles From Author

Add Comment

Computers Articles

1. Retaining Success: Crm In Student Retention
Author: Dinesh

2. Web-based Erp Software Caters To A Wide Range Of Institutions

3. Elegant Muslim Nikah Invitation Card Designs For Your Special Day
Author: crafty art

4. What Does Collate Mean When Printing? (how To Do It?)
Author: kevin

5. Windows 11 Home Or Pro: Which Version Fits Your Needs?
Author: CheapkeysIO

6. One Stop Solution For Best Online Petrol Pump Software
Author: sidharthh08877

7. What’s In A Software Development Team?
Author: goodcoders

8. What’s Up With Spotify Wrapped?
Author: goodcoders

9. When Is The Best Time To Source On-demand Developers?
Author: goodcoders

10. Why You Should Use Pinterest For Your Business?
Author: goodcoders

11. Why Your Business Needs An Agile Software Development Team?
Author: goodcoders

12. Why Your Growing Business Needs Enterprise Applications?
Author: goodcoders

13. A Guide To Computer Safety & Repair Services By Mr Geeks
Author: Mr Geeks

14. Why Is Software Maintenance Important?
Author: goodcoders

15. Why To Choose Java Outsourcing Development For Your Project?
Author: goodcoders

Login To Account
Login Email:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: