My question is a very simple one. I want to write "1" in the range A1:Z1. I know there is a way to do this rather than copy pasting those values.

I tried shift + select the range and then write 1 but it writes in only a1. I would appreciate if you help me on this.

Thanks in advance.