Dec 30, 2023 · Re: Cannot extend table or database 3862 lines isn't a problem for Excel, you problem may be other then that, since it is too old the new feature of array might be interfering …

Apr 22, 2021 · Re: Protect sheet but keep table expandable I would apply Data Validation over the top of the table column to only allow an arbitrary text string (eg, "Password") to replace the …

Sep 5, 2014 · Re: Extend table formatting in new rows? Sorry newdoverman, not sure I follow you. It seems that excel is applying some sort of formatting that makes my data more difficult …

Dec 1, 2017 · Re: Table formatting does not extend when new table rows are auto-created (Excel 2016) You can use format painter to copy the formats to next cells.

Feb 9, 2023 · I have a table that I want my users to be able to expand to the right with new data, if needed. This table is on a sheet that I need to protect. When the sheet is unprotected and I …

Nov 3, 2023 · Is there any way to expand a Table in a spreadsheet protected with a password, without using macros? Some organizations block spreadsheets containing macros, so there is …

Feb 17, 2017 · When I add a new row to the table all the data validations and conditional formulae extend with it, except one—the drop-down data validation in column [H]. Column [H] should …

Mar 28, 2018 · Re: Excel 2016 does not extend table I've been there and that box is checked. I even toggled it. Besides, that does not answer the question why it takes only the first row. Also …

Apr 22, 2022 · Table Not Expanding When Pasting Data I have some tables that I paste data at the end with a macro, but the table doesn't auto expand. If I type manually it does. Funny …

Dec 8, 2022 · Formula to extend to next day in an Excel Table Dear All, I am using Excel 2013 and I am attaching a sample of the problem I am currently facing in an Excel Table. In the …