{"id":24662,"date":"2021-07-07T23:09:20","date_gmt":"2021-07-07T21:09:20","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24662"},"modified":"2024-04-12T22:40:44","modified_gmt":"2024-04-12T20:40:44","slug":"how-to-edit-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-edit-cells-in-excel\/","title":{"rendered":"How to edit cells in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/32.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24783\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/32.png\" alt=\"How to edit cells in Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/32.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/32-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/32-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>If you are unable to edit data entered in your Excel worksheet and you are not sure how to fix it, you have come to the right place. There are <strong>several ways in which you can easily enable editing<\/strong> cells and learn how to edit cells in Excel.<\/p>\n<ul>\n<li><a href=\"#lesson1\"><strong>Excel file is read-only<\/strong><\/a><\/li>\n<li><a href=\"#lesson2\"><strong>Excel worksheet is locked<\/strong><\/a><\/li>\n<li><a href=\"#lesson3\"><strong>Editing in cell disabled in Excel<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at each one of these methods!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><strong><a id=\"lesson1\"><\/a>Excel file is read-only<\/strong><\/span><\/h3>\n<p>You may <strong>not be able to edit any cell<\/strong> in Excel because the<strong> Excel worksheet has been saved as read-only<\/strong>. This will force Excel <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-to-excel-split-screen-for-optimized-viewing\/\" target=\"_blank\" rel=\"noopener\">to keep the worksheet in<\/a><strong> view mode and you can make no changes<\/strong> in the file.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24712\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16.png\" alt=\"How to edit cells in Excel\" width=\"922\" height=\"239\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16.png 922w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-300x78.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-768x199.png 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/a><\/p>\n<p>To fix this, simply <strong>press the Enable Editing <\/strong>button on the top of the Excel worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone wp-image-24714 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-Copy.png\" alt=\"How to edit cells in Excel\" width=\"922\" height=\"239\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-Copy.png 922w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-Copy-300x78.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print16-Copy-768x199.png 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/a><\/p>\n<p>On you press that button, you can easily edit any cell in Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24713\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print18.png\" alt=\"How to edit cells in Excel\" width=\"958\" height=\"427\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print18.png 958w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print18-300x134.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Print18-768x342.png 768w\" sizes=\"(max-width: 958px) 100vw, 958px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><strong><a id=\"lesson2\"><\/a>Excel worksheet is locked<\/strong><\/span><\/h3>\n<p>Another reason why you may not be able to edit cells is that your <strong>Excel worksheet has been locked<\/strong>. You have to <strong>unprotect your worksheet first<\/strong> and then you can make changes in your file.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24715\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit1.png\" alt=\"How to edit cells in Excel\" width=\"1197\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit1.png 1197w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit1-300x114.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit1-1024x388.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit1-768x291.png 768w\" sizes=\"(max-width: 1197px) 100vw, 1197px\" \/><\/a><\/p>\n<p>To make changes in Excel, follow the steps below:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong> <\/span>Go to the <strong>Review<\/strong> tab<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24716\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit2.png\" alt=\"How to edit cells in Excel\" width=\"1014\" height=\"130\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit2.png 1014w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit2-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit2-768x98.png 768w\" sizes=\"(max-width: 1014px) 100vw, 1014px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966\">STEP 2: <\/span><\/strong>Click on <strong>Unprotect Sheet<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24717\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit3.png\" alt=\"How to edit cells in Excel\" width=\"1014\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit3.png 1014w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit3-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit3-768x97.png 768w\" sizes=\"(max-width: 1014px) 100vw, 1014px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966\">STEP 3: <\/span>Enter the password<\/strong> in the unprotect sheet dialog box and click <strong>OK<\/strong>.<\/p>\n<p><em>The password for this worksheet is &#8220;myexcelonline&#8221;.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24718\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit4.png\" alt=\"How to edit cells in Excel\" width=\"816\" height=\"334\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit4.png 816w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit4-300x123.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit4-768x314.png 768w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/a><\/p>\n<p>This will unprotect the sheet and you will be able to make the edits you want.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24719\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit5.png\" alt=\"How to edit cells in Excel\" width=\"480\" height=\"376\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit5.png 480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit5-300x235.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/a><\/p>\n<p>Can&#8217;t remember the password that you had used to lock your Excel file? <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unprotect-active-worksheet-using-macros-in-excel\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to learn how to unprotect active worksheets using macros in Excel.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><strong><a id=\"lesson3\"><\/a>Editing in cell disabled in Excel<\/strong><\/span><\/h3>\n<p>You might <strong>not be able to directly edit the contents<\/strong> of a cell by pressing the <strong>F2<\/strong> key.<\/p>\n<p>This might be because it has been<strong> disabled in Excel. <\/strong>You can easily enable or disable this function by following the steps below:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong> <\/span>Click on the <strong>File tab<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23782\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384.png\" alt=\"\" width=\"864\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384.png 864w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384-300x45.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384-768x115.png 768w\" sizes=\"(max-width: 864px) 100vw, 864px\" title=\"\"><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong> <\/span>Click <strong>Options<\/strong> from the menu on the left side<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23783\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385.png\" alt=\"\" width=\"723\" height=\"729\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385.png 723w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385-298x300.png 298w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385-150x150.png 150w\" sizes=\"(max-width: 723px) 100vw, 723px\" title=\"\"><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong> <\/span>In the dialog box, click on <strong>Advanced<\/strong> from the left panel<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\" class=\"alignnone size-full wp-image-23784\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"821\" height=\"677\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386.png 821w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386-300x247.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386-768x633.png 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" \/><\/a><\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong> <\/span>Under Editing option, check <b>Allow editing directly in cells. <\/b>Click <b>OK<\/b> at the bottom.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-39.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\" class=\"alignnone size-full wp-image-23795\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-39.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"823\" height=\"685\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-39.png 823w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-39-300x250.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-39-768x639.png 768w\" sizes=\"(max-width: 823px) 100vw, 823px\" \/><\/a><\/p>\n<p>That&#8217;s it! Now you can enable the editing cell feature in Excel. To disable Edit mode, clear the\u00a0<b class=\"ocpUI\">Allow editing directly in cells<\/b> check box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to edit cells in Excel\" class=\"alignnone size-full wp-image-24720\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit6.png\" alt=\"How to edit cells in Excel\" width=\"825\" height=\"681\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit6.png 825w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit6-300x248.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/Edit6-768x634.png 768w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\">Conclusion<\/span><\/h3>\n<p>If you are unable to make edits in your Excel worksheet, you can either use the enable edit button, or unprotect your worksheet or change the setting to Allow editing directly in cells,<\/p>\n<p>You choose a method to unlock your worksheet and continue using this powerful tool for data analysis!<\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are unable to edit data entered in your Excel worksheet and you are not sure how to fix it, you have come to the right place. There are several ways in which you can easily enable editing cells and learn how to edit cells in Excel. Excel file is read-only Excel worksheet is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24783,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to edit cells in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10],"tags":[763,765,764],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24662"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=24662"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24662\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24783"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}