Forum Discussion
Select cells diagonally
If I have a table with 20 rows and 20 columns, how can I insert the value '1' across the entire diagonal of the table quickly? I would like to know if there is a way to select the cells diagonally a...
I don't know what the sheet looks like, but I'll put this out there as an option (and because MUNIT is rarely mentioned).
=MUNIT(20)
(Custom cell formatting is hiding the 0s)