We’re frequently posting new stuff each week and may just have the guide or troubleshooting tips you need. However, if you have other queries, consider looking at the rest of the site. If you have any more Office 365 related queries, please consult our related articles (listed below). We’d be pleased to know you found this post useful and/or informative. FarewellĪs usual, this section is dedicated to thanking readers for their support. The latter being the deletion of inactive table space. The first being, saving your file and opening it with the Excel 97-2003 Workbook format. If you’re having issues inserting new rows to your Excel tables, you may be able to resolve the issue via one of two methods. Assuming everything went well, this solution has worked for you, and you are able to insert a new row to your table.Step 4 -Try insert a new row to your table This will ensure any saveable space is made available by erasing any content within the selected area. From the resulting context menu find and click Delete. Access the context menu by right clicking your selection.Step 3 – Select Delete via the context menu Select the entireity of the row by using ctrl+shift+right twice, followed by ctrl+shift+down twice. If the last used row (with content) in your table is row 4, you would select row 5.Step 2 – Select the inactive space below the active area of your table The deletion method Step 1 – Open your Microsoft Excel worksheet Assuming everything went well, this solution has worked for you, and you are able to insert a new row (or column) to your table.Step 6 -Try insert a new row to your table To open a file form your recent files section, simply click it. If you can’t find it select Open and manually find your file. Follow up by opening your worksheet via the recent files section. First repeat step 2 to open the file menu.Step 5 – Re-open your file via the file menu After doing so, you may select the Save button. After clicking the dropdown, you will need to find and select the option Excel 97-2003 Workbook. After inputting a memorable filename, you’ll need to use the filetype dropdown below the filename text box.Step 4 – Save your file with the Excel 97-2003 Workbook format In this case we will be using our OneDrive documents folder for the demo. So long as you can get back to your file later, it doesn’t really matter where you save it.Open the file menu via the tab ribbon by selecting File.Open the worksheet with which you’re experiencing difficulties inserting new table rows.The file save method Step 1 – Open your Microsoft Excel worksheet Here we will be providing a step-by-step guide with pictures for two solutions to this problem. If you are looking for a guide on preventing row insertion failures, then this post is ideal.

Saving the file under a particular type and reopening itĬlear/deleting all columns/row beyond the active area That much is true for your newfound inability to insert new rows (or perhaps even columns) to your tables.

Unfortunately, this does not always operate correctly- sometimes in such a way that we can’t find a cause. Microsoft Excel offers tables as a means to structure our data and accelerate the process of adding additional data.

Microsoft excel cant insert new cells