Insert rows above / below

[geoffL]

‘Insert rows above/ below’ has disappeared from the context menu. Problem only in one particular sheet. When I untick ‘Sheet Protect’ the OK button becomes grey.

[Zizi64]

@geoffL

Problem only in one particular sheet.

Please upload a sample file here.

[geoffL]

Hello @Zizi64

Thank you for responding.

I have uploaded the file which contains the problem sheet.

ProblemSheet.ods (63.4 KB)

I hope you receive this.

[Zizi64]

You are using the function TRANSPOSE() in that area of the sheet. There is not any way to insert a row inside the transposed range what uses the array function.

[Zizi64]

You can use the function INDIRECT() instead of the TRANSPOSE():

ProblemSheet_INDIRECT.ods (52.6 KB)

[geoffL]

Hello @Zizi64

Many thanks for your help.