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 to read, so the …

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 contents.

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 in the sheet …

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.

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 because I have the …

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 enter …

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 have a …

Mar 18, 2022 · Hello Why when sheet protected (table not protected), and I write in the next table row, table not expanding? While if sheet not protected, expanding working Any idea..

Apr 29, 2021 · Excel is doing exactly what YOU are telling it to do. There are two option: 1. select the entire column starting with the first data row until the last row + more if more data is to come. Enter …

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 it does …