2019-10-20 16:03:35 +0100 received badge ● Notable Question (source) 2019-10-20 16:03:35 +0100 received badge ● Famous Question (source) 2018-09-11 18:34:36 +0100 received badge ● Popular Question (source) 2018-09-11 12:55:47 +0100 marked best answer Sort containing column labels in protected cells Hello, I have a sheet like this : =============================== | LABEL 1 | LABEL 2 | LABEL 3 | <-- 3 protected cells =============================== | data 1 | data 2 | data 3 | |---------+---------+---------| | data 4 | data 5 | data 6 | |---------+---------+---------| | data 7 | data 8 | data 9 | |---------+---------+---------| I need to protect first row containing column labels. But when I try to sort data using a macro or using Sort menu, selecting LABEL 1 as Sort Key 1 and specifying in Options that range contains colum labels, operation fails due to cell protection even if protected cells (labels) do not have to be modified. Is it a bug ? Is there a workaround ? Thanks in advance Ed 2018-09-11 12:55:47 +0100 received badge ● Scholar (source) 2018-09-11 11:59:23 +0100 asked a question Sort containing column labels in protected cells Sort containing column labels in protected cells Hello, I have a sheet like this : =============================== | L 2018-09-08 03:07:08 +0100 received badge ● Famous Question (source) 2018-08-29 13:25:55 +0100 commented answer How to duplicate last row with formulas in a macro ? Sorry, I have no enough points to mark my question as solved by my own answer. 2018-08-29 13:19:14 +0100 answered a question How to duplicate last row with formulas in a macro ? I've finally found a solution inspired from an answer to an other question mixed with a recorded macro. Probably ugly f 2018-08-29 02:23:55 +0100 commented question How to duplicate last row with formulas in a macro ? Sorry, my prior example only shows results after calculation. Second column "Sums" contains the sum of "Product1 + Prod 2018-08-27 19:57:07 +0100 received badge ● Teacher (source) 2018-08-27 09:15:57 +0100 received badge ● Notable Question (source) 2018-08-26 19:37:16 +0100 edited question How to duplicate last row with formulas in a macro ? How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o 2018-08-26 19:34:54 +0100 received badge ● Editor (source) 2018-08-26 19:34:54 +0100 edited question How to duplicate last row with formulas in a macro ? How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o 2018-08-26 19:34:15 +0100 edited question How to duplicate last row with formulas in a macro ? How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o 2018-08-26 18:55:28 +0100 answered a question What are the "autosave" options, and where is work saved? Hello, Under "tools" there are no "options" "Options" is the last/lowest item in "Tools" menu, just after "Customi 2018-08-26 15:59:47 +0100 received badge ● Popular Question (source) 2018-08-25 22:41:06 +0100 asked a question How to duplicate last row with formulas in a macro ? How to duplicate last row with formulas in a macro ? Hello, I'd like to create a button for adding rows at the bottom o