Hello @eagleview5267, You are most welcome. We are glad it helped simplify things for you. Sometimes, keeping it simple really is the best approach! 😊 Keep learning Excel with ExcelDemy! Regards ExcelDemy
Hello @lisasmith7601, We also used Microsoft Excel 365. Downloaded Excel file works but it doesn't works in your environment so it seems you might not have completed all the necessary steps in the "Options" settings for Excel 365. If not, may be this is the reason the method isn't working as expected. Please double-check the specific steps in the video from 00:48 to 1:36 related to the "Options" settings. Those are crucial for enabling the automatic row addition feature in Excel 365. To enable the feature where Excel automatically adds a new row to a table: 1.Click on File >> select >> Excel Options >> navigate to the >> Proofing section, 2. Then check >> Include new rows and columns in table and Fill formulas in tables to create calculated columns. Let us know if you need further assistance! Regards ExcelDemy
Hello @gouravrathorr, if you want to use the above Table, you can download it from here: www.exceldemy.com/wp-content/uploads/2022/04/Excel_Table_Automatically_Add_New_Row-1.xlsm Then insert a new row by following the methods described in the video: To use a new row inserted in a table from an above table, you can set up your Excel so that any new row added to the table above is automatically included in your references or formulas. This can be done using structured references, which automatically adjust to include new rows. If you want you can follow the article also: www.exceldemy.com/excel-table-automatically-add-new-row/ Regards ExcelDemy
Was that an AI video??? The speaker's broken English seemed to have flaws in the common broken English mistakes. It seemed liked it was a compilation of several broken English accents.
Great video though! Gave different methods for doing this that I found very useful. The method I'm using breaks sometimes. Will try some of the other ones shown here.
Dear @timkropf4648, Thanks for your appreciation. If you are facing any problem regarding any methods you can post it in our ExcelDemy Forum: exceldemy.com/forum/ Regards ExcelDemy